SQL Error - Help !!!

[Guest]

I am moving my site to a new server, so I have installed the MS2 and was importing the database from the old one (MS1). But when I tried to import the customers database I got the same error all the time!

 

SQL query: Documentation

 

SELECT *

FROM

WHERE CONCAT_WS( "-", `customers_id` , `customers_gender` , `customers_firstname` , `customers_lastname` , `customers_dob` , `customers_email_address` , `customers_default_address_id` , `customers_telephone` , `customers_fax` , `customers_password` , `customers_newsletter` ) = "3"

ORDER BY `customers_id` , `customers_gender` , `customers_firstname` , `customers_lastname` , `customers_dob` , `customers_email_address` , `customers_default_address_id` , `customers_telephone` , `customers_fax` , `customers_password` , `customers_newsletter`

 

MySQL said: Documentation

#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 'WHERE CONCAT_WS("-", `customers_id`, `customers_gender`, `cus

 

I dont know what is happening, if anyone could help I appreciate!

 

The first line of the customers.sql is like this...

 

Dumping data for table `customers`

--

 

INSERT INTO customers (`customers_id`, `customers_gender`, `customers_firstname`, `customers_lastname`, `customers_dob`, `customers_email_address`, `customers_default_address_id`, `customers_telephone`, `customers_fax`, `customers_password`, `customers_newsletter`)

VALUES (3, 'm', 'Luiz', 'Tokuhara', '0000-00-00 00:00:00', [email protected]', 1, '000-0000-0000', '', '1ece8b4f2cd4a7fc43b5b097f42e728c:5d', '1'),

 

I have tried to upload in CVS format but I got the same error...

 

 

New server

PHP version 4.4.1

MySQL version 4.0.27-standard

Running OScommerce MS2

 

Old Server

PHP version 4.3.11

MySQL version 4.0.26-standard

Running OScommerce MS1

 

Thanks!

Luiz Tokuhara

Japan