[nambisolo]

Hello

I have logged this with vBulletin support but they have not replied in over a week. I'm hoping the forum may be able to advise.

Whilst attempting to upgrade from 4.1.12 to 4.2.3 I encounter the following error:

An error has occurred with your database. Please contact vBulletin Support for assistance.

Module: 420a1, Step 14 Database Error:1064

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 ' 'album', 'album', 1), (, 'album', 'comment', 1), (, 'album', 'photo',' at line 5

Query:

INSERT IGNORE INTO elam_vb_activitystreamtype
(packageid, section, type, enabled)
VALUES
(, 'album', 'album', 1),
(, 'album', 'comment', 1),
(, 'album', 'photo', 1),
(, 'calendar', 'event', 1),
(, 'forum', 'post', 1),
(, 'forum', 'thread', 1),
(, 'forum', 'visitormessage', 1),
(, 'socialgroup', 'discussion', 1),
(, 'socialgroup', 'group', 1),
(, 'socialgroup', 'groupmessage', 1),
(, 'socialgroup', 'photo', 1),
(, 'socialgroup', 'photocomment', 1)

I have exported and imported my database using SSH as advised in the manual.

I'm running the following versions of software:

MySQL version: 5.6.28-76.1-log - Percona Server (GPL), Release 76.1, Revision 5759e76

PHP Version 5.6.18

The response was as follows:

"Thank you for contacting vBulletin Support. You will need to open the /install/includes/class_upgrade_420a1.php file and remove the IGNORE keyword from that file."

I advised support this did not resolve the issue but I've had no reply.

Any ideas?

Cheers.

Mike