When installing an error SQL

[werwolf]

Recently I've uninstalled cmps for a fresh install but an error appears when click on begin the installation process:

PHP Code:

Database error in vBulletin 3.8.4:

Invalid SQL:

        CREATE TABLE IF NOT EXISTS vbadv_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'
        ) 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
Error Number  : 1064
Request Date  : Monday, March 12th 2012 @ 07:46:49 PM
Error Date    : Monday, March 12th 2012 @ 07:46:49 PM
Script        : http://www.titanesdc.com/foros/admincp/vbacmps_install.php
Referrer      : http://www.titanesdc.com/foros/admincp/vbacmps_install.php
Classname     : vB_Database
MySQL Version : 5.5.19-cll 


vbadv_setting Check Status: OK
vbadv_setting Optimize Status: Table is already up to date

Any suggestion? Thanks.

[werwolf]

anyone?

[Brian]

I wonder if MySQL has changed back to using ENGINE instead of TYPE for tables... Try looking in your admincp/vbacmps_install.php file for 2 instances of this code, remove it, and then see if you're able to complete the installation.

PHP Code:

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


[werwolf]

Hello Brian. No recent change has been done in mysql and there is only one vbacmps_install.php file.

This error can be caused by another addon? We have many installed...

[Brian]

I did not mean changes you made in MySQL, I mean there may have been recent changes to MySQL itself.
I did not say there were two instances of your vbacmps_install.php file... I suggested that you look for two instances of the code I posted above within your install file and remove them.
No, that error could not be caused by another add-on.

[werwolf]

Now I understand..

Originally Posted by Brian

suggested that you look for two instances of the code I posted above within your install file and remove them.

That's it! Thank you!

[xoomercom]

Searched for this error via Google, got here.

Followed your directions Brian and it worked!!!. I got it updated, THANK YOU sir.

[stueyd]

this happened to me, fix above worked - thank you x

[BrentWilson]

Same issue. Thanks