PhotoPost Community - View Single Post - Fresh install crashes if using Mysql v.5.1 and forum integration

Mikan · March 29th, 2011, 05:56 AM

There is an incorrect setting in every forum integration script if you are using Mysql v.5.1 or later.

TYPE=... table option is deprecated and the correct setting is ENGINE=

So if you are trying to do a fresh install, you are using MySQL v.5.1 or later and you are trying to using a forum integration scripts like VB etc.

Installer crashes on step 4 and produces error "We're sorry, but the system experienced an unrecoverable error. Please try again later."

You can fix that by editing the correct forum integration script (eg. vb3.php) and replace
PRIMARY KEY (groupid)) TYPE=MyISAM
with
PRIMARY KEY (groupid)) ENGINE=MyISAM

March 29th, 2011, 05:56 AM	#1 (permalink)
Mikan Member Verified Customer Join Date: Apr 2004 Location: Finland Posts: 94	Fresh install crashes if using Mysql v.5.1 and forum integration There is an incorrect setting in every forum integration script if you are using Mysql v.5.1 or later. TYPE=... table option is deprecated and the correct setting is ENGINE= So if you are trying to do a fresh install, you are using MySQL v.5.1 or later and you are trying to using a forum integration scripts like VB etc. Installer crashes on step 4 and produces error "We're sorry, but the system experienced an unrecoverable error. Please try again later." You can fix that by editing the correct forum integration script (eg. vb3.php) and replace PRIMARY KEY (groupid)) TYPE=MyISAM with PRIMARY KEY (groupid)) ENGINE=MyISAM