Phoca Gallery Search
Posted: 09 Jan 2010, 06:51
I am trying to provide a search for images in Phoca Gallery using the standard Joomla search module. I have the Phoca Gallery Search plug-in installed and published. When a search is requested (search 'tree' in this example) I get this error message:
Regards,
Bill
Any help is very much appreciated.500 - JDatabaseMySQL::query: 1054 - Unknown column 'a.approved' in 'where clause' SQL=SELECT a.id, a.title AS title, "" AS created, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, a.description AS text, CONCAT_WS( " / ", 'Phoca Gallery', a.title ) AS section, "2" AS browsernav FROM jos_phocagallery_categories AS a WHERE ( a.title LIKE '%tree%' OR a.name LIKE '%tree%' OR a.description LIKE '%tree%' ) AND a.published = 1 AND a.approved = 1 AND a.access <= 2 GROUP BY a.id ORDER BY a.title ASC LIMIT 0, 50
Regards,
Bill