Search result error plz help

[omerhanif]

Hi, please help me out

I am getting follwoing error when seach is done on my site www.pcitshop.com

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 ' , , cd.categories_description, cd.categories_id, c.parent_id from zen_categori' at line 1
in:
[SELECT DISTINCT c.categories_image, cd.categories_name, , , , cd.categories_description, cd.categories_id, c.parent_id from zen_categories_description cd, zen_categories c where cd.categories_id = c.categories_id and cd.language_id = '1' AND ((cd.categories_name LIKE '%acer%' OR cd.categories_description LIKE '%acer%') and (cd.categories_name LIKE '%laptop%' OR cd.categories_description LIKE '%laptop%') ) order by cd.categories_name]


Regards

[omerhanif]

Any help please?

[baracudamax]

Hello, i have the same problem... and i see that you solved it
Please help me...

http://www.e-matrix.gr