Category Display Error

[urbanstorm]

I am getting an error message when trying to view categories within my gallery. Here is an example from one of them:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':charcoal' at line 1 SQL=SELECT cat.description FROM tkcje_categories cat WHERE cat.id=4:charcoal

The category list page displays fine but I get this message after clicking on any of the categories.

I am running the following:

PHP Version 5.3.27
Database Version 5.5.32-cll
Joomla! 3.3.1 Stable
Phocagallery 4.1.0

[Jan]

Hi, where do you get this error? This sql query is not a part of Phoca Gallery, try to check the template and modules which are loaded on that site, if such error is not caused there

Jan

[urbanstorm]

Thanks for the reply. I am not getting this error anywhere else on the site. Here is the category page, if you click on any of the categories you will see the error http://roosterbrick.com/gallery

[Jan]

Hi, I see but this should not have anything to do with Phoca Gallery, as Phoca Gallery does not ask _categories table

Try to disable all modules on that site to be sure no other module calls the categories table
Try to check all the system plugins if some of them does not call categories table
Is your Phoca Gallery without customization?

Try to enable debug mode which then should tell you in which file the error is comming

The one sql query is not a Phoca Gallery query.

Jan

Jan

[urbanstorm]

Thanks Jan. It looks like it was the plugin SEOSimple causing the error. I have disabled it for now and will try to figure out if I can get them working together :/

[Jan]

Ok

[clubemotions]

In case anyone stumbling across this error.
You need to edit seosimple.php (plugin directory):

Line 104, change

Code: Select all

if ($view == 'category' && $catdesc == 0) {

to

Code: Select all

if ($view == 'category' && $catdesc == 0 && JRequest::getVar('option') == 'com_content') {

and it should work fine with Phoca!

regards
Jan @ pixeltraum.tv