Advanced Search Result error 1064 You have an error in your SQL syntax;

[baracudamax]

When i search for something i get :

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


please help me....

[kobra]

How about some additional info??

http://www.zen-cart.com/forum/faq.php

[baracudamax]

Thank you for fast reply...

ex. When i use advance search to find a product i get this error...

see it your self please...

http://www.e-matrix.gr

[kobra]

Still need much of the info outlined in the link

[baracudamax]

http://www.e-matrix.gr/index.php?mai...valon&x=36&y=6

[kobra]

Can't you read?

You should include answers to all of these questions:

• What version of Zen Cart?
  
• Is it a new install or an upgrade?
  
• What the addons/contributions you have installed?
  
• What customizations have you made?
  
• What type of server are you using?
  
• Are you installing locally?

• What operating system?

• What version of PHP is installed on the server?
  
• What version of MYSQL is installed on the server?
  
• What you were doing when your problem occurred?
  
• What are the steps to reproduce the problem?
  
• Have you attempted to fix the problem?

• What steps have you taken?

• Any other details that might be important, i.e. the port number

[baracudamax]

Zen Cart 1.3.8a
Patch: 1::
Database Patch Level: 1.3.8
v1.3.8 [2009-10-12 03:09:25] (Fresh Installation)

Server OS: Linux 2.6.18-164.15.1.el5
Database: MySQL 5.0.77
average: 0.65, 0.35, 0.22
HTTP Server: Apache/2.2.3 (CentOS)
PHP Version: 5.1.6 (Zend: 2.1.0)

installed modules:

Google Analytics
Printable Price-list
Super Tracker
Hints and Tips
Fast and Easy Checkout
Google Map
Simple SEO URL 3.8.5
Sitemap XML
Quick Updates
Super Orders
Recover Cart Sales
Advanced Cross-Sell
Ty Package Tracker
Auction Manager
Simple Popup
Restock Requests
Products Gallery
Add Customer from admin
flat rate clone
Recover Cart Sales
Contest system
STOCKINHAND Calculator
Sales Report
Real Stock Qty
Poll Manager
Quick Layout Box Controller
Change Storage Engine
Image Handler2
Orders Export
BackUp ZenCart
UN Wishlists
Click show hide categories
Advanced search categories
login box
dg reviews
best sellers reloaded
main page categories

the 3 last modules installed are:

simple popup
ssu 3.8.5 update
click show hide cadegories

[kobra]

Too many addons....

When did this begin?
Was there any additions/changes in that time frame?
What were they?

What does Change Storage Engine do and what did you change it to?

[baracudamax]

Everything's worked fine until i have installed simple popup , ssu 3.8.5 update and click show hide categories.
The storage engine changer can mass change storage engine of your database.

Innodb i'm using.

[kobra]

Everything's worked fine until i have installed simple popup , ssu 3.8.5 update and click show hide categories.

Undo/remove these three
Check
Add back one at a time and check