I downloaded the old oscommerce customer database into excel format, added the extra columns so it matched the oscmax format, converted it to sql and imported it with no problems. I received the following error when going to the Customers/customers in the admin.
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 '' at line 1
SELECT DISTINCT customers_id, customers_notes_id, customers_notes_message, customers_notes_editor, customers_notes_date FROM customers_notes WHERE customers_id =
Where is the customers_notes_id, customers_notes_message, etc coming from? There are no columns with the word notes in them. I then took just one new entry, making sure it matched exactly with the original oscmax entries and still get the same error. Putting the original oscmax customers database back in solved the problem. How can I get the oscommerce customers database into the new oscmax customers database?