Database error

[CoZmicShReddeR]

I am trying to install VB Advanced get a database error please help

Thanks

My Error:

Database error in vBulletin 4.1.4:

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'
) 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 : Tuesday, June 21st 2011 @ 11:16:26 AM
Error Date : Tuesday, June 21st 2011 @ 11:16:27 AM
Script : http://www.cozworld.com/admincp/vbacmps_install.php
Referrer : http://www.cozworld.com/admincp/vbacmps_install.php
IP Address : 99.158.234.165
Username : CoZmicShReddeR
Classname : vB_Database
MySQL Version : 5.5.8-log

[CareyCrew]

That may be a MySQL version issue but in any case vBulletin v4.1.4 is not compatible with vBa at present.

The CKEditor and changes to Forum Home which this vBulletin update brought have broken quite a list of modifications, Brian is working on updates for his products here.

[Our Sponsors]

[CoZmicShReddeR]

I am using a newer database but haven't had any issues installing stuff through it. Usually the issue is with the PHP I am using but in any case I was hoping to switch to VBA had issues with the VBCMS now am stuck in the middle I guess..

Thanks for the info on the vBulletin v4.1.4 compatibility issues..

[drewrymedia]

Did you use FTP or SSH when upgrading your site ?

[Our Sponsors]

[TeknoSounds]

Def. a mysql issue. TYPE has been depreciated, you need to change it to ENGINE.

[mutu26]

For working out current condition you can try sql mdf recovery (http://www.sqlmdfrecovery.net). It owns some effective capabilities such as working under any system requirements. Using modern methods of restoring and clear interface for any experienced users...