garrone Posted July 27, 2006 Share Posted July 27, 2006 Suddendly I get the below error when I add a product having an apostrophe in the name, but product is hovewer inserted. How can I resolve? Thanks. 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 'Avola')' at line 1 INSERT INTO products_to_products_extra_fields (products_id, products_extra_fields_id, products_extra_fields_value) VALUES ('268', '8', 'Sicilia IGT Nero d'Avola') Giovanni Putignano Link to comment Share on other sites More sharing options...
Winterchild Posted July 27, 2006 Share Posted July 27, 2006 Try putting a \ in front of it the ' Forum search Contributions search Documentation search (note: docs being adapted for MS3, may be different for MS2) 3 tips for better forum searching Want to post? Read this first: osCommerce for dummies Topic name etiquette Basics: Basics for design Right syntax to use near '-20, 20' Cannot re-assign $this Parse error Link to comment Share on other sites More sharing options...
garrone Posted July 27, 2006 Author Share Posted July 27, 2006 Many thanks. Giovanni Putignano Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.