Support > cpg1.5 upgrading

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

(1/1)

rixter:
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

Αndré:
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.

rixter:
You are awesome! All fixed.

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

Joachim Müller:
Probably was added by a plugin.

Please resolve your thread as suggested per board rules.

Navigation

[0] Message Index