jpn Posted August 22, 2006 Share Posted August 22, 2006 I am currently moving to another Web Hosting Company. I have made a back up of database and wish to install it into my new database. I am connecting to my database using MYSQL Administrator. Here is part of the SQL script insert into address_book (address_book_id, customers_id, entry_gender, entry_company, entry_firstname, entry_lastname, entry_street_address, entry_suburb, entry_postcode, entry_city, entry_state, entry_country_id, entry_zone_id) values ('360', '304', '', NULL, Joe, Bloggs, '118 Dean Road', '', 'EH 510 HD', 'Bo\'Ness', NULL, '222', '0'); Here is the error message I receive Script line: 379 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 '; insert into address_book (address_book_id, customers_id, ent Any data that has a \' in it brings the script to a halt. Any ideas on how to solve this?? Jpn PS IS there a minimum version of MYSQL that OSCommerce uses? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.