Import problem
I installed Impex, went to import in CP, entered my customer number, and i got this:
There seems to have been a problem with the database.
ImpEx Database error
mysql error: Invalid SQL: CREATE TABLE impexerror (
errorid bigint(20) unsigned NOT NULL auto_increment,
errortype varchar(10) NOT NULL default '',
classnumber varchar(3) NOT NULL default '',
importid bigint(20) NOT NULL default 0,
error varchar(250) default 'NULL',
remedy varchar(250) default 'NULL',
PRIMARY KEY (errorid)
) TYPE=MyISAM
mysql error: 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 'TYPE=MyISAM' at line 9
mysql error number: 1064
Date: Sunday 11th 2014f May 2014 05:54:28 AM
Database: bargainf_vb4
MySQL error: 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 'TYPE=MyISAM' at line 9
-----------------------------------------------------------------------------
All that means nothing to me. Whats gone wrong and how do i fix it?
|