forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: rixter on April 23, 2010, 09:28:09 am

Title: mySQL error: Column 'visibility' in field list is ambiguous
Post by: rixter on April 23, 2010, 09:28:09 am
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
Title: Re: mySQL error: Column 'visibility' in field list is ambiguous
Post by: Αndré 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.
Title: Re: mySQL error: Column 'visibility' in field list is ambiguous
Post by: rixter 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
Title: Re: mySQL error: Column 'visibility' in field list is ambiguous
Post by: Joachim Müller on April 23, 2010, 07:15:38 pm
Probably was added by a plugin.

Please resolve your thread as suggested per board rules (http://forum.coppermine-gallery.net/index.php/topic,55415.msg270631.html#msg270631).