Search for manufacturers returns MYSQL Error

11 Dec 2006, 4:23 PM

#1

New Zenner

Join Date:: Mar 2006
Location:: BC, Canada
Posts:: 79
Plugin Contributions:: 0

Search for manufacturers returns MYSQL Error

Hello, I recieve the error below when I search for Manufacturers - Could some one please explain to me how to fix this

Warning: constant(): Couldn't find constant in /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 = 16' at line 2
in:
[select from where manufacturers_id = 16]

Version 1.3.7

11 Dec 2006, 6:26 PM

#2

kobra

Black Belt

Join Date:: Aug 2005
Location:: Arizona
Posts:: 31,500
Plugin Contributions:: 4

Re: Search for manufacturers returns MYSQL Error

I do not still have a 1.3.5 installed so can not check this but know that my installs of 1.3.6 function correctly....I would first upgrade...Hope that you have used the override system to your advantage

Zen-Venom Get Bitten

11 Dec 2006, 6:43 PM

#3

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,513
Plugin Contributions:: 176

Re: Search for manufacturers returns MYSQL Error

That was a bug in the upgrade from prior version to v1.3.5.
A fix can be found in the "Known issues" discussion in the Bug Reports area.
Upgrading to 1.3.6 will also resolve it.

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

3 May 2007, 10:47 PM

#4

squid

New Zenner

Join Date:: Mar 2006
Posts:: 12
Plugin Contributions:: 0

Re: Search for manufacturers returns MYSQL Error

Hi Dr. Byte,
I am getting this exact error, but I can't seem to locate known issues under the bug fix area.

Thanks for the help!

4 May 2007, 7:53 PM

#5

squid

New Zenner

Join Date:: Mar 2006
Posts:: 12
Plugin Contributions:: 0

Re: Search for manufacturers returns MYSQL Error

Hi,
Just in case someone runs across this again, I found it here under "confirmed bugs & workarounds v.1.3.5
http://www.zen-cart.com/forum/showthread.php?t=45377