Search error

Hi.

I am now running 1.3.5. and testing everything.

I just tried to test the search page, and on entering a search query I get the error:

Warning: constant() [function.constant]: Couldn't find constant in /home/woodgate/public_html/includes/init_includes/init_add_crumbs.php on line 45

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]

I have not edited this file at all, and cannot see anything like this line in my file.

Any ideas?

Regards Chris

http://www.zen-cart.com/forum/showthread.php?t=47443&highlight=manufacturers_id

Hi.

Thanks for the reply.

Im not sure if it was the right thing to do, but as I dont have a list of manufacturers (I sell books)
I cut the following section from the tpl_advanced_search_default.php file: (in my overide file!)

This has cleared all reference to the manufacturers on my search form, and solved my error problem at the same time.

I have tested it and it seems to be fine now.

Many thanks
Chris