Error on upgrade
 

I just upgraded VB to 4.1.5 from 3.8.7. and want to update the vbgallery.

I get this error during the upgrade.

I tried an uninstall and then fresh install and it gets the same error.



Invalid SQL:

CREATE TABLE IF NOT EXISTS ppgal_setting (
varname varchar(100) NOT NULL default '',
grouptitle varchar(50) NOT NULL default '',
value mediumtext NOT NULL default '',
defaultvalue varchar(250) NOT NULL default '',
optioncode mediumtext NOT NULL,
displayorder smallint(3) unsigned NOT NULL default '0',
PRIMARY KEY (varname)
) TYPE=MyISAM;

is there anything else in that error message? I do not get any errors installing.

what mysql version are you running?

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
Username : rinkrat
Classname : vB_Database
MySQL Version : 5.5.12-log

Edit the install script and go a global search and replace for

replace with