"JInstaller: :Install: Error SQL DB function failed with error number 1064
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 14 SQL=CREATE TABLE IF NOT EXISTS `hlvaf_gameserver` ( `serverid` int(11) NOT NULL auto_increment, `displayname` varchar(255) NOT NULL default '', `type` varchar(255) NOT NULL default '0', `ip` varchar(50) NOT NULL default '', `port` varchar(10) NOT NULL default '', `port2` varchar(10) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `user` varchar(255) NULL default '', `pass` varchar(255) NULL default '', `url` varchar(1000) NULL default '', PRIMARY KEY (`serverid`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `#__gameserver` (
`serverid` int(11) NOT NULL auto_increment,
`displayname` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '0',
`ip` varchar(50) NOT NULL default '',
`port` varchar(10) NOT NULL default '',
`port2` varchar(10) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`user` varchar(255) NULL default '',
`pass` varchar(255) NULL default '',
`url` varchar(1000) NULL default '',
PRIMARY KEY (`serverid`)
) TYPE=MyISAM;
Component Install: SQL error file DB function failed with error number 1064
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 14 SQL=CREATE TABLE IF NOT EXISTS `hlvaf_gameserver` ( `serverid` int(11) NOT NULL auto_increment, `displayname` varchar(255) NOT NULL default '', `type` varchar(255) NOT NULL default '0', `ip` varchar(50) NOT NULL default '', `port` varchar(10) NOT NULL default '', `port2` varchar(10) NOT NULL default '', `ordering` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `user` varchar(255) NULL default '', `pass` varchar(255) NULL default '', `url` varchar(1000) NULL default '', PRIMARY KEY (`serverid`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `#__gameserver` (
`serverid` int(11) NOT NULL auto_increment,
`displayname` varchar(255) NOT NULL default '',
`type` varchar(255) NOT NULL default '0',
`ip` varchar(50) NOT NULL default '',
`port` varchar(10) NOT NULL default '',
`port2` varchar(10) NOT NULL default '',
`ordering` int(11) NOT NULL default '0',
`published` tinyint(1) NOT NULL default '0',
`user` varchar(255) NULL default '',
`pass` varchar(255) NULL default '',
`url` varchar(1000) NULL default '',
PRIMARY KEY (`serverid`)
) TYPE=MyISAM;"