Forums / Upgrading from 1.3.x to 1.3.9 / vendor / manufacturer error

vendor / manufacturer error

Locked

Views: 2,469

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
28 Sep 2006, 9:39 PM
#1
3dfrog avatar

3dfrog

New Zenner

Join Date:
Aug 2006
Posts:
28
Plugin Contributions:
0

vendor / manufacturer error

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?

29 Sep 2006, 10:42 AM
#2
cozmic avatar

cozmic

New Zenner

Join Date:
Apr 2006
Location:
Sweden
Posts:
24
Plugin Contributions:
0

Re: vendor / manufacturer error

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>
30 Sep 2006, 4:24 PM
#3
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: vendor / manufacturer error

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

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

Linda McGrath
If you have to think ... you haven't been zenned ...

**Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!**

Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
Officially PayPal-Certified! Just click here

Try our Zen Cart Recommended Services - Hosting, Payment and more ...
Signup for our Announcements Forums to stay up to date on important changes and updates!

26 Oct 2006, 9:29 PM
#4
cbo avatar

cbo

New Zenner

Join Date:
Feb 2006
Location:
colorado
Posts:
73
Plugin Contributions:
0

Re: vendor / manufacturer error

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

27 Oct 2006, 7:43 PM
#5
cbo avatar

cbo

New Zenner

Join Date:
Feb 2006
Location:
colorado
Posts:
73
Plugin Contributions:
0

Re: vendor / manufacturer error

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