Forums / Installing on a Windows Server / moving products to a new zen cart

moving products to a new zen cart

Locked

Views: 6,246

Results 21 to 21 of 21
This thread is locked. New replies are disabled.
10 Nov 2007, 3:23 PM
#21
1just4help avatar

1just4help

New Zenner

Join Date:
Nov 2007
Posts:
28
Plugin Contributions:
0

moving products to a new zen cart

Hi kuroi, i have done a back up of the old mysql as advised, when i attempt to import files i have this error

SQL query:

CREATE TABLE zen_address_book (

address_book_id int( 11 ) NOT NULL AUTO_INCREMENT ,
customers_id int( 11 ) NOT NULL default '0',
entry_gender char( 1 ) COLLATE latin1_general_ci NOT NULL default '',
entry_company varchar( 32 ) COLLATE latin1_general_ci default NULL ,
entry_firstname varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
entry_lastname varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
entry_street_address varchar( 64 ) COLLATE latin1_general_ci NOT NULL default '',
entry_suburb varchar( 32 ) COLLATE latin1_general_ci default NULL ,
entry_postcode varchar( 10 ) COLLATE latin1_general_ci NOT NULL default '',
entry_city varchar( 32 ) COLLATE latin1_general_ci NOT NULL default '',
entry_state varchar( 32 ) COLLATE latin1_general_ci 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 )
) ENGINE = MYISAM AUTO_INCREMENT =2DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci
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 'collate latin1_general_ci NOT NULL default '',
`entry_company