So getting this error on install. Should be using engine instead of type as engine has been removed and I believe still works in older versions of mysql.
Code:
Database error in vBulletin 3.8.7:
Invalid SQL:
CREATE TABLE vbglossar_category (
id int(11) NOT NULL auto_increment,
parentid int(11) NOT NULL default '0',
displayorder int(11) NOT NULL default '0',
name varchar(255) NOT NULL default '',
description text,
status smallint(5) NOT NULL default '0',
defaulticon smallint(5) NOT NULL default '1',
definedicon varchar(255) NOT NULL default '',
groupshow smallint(5) NOT NULL default '1',
groupshowlist varchar(255) NOT NULL default '',
PRIMARY KEY (id)
) 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 13
Error Number : 1064
Request Date : Saturday, June 4th 2011 @ 10:00:39 PM
Error Date : Saturday, June 4th 2011 @ 10:00:39 PM
Script : http://www.website.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.website.com/forums/admincp/plugin.php?do=productadd
Username : Username
Classname : vB_Database_MySQLi
MySQL Version : 5.5.11-log