Error 1064 means Manufacturer search doesn't work

[robhaworth]

Hi there,

On my site, if you click on any of the manufacturers in the scroll-box you get the following error - anyone got any ideas?

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

Running the latest version

Thanks

Rob

[kobra]

Can't see your site???

How about a link?

A default install with default files - installed correctly does not exhibit this so I would venture that you have something amis - files or DB

See this default install HERE

[robhaworth]

Hi there - yes, its www.peakhire.com

[kobra]

What version of Zen Cart is this?
Was it a fresh install or has it been upgraded?

Check install ver & history at admin > tools > server/version info