Phoca Gallery Search

[cecilbadlands]

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:

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

Any help is very much appreciated.
Regards,
Bill

[Jan]

Hi, which version of Phoca Gallery component do you run?

a) you run obsolete version and search plugin cannot find a.approved column
b) you run up-to-date version but while upgrading no approved column was upgraded, so this needs to be done manually with install.bak file

Jan

[cecilbadlands]

Hi Jan,
Yes, I was running an older version of the Phoca Gallery component. I have downloaded the latest version but I will have to install it via FTP. I will let you know how it works out. Thank you for the information and quick reply.
Regards and Thanks again!
Bill

[Jan]

Ok

[cecilbadlands]

After installing the updates the search module is working. Thanks! Now I have a couple more questions.
1. - The search result doesn't show the thumbnails.
2. - The search finds my related Virtuemart products as well.

Regards and thanks for any guidance,
Bill

[Jan]

Hi, search results code is a part of Joomla! framework, so if you want to add the thumbnails there the Joomla! core code needs to be customized (search this forum for the code, there are some tips)

Search function in Joomla! search in every parts of Joomla! if this is not disabled.

Jan