Hi,
A worker blew it and reset the admin log without backing up the database and now i'm getting this error on checkout:
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 'Meally(qty: 1) + _Family Affair Beanie(qty: 1) [Date] => December 16, 2008,' at line 1
in:
any idea how to fix this problem?
Results 1 to 2 of 2
-
16 Dec 2008, 11:04 PM #1
New Zenner
- Join Date
- Jul 2007
- Posts
- 23
- Plugin Contributions
- 0
1064 You have an error in your SQL syntax
-
18 Dec 2008, 06:12 AM #2
Sensei
- Join Date
- Jan 2004
- Posts
- 66,373
- Blog Entries
- 7
- Plugin Contributions
- 274
Re: 1064 Error
Sounds like you have an addon that's not able to handle quotation marks in the data it's trying to store to the database.
.
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.
Similar Threads
-
1064 - You have an error in your SQL syntax
By jason.b in forum Templates, Stylesheets, Page LayoutReplies: 3Last Post: 27 Aug 2012, 05:50 PM -
1064 You have an error in your SQL syntax
By jencdesigns in forum General QuestionsReplies: 0Last Post: 23 Sep 2010, 01:46 AM -
1064 You have an error in your SQL syntax;
By ndr2010 in forum General QuestionsReplies: 10Last Post: 19 Apr 2010, 08:36 PM -
1064 You have an error in your SQL syntax
By techie in forum Basic ConfigurationReplies: 1Last Post: 13 May 2006, 03:53 PM
Bookmarks