I have uploaded impex and edited the config
When I click on Import in ACP I ge this:
There seems to have been a problem with the database.
ImpEx Database error
mysql error: Invalid SQL: CREATE TABLE vbimpexerror (
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: Tuesday 09th 2014f December 2014 01:55:46 PM
Database: pete_stolen_v4
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
can anyone help please?
Thanks
When I click on Import in ACP I ge this:
There seems to have been a problem with the database.
ImpEx Database error
mysql error: Invalid SQL: CREATE TABLE vbimpexerror (
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: Tuesday 09th 2014f December 2014 01:55:46 PM
Database: pete_stolen_v4
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
can anyone help please?
Thanks
Comment