I have new installation of vB 4.2.3 and just installed impex so I can import from my old vB 4.0.2 (I think that is the version). Anyway, I configued the ImpExConfig.php to have the database info for the source and target and double-checked the info.
When I click on the "import" link in my ACP, and put in my customer number, I get the following error:
Code:
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: Thursday 21st 2016f April 2016 10:41:42 PM
Database: HidingPlaceForums
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
I know that the1064 erro means that it did not understand the command sent to it.
Ideas?
04-21-2016, 10:51 PM
mysql error number: 1064
Hybrid Mode
