Hi, I've read a few threads about this type of error. However, nothing seemed relevant to my case.
Just upgraded from 1.3.0.2 to 1.3.5. Made a mistake and installed rather than upgraded. Dropped the new table and imported my db from a fresh backup. Everything seemed to go well except for accessing the product listing by manufacturers. Got this message, whatever manufacturer I click on:
"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 = 14' at line 2
in:
[select from where manufacturers_id = 14]"
Some threads talk about this having to do with the charset=latin2, but could not find anything like that in myphpAdmin.
So, if someone has an idea...
THX,
JP
Thread: 1064 sql syntax error
Results 1 to 3 of 3
-
7 Sep 2006, 04:51 AM #1
New Zenner
- Join Date
- Dec 2005
- Posts
- 19
- Plugin Contributions
- 0
1064 sql syntax error
-
Re: 1064 sql syntax error
.
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.
-
7 Sep 2006, 01:03 PM #3
New Zenner
- Join Date
- Dec 2005
- Posts
- 19
- Plugin Contributions
- 0
Re: 1064 sql syntax error
Fixed. Thanks a lot!
JP
Similar Threads
-
SQL Syntax error 1064 You have an error in your SQL syntax
By vxnut in forum General QuestionsReplies: 1Last Post: 25 Aug 2011, 05:58 AM -
1064 SQL syntax error
By perkiekat in forum General QuestionsReplies: 4Last Post: 12 Dec 2009, 09:13 PM -
1064 error sql syntax
By pjgscrap in forum General QuestionsReplies: 2Last Post: 5 Mar 2009, 05:04 PM -
SQL syntax error 1064
By jackzc in forum Installing on a Linux/Unix ServerReplies: 3Last Post: 27 Sep 2007, 02:29 AM
Bookmarks