Bug Database error in vBulletin 3.8.7

[motd2]

Install 6.0.8 - ok
upgrade 6.1.1 - ok
upgrade 6.2.1 - Database error in vBulletin 3.8.7


***
Updating Version Number To: 6.2.0

Invalid SQL:

CREATE TABLE IF NOT EXISTS `test_dbtech_vbshout_session`
(
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`instanceid` int(10) unsigned NOT NULL DEFAULT '0',
`chatroomid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`, `instanceid`, `chatroomid`),
KEY `last_activity` (`lastactivity`) USING BTREE,
KEY `instance_activity` (`lastactivity`, `instanceid`) USING BTREE,
KEY `chatroom_activity` (`lastactivity`, `chatroomid`) USING BTREE
) ENGINE=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 'USING BTREE,
KEY `instance_activity` (`lastactivity`, `instanceid`) USING BTRE' at line 8
Error Number : 1064
Request Date : Wednesday, September 18th 2013 @ 02:39:57 AM
Error Date : Wednesday, September 18th 2013 @ 02:39:59 AM
Script : http://localhost/forum/admincp/plugin.php?do=productimport

 

[Fillip H.]

What version is your MySQL server?

 

[motd2]

localhost old MySQL 5.0.51

 

[Fillip H.]

I've made a change that may work for you. You can re-download the mod and try again, let me know if it works

 

[motd2]

Fillip H., yes it works :RpS_smile: