Inactive
- Join Date:
- Feb 2007
- Posts:
- 211
- Plugin Contributions:
- 0
[Duplicate] I believe I found a v1.3.7 defect with an apostrophe in an address?
Zen Cart 1.3.7.1
Database Patch Level: 1.3.7.1
Entered an order into my store. During the middle of the input, when I got an error stating "that kind of card isn't taken", I went into the admin and enabled that type of credit card. I then went back to checkout in my account, entered everything - credit card PROCESSED, but then I got an SQL error -
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 'Neill Ct. [x_city] => removed[x_state] =>removed [x_zip] => removed ' at line 1
in:
Looks to me that the error was because the apostrophe isn't supported in the address - although accepted as an address in hte cart itself. The street name is O'Neill ...
I have full text and will provide upon request...
And yes - I should update. The store is a private one, and gets about $100 of orders a quarter - it's low on the priority list.:blush: