Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: mySQL error: Column 'visibility' in field list is ambiguous  (Read 7729 times)

0 Members and 1 Guest are viewing this topic.

rixter

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 2
    • LASTNITESPIX is always in the mix!

Greetings, I have updated from cpg14x to the latest and greatest and the initial install was flawless. I am however encountering the following issue when attempting to view the HOME page:

While executing query 'SELECT title, r.description, keyword, category, aid, alb_hits, visibility, r.thumb, r.owner
        FROM cpg14x_categories AS c
        INNER JOIN cpg14x_albums AS r ON r.category = c.cid
        WHERE c.depth = 0 + 1
ORDER BY r.pos, r.aid' in index.php on line 370

mySQL error: Column 'visibility' in field list is ambiguous

Link to the site: http://lastnitespix.com/archive/index.php

Any help with the issue would be greatly appreciated and thank you in advance!

-Rixter
Logged
Live long and prosper.

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: mySQL error: Column 'visibility' in field list is ambiguous
« Reply #1 on: April 23, 2010, 09:45:49 am »

There is no column 'visibility' in the category table by default. Seems that you have modified your cpg1.4.x database. Remove that column and everything should work fine.
Logged

rixter

  • Coppermine newbie
  • Offline Offline
  • Gender: Male
  • Posts: 2
    • LASTNITESPIX is always in the mix!
Re: mySQL error: Column 'visibility' in field list is ambiguous
« Reply #2 on: April 23, 2010, 09:50:39 am »

You are awesome! All fixed.

I am puzzled by how that field was inserted in the first place...I didn't do it! lol
Logged
Live long and prosper.

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mySQL error: Column 'visibility' in field list is ambiguous
« Reply #3 on: April 23, 2010, 07:15:38 pm »

Probably was added by a plugin.

Please resolve your thread as suggested per board rules.
Logged
Pages: [1]   Go Up
 

Page created in 0.019 seconds with 19 queries.