Phoca Gallery Plugin SQL Error
Posted: 07 Dec 2009, 18:13
Hello, i have problem with phoca gallery plugin.
I use phoca gallery 2.6 and phoca plugin 2.6. I try to put gallery into content, but there is error when i display this content:
I use phoca gallery 2.6 and phoca plugin 2.6. I try to put gallery into content, but there is error when i display this content:
No valid database connection Unknown column 'cc.approved' in 'where clause' SQL=SELECT cc.*, a.catid, COUNT(a.id) AS numlinks, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as slug FROM jos_phocagallery_categories AS cc LEFT JOIN jos_phocagallery AS a ON a.catid = cc.id WHERE a.published = 1 AND cc.published = 1 AND cc.approved = 1 AND a.approved = 1 AND cc.id != 2 GROUP BY cc.id ORDER BY cc.ordering
No valid database connection Unknown column 'cc.approved' in 'where clause' SQL=SELECT cc.title AS text, cc.id AS value, cc.parent_id as parentid FROM jos_phocagallery_categories AS cc WHERE cc.published = 1 AND cc.approved = 1 ORDER BY cc.ordering