coppermine-gallery.com/forum

Support => cpg1.5.x Support => cpg1.5 plugins => Topic started by: nicopilami on December 16, 2013, 09:47:05 PM

Title: smart catlist
Post by: nicopilami on December 16, 2013, 09:47:05 PM
Hi
I installed the plugin "smart catlist", but then... BOUM !!!


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

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

I guess it is a "c." that has to be added, but where and in wich file ?

Thanks
Nico
Title: Re: smart catlist
Post by: ΑndrĂ© on December 17, 2013, 09:19:32 AM
Quote from: nicopilami on December 16, 2013, 09:47:05 PM
I installed the plugin "smart catlist"
I cannot find such a plugin for cpg1.5.x.

Quote from: nicopilami on December 16, 2013, 09:47:05 PM
I guess it is a "c." that has to be added, but where and in wich file ?
Quote from: nicopilami on December 16, 2013, 09:47:05 PM

in index.php on line 381