Log in

View Full Version : Problem installing vbadvanced cmps


juke123
02-08-2014, 04:55 PM
This Happens when i try to install vb cmps



vBulletin? Version 3.8.2
Database error in vBulletin 3.8.2:

Invalid SQL:

CREATE TABLE IF NOT EXISTS adv_setting (
varname varchar(100) NOT NULL default '',
grouptitle varchar(50) NOT NULL default '',
value mediumtext NOT NULL,
defaultvalue varchar(250) NOT NULL default '',
optioncode mediumtext NOT NULL,
displayorder smallint(3) unsigned NOT NULL default '0',
serialize smallint(3) unsigned NOT NULL default '0'
) =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 '=MyISAM' at line 9
Error Number : 1064
Request Date : Saturday, February 8th 2014 @ 11:53:26 AM
Error Date : Saturday, February 8th 2014 @ 11:53:26 AM
Script : http://www.REMOVED.com/main/admincp/vbacmps_install.php
Referrer : http://www.REMOVED.com/main/admincp/vbacmps_install.php
IP Address : **.**.**.**
Username : Moostorm
Classname : vB_Database
MySQL Version : 5.

After doing Research i found that most people fixed this by removing 2 tags in the install php file

if (version_compare($mysqlvers['version'], '4.0.18', '<'))
{
$enginevar = 'TYPE';
}

I did remove it and still I think the type is wrong..

has anyone found a fix for this?

ozzy47
02-08-2014, 05:05 PM
Questions/Problems regarding modifications/styles need to be asked in the modification/style thread. That is where the support for modification/style is - not out here in the main forums. Please note that if a modification/style is unsupported (or even if it says it is supported), you may be on your own if you chose to install it.