Keep getting SQL error, quoted below, that halts upgrade from 4.2.2 to 4.2.5 about halfway through.
Following others with similar errors posted at support forums:
-- Blogs are turned on,
-- PHP is at 5.6.32, but has was also tried at 7.0, and 7.1
-- MySQL is at 5.5.58-cll
All help appreciated. Forums are down until we get past this.
Following others with similar errors posted at support forums:
-- Blogs are turned on,
-- PHP is at 5.6.32, but has was also tried at 7.0, and 7.1
-- MySQL is at 5.5.58-cll
All help appreciated. Forums are down until we get past this.
Database error in vBulletin 4.2.5:
Invalid SQL:
SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid
FROM cr_blog_text bt
JOIN cr_blog bl USING (blogid)
LEFT JOIN cr_ipdata ip ON (
bt.ipaddress = ip.ipid AND bt.blogtextid = ip.contentid
AND bt.userid = ip.userid AND ip.contenttypeid IN (, )
)
WHERE ipid IS NULL;
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 ' )
)
WHERE ipid IS NULL' at line 6
Error Number : 1064
Request Date : Tuesday, December 19th 2017 @ 01:44:43 PM
Error Date : Tuesday, December 19th 2017 @ 01:44:44 PM
Script : http://www.xxxxms.com/bb/install/upgrade.php
Referrer : http://www.xxxxms.com/bb/install/upgrade.php
IP Address : IPADDRESS
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.5.58-cll
Server : 192.31.129.194
User Agent :
Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 475
#2 vB_Database->query_read_slave() called in [path]/install/includes/class_upgrade_vbblog.php on line 1969
#3 vB_Upgrade_vbblog->step_18() called in [path]/install/includes/class_upgrade.php on line 1762
#4 vB_Upgrade_Version->execute_step() called in [path]/install/includes/class_upgrade_ajax.php on line 616
#5 vB_Upgrade_Ajax->execute_step() called in [path]/install/includes/class_upgrade_ajax.php on line 405
#6 vB_Upgrade_Ajax->process_step() called in [path]/install/includes/class_upgrade_ajax.php on line 151
#7 vB_Upgrade_Ajax->init() called in [path]/install/includes/class_upgrade.php on line 385
#8 vB_Upgrade_Abstract->__construct() called in [path]/install/includes/class_upgrade_ajax.php on line 80
#9 vB_Upgrade_Ajax->__construct() called in [path]/install/includes/class_upgrade.php on line 49
#10 vB_Upgrade::fetch_library() called in [path]/install/upgrade.php on line 53
Invalid SQL:
SELECT bt.userid, bt.dateline, blogtextid, ipaddress, firstblogtextid
FROM cr_blog_text bt
JOIN cr_blog bl USING (blogid)
LEFT JOIN cr_ipdata ip ON (
bt.ipaddress = ip.ipid AND bt.blogtextid = ip.contentid
AND bt.userid = ip.userid AND ip.contenttypeid IN (, )
)
WHERE ipid IS NULL;
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 ' )
)
WHERE ipid IS NULL' at line 6
Error Number : 1064
Request Date : Tuesday, December 19th 2017 @ 01:44:43 PM
Error Date : Tuesday, December 19th 2017 @ 01:44:44 PM
Script : http://www.xxxxms.com/bb/install/upgrade.php
Referrer : http://www.xxxxms.com/bb/install/upgrade.php
IP Address : IPADDRESS
Username :
Classname : vB_Database_MySQLi
MySQL Version : 5.5.58-cll
Server : 192.31.129.194
User Agent :
Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 1395
#1 vB_Database_MySQLi->execute_query() called in [path]/includes/class_core.php on line 475
#2 vB_Database->query_read_slave() called in [path]/install/includes/class_upgrade_vbblog.php on line 1969
#3 vB_Upgrade_vbblog->step_18() called in [path]/install/includes/class_upgrade.php on line 1762
#4 vB_Upgrade_Version->execute_step() called in [path]/install/includes/class_upgrade_ajax.php on line 616
#5 vB_Upgrade_Ajax->execute_step() called in [path]/install/includes/class_upgrade_ajax.php on line 405
#6 vB_Upgrade_Ajax->process_step() called in [path]/install/includes/class_upgrade_ajax.php on line 151
#7 vB_Upgrade_Ajax->init() called in [path]/install/includes/class_upgrade.php on line 385
#8 vB_Upgrade_Abstract->__construct() called in [path]/install/includes/class_upgrade_ajax.php on line 80
#9 vB_Upgrade_Ajax->__construct() called in [path]/install/includes/class_upgrade.php on line 49
#10 vB_Upgrade::fetch_library() called in [path]/install/upgrade.php on line 53
Comment