forum.coppermine-gallery.net

Support => cpg1.5.x Support => cpg1.5 upgrading => Topic started by: drownedgod on November 19, 2010, 06:08:53 am

Title: Critical error: There was an error while processing a database query
Post by: drownedgod on November 19, 2010, 06:08:53 am

Hi, I just upgraded 1.4 to the latest 1.5. Everything went well (I think) then when I went to the starting page. I get this error. I can still login to Admin and all but no content is showing. Please help.
 
Critical error
There was an error while processing a database query

Title: Re: Critical error: There was an error while processing a database query
Post by: drownedgod on November 19, 2010, 06:57:53 am

I turned on the debug mode and I get this. Help?

Code: [Select]

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 BETWEEN 0 + 1 AND 0 + 1
ORDER BY r.pos, r.aid' in index.html on line 379

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


Title: Re: Critical error: There was an error while processing a database query
Post by: drownedgod on November 19, 2010, 07:01:30 am

Nevermind. Saw the fix.

http://forum.coppermine-gallery.net/index.php?topic=64701.0

Title: Re: Critical error: There was an error while processing a database query
Post by: Αndré on November 19, 2010, 09:17:17 am

Moved to upgrade board and marking as solved.