SQL Error on Advanced Search

[iWebGeek]

I get this SQL error whenever I try to do an Advanced Search.

Any tips or fixes would be appreciated. I'm running version 1.3.5 with MySQL on a Linux server.

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 'from where manufacturers_id = 0' at line 2
in:
[select from where manufacturers_id = 0]

[Ajeh]

Looks like it does not know the database table name in the statement ...

Check your code against a clean Zen Cart v1.3.5 and see if you have altered something ...

Have you an URL where you are getting this?

[iWebGeek]

go to www.oclumberstore.com and try an advanced search

I'll check the code and post my results.

[Ajeh]

Peek in here for the fix for that error ...
http://www.zen-cart.com/forum/showthread.php?t=45377

[iWebGeek]

I tried Fix #6..

I got this error in PHPMyAdmin:

Error

SQL query:

#
# Updating table `get_terms_to_filter`
#
ALTER TABLE get_terms_to_filter ADD get_term_table varchar( 64 ) NOT NULL ;

MySQL said: Documentation
#1146 - Table 'oclumber_zc2.get_terms_to_filter' doesn't exist

[Ajeh]

You will need to adapt that line if you are using table prefixes in your database ...

Or, run the line in your Zen Cart Admin ... Tools ... Insert SQL Patch ... and it will manage the changes for you ...

[iWebGeek]

I did it from the Zen admin.. it worked.

Thanks!