I'm moving the shopping cart to a new server. I did everything as stated in the tutorial however when I go to import the database I get the error below. I did notice that the server the cart was on was using Zen Cart version 1.3.9d and the new server uses 1.3.9g. Could that be the issue? What do I do?
Error
SQL query:
CREATE TABLE "zen_address_book"(
"address_book_id"int( 11 ) NOT NULL ,
"customers_id"int( 11 ) NOT NULL DEFAULT '0',
"entry_gender"char( 1 ) NOT NULL DEFAULT '',
"entry_company"varchar( 64 ) DEFAULT NULL ,
"entry_firstname"varchar( 32 ) NOT NULL DEFAULT '',
"entry_lastname"varchar( 32 ) NOT NULL DEFAULT '',
"entry_street_address"varchar( 64 ) NOT NULL DEFAULT '',
"entry_suburb"varchar( 32 ) DEFAULT NULL ,
"entry_postcode"varchar( 10 ) NOT NULL DEFAULT '',
"entry_city"varchar( 32 ) NOT NULL DEFAULT '',
"entry_state"varchar( 32 ) DEFAULT NULL ,
"entry_country_id"int( 11 ) NOT NULL DEFAULT '0',
"entry_zone_id"int( 11 ) NOT NULL DEFAULT '0',
PRIMARY KEY ( "address_book_id" ) ,
KEY "idx_address_book_customers_id_zen"( "customers_id" ) ) AUTO_INCREMENT =8;
MySQL said:
#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 '"zen_address_book" (
"address_book_id" int(11) NOT NULL,
"customers_id" int(' at line 1
##############################___
Stacee Edwards
Bookmarks