PDA

View Full Version : Impex: XenForo to vBulletin issue


stickskills
12-16-2012, 09:28 PM
I've been trying to import our forum from Xenforo to vBulletin, but I'm running into the same persistent issue. I've double & even triple-checked the database information and it's all correct. Anyone have an idea on what's going on?

ImpEx Database error

mysql error: Invalid SQL: CREATE TABLE vb_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 16th 2012f December 2012 04:25:22 PM
Database: **********
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

mokujin
12-16-2012, 09:35 PM
<a href="https://www.vbulletin.com/forum/showthread.php/376342-impex-database-error" target="_blank">https://www.vbulletin.com/forum/show...database-error</a>

stickskills
12-16-2012, 09:40 PM
https://www.vbulletin.com/forum/showthread.php/376342-impex-database-error

Nevermind. There was a misconfigured setting that I fixed after applying what you showed me. Thank you for your help!