Hi,
we are having a hard time importing the database from our old phpbb3 forum that runs on mysql v5.
This is the error message we get:
ImpEx Database error
mysql error: Invalid SQL: CREATE TABLE xda_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
Any help is much appreciated.
Thank you
we are having a hard time importing the database from our old phpbb3 forum that runs on mysql v5.
This is the error message we get:
ImpEx Database error
mysql error: Invalid SQL: CREATE TABLE xda_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
Any help is much appreciated.
Thank you
Comment