+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: Installation and Upgrades Support (https://community.mybb.com/forum-182.html)
+--- Thread: MyBB has experienced an internal SQL error and cannot continue. (/thread-218614.html)
MyBB has experienced an internal SQL error and cannot continue. - mobo12 - 2018-07-12
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2
http://prntscr.com/k5hj7c
Someone Please Help
RE: MyBB has experienced an internal SQL error and cannot continue. - Serpius - 2018-07-12
(2018-07-12, 07:18 AM)mobo12 Wrote: MyBB has experienced an internal SQL error and cannot continue.
SQL Error:1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 2
http://prntscr.com/k5hj7c
Someone Please Help
Screenshot does not work. It's missing.
RE: MyBB has experienced an internal SQL error and cannot continue. - effone - 2018-07-12
There is a missing parenthesis issue. Please fix the upgrade43.php file manually following this PR and then run upgrade.
https://github.com/mybb/mybb/pull/3298/files
Replace line 34 of upgrade43.php with the following:
$db->update_query('settings', array('value' => ''), 'name IN (\'captchapublickey\', \'captchaprivatekey\')'); // Clean out stored credential keys
Also I'd like to advise please wait for a day. 1.8.17 gonna be available with like 10 major fixes, apart from this.