vendor / manufacturer error

[3dfrog]

Hi

I just updated to 1.3.5 Everything looks good. Except when I click on a vendor name in my vendor box (which is just manufacturers and I cnahged the name) I get this error:

Warning: constant() [function.constant]: Couldn't find constant in /home/dpvl/public_html/store/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 = 1' at line 2
in:
[select from where manufacturers_id = 1]

my web store is http://www.3dfrogstore.com

Any ideas why this is happening?

[cozmic]

Hi,

I get a similar error also after upgrading from v1.3.0.1 to v1.3.5. Also interested how to fix this.

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

[Ajeh]

Might peek at the Bug Fixes for v1.3.5 ...

http://www.zen-cart.com/forum/showthread.php?t=45377

[CBO]

Just upgraded from 1.3.2 ->1.3.5 9042006.zip source and applied security fix.

I have this same error of...

Warning: constant() [function.constant]: Couldn't find constant in C:\Program Files\xampp\htdocs\zen32\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 = 6' at line 2
in:
[select from where manufacturers_id = 6]


After applying SQL code as noted in the 1.3.5 bug fixes my error has changed to this.....

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

Almost looks like the sql patch didnt work so I tried to reapply and got a bunch of errors stating the entries already exist.
Now the thing here is that my test site worked XAMPP on WinXP but when I did this in production (Win2003/IIS) it didnt fix the issue.

Any Ideas what this may be?

Thanks

[CBO]

I've downgraded my production site back to 1.3.2 and the error is gone.
Im going to try and upgrade again but with 1.3.6 this time since it was just released.
Thanks