LowCastle Posted February 8, 2007 Share Posted February 8, 2007 I am using version 2.8.5. I just updated from 2.8.2. I ran into an error when using the Order Editor to edit an order from a customer who had an apostrophe in his City name. Here is the error, with the customer's personal information edited for privacy: 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 'Alene', customers_state = 'Idaho', customers_postcode = '83814', ' at line 6 UPDATE orders SET customers_name = 'Richard Smith', customers_company = '', customers_street_address = '800 N Crestview dr', customers_suburb = '', customers_city = 'Coeur d'Alene', customers_state = 'Idaho', customers_postcode = '83814', customers_country = 'United States', customers_telephone = '(208) 555-5555', customers_email_address = 'firstname.lastname@example.org', billing_name = 'Richard Smith', billing_company = '', billing_street_address = '800 N Crestview dr', billing_suburb = '', billing_city = 'Coeur d'Alene', billing_state = 'Idaho', billing_postcode = '83814', billing_country = 'United States', delivery_name = 'Richard Smith', delivery_company = '', delivery_street_address = '800 N Crestview dr', delivery_suburb = '', delivery_city = 'Coeur d'Alene', delivery_state = 'Idaho', delivery_postcode = '83814', delivery_country = 'United States', payment_method = 'Purchase Order Account', currency = 'USD', currency_value = '1.00000000', cc_type = '', cc_owner = '', cc_number = '', cc_expires = '', shipping_tax = '0.0' where orders_id = '36'; I'm assuming that I somehow need to implement the tep_html_no_oe_quote function to strip the apostrophe but I'm new to PhP. Can anyone help with this? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.