Error on upgrade

rinkrat · August 4th, 2011, 02:03 PM

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;

Chuck S · August 4th, 2011, 02:06 PM

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

what mysql version are you running?

rinkrat · August 4th, 2011, 02:24 PM

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

Chuck S · August 4th, 2011, 02:58 PM

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

Code:

Content visible to verified customers only.

replace with

Code:

Content visible to verified customers only.