Hi support,
i have this error:
Database error in vBulletin 4.2.2:
Invalid SQL:
CREATE TABLE vbyellowpage_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 '',
allowhtml smallint(1) NOT NULL default '0',
allowbbcode smallint(1) NOT NULL default '1',
allowsmilies smallint(1) NOT NULL default '1',
linkurl tinyint(1) NOT NULL default '0',
banner tinyint(1) NOT NULL default '0',
thumbnail tinyint(1) NOT NULL default '0',
googlemap tinyint(1) NOT NULL default '0',
picturelocation text,
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 21
Error Number : 1064
Request Date : Saturday, August 2nd 2014 @ 10:30:35 PM
Error Date : Saturday, August 2nd 2014 @ 10:30:36 PM
...
Classname : vB_Database
MySQL Version : 5.5.31-0+wheezy1
|