Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: mySQL error: Column 'visibility' in field list is ambiguous  (Read 7731 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.017 seconds with 19 queries.