Bug database error upgrading to 2.0.6 from 2.0.5

[joshcurrier]

The site still functions after the new files were uploaded, but I'm not able to complete the product upgrade.

Database error in vBulletin 4.2.2:

Invalid SQL:

REPLACE INTO `dbtech_dbseo_adminmessage`
(`adminmessageid`, `varname`, `dismissable`, `script`, `action`, `execurl`, `method`, `dateline`)
VALUES
(4, 'dbtech_dbseo_analytics_disabled', 1, 'validate', 'gaenabled', 'index.php?do=save&filedo=home&dogroup=analytics&setting[dbtech_dbseo_analytics_active]=1', 'post', UNIX_TIMESTAMP())
(5, 'dbtech_dbseo_analytics_account_missing', 1, 'validate', 'gaaccount', 'index.php?do=analytics', 'get', UNIX_TIMESTAMP()),
(6, 'dbtech_dbseo_analytics_profile_missing', 1, 'validate', 'gaprofile', 'index.php?do=analytics', 'get', UNIX_TIMESTAMP());

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 '(5, 'dbtech_dbseo_analytics_account_missing', 1, 'validate', 'gaaccount', 'index' at line 5
Error Number : 1064
Request Date : Tuesday, June 9th 2015 @ 12:53:13 PM
Error Date : Tuesday, June 9th 2015 @ 12:53:14 PM
Script : Log in - NESR Forums - vBulletin Admin Control Panel
Referrer : Log in - NESR Forums - vBulletin Admin Control Panel
IP Address : 208.87.234.201
Username : Frankenstein
Classname : vB_Database_MySQLi
MySQL Version : 5.6.23

 

[janslu]

You need to add a comma in the end of line #6 in a file /dbtech/dbseo/install/206.php:

Currently it is:

(4, 'dbtech_dbseo_analytics_disabled', 1, 'validate', 'gaenabled', 'index.php?do=save&filedo=home&dogroup=analytics&setting[dbtech_dbseo_analytics_active]=1', 'post', UNIX_TIMESTAMP())

And it should be:

(4, 'dbtech_dbseo_analytics_disabled', 1, 'validate', 'gaenabled', 'index.php?do=save&filedo=home&dogroup=analytics&setting[dbtech_dbseo_analytics_active]=1', 'post', UNIX_TIMESTAMP()),

 

[Fillip H.]

Fixed, sorry about that

 

[joshcurrier]

Thanks for the quick fix!