Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Sign In
Not a member yet? Click here to register.

Error updating database

Good day! An error occurred while updating from 8.00.21 to 8.00.22

Query Error: INSERT INTO fusionda132_settingssettings (settings_name, settings_value) VALUES ('number_delimiter', '.')<br/>Stack Trace: #0 /public_html/includes/db_handlers/pdo_functions_include.php(42): PDO->prepare('INSERT INTO fus...') #1 /public_html/administration/upgrade.php(50): dbquery('INSERT INTO fus...') #2 {main}<br/>Error Nature: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'gallants_fusion.fusionda132_settingssettings' doesn't exist
Fixed https://github.com/php-fusion/PHP-Fusion/commit/55c822feabfed685e6efe30b4fbb1174c660346f
Now it adds parameters to the database, but displays another error:

Query Error: ALTER DATABASE gallants_fusion CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;<br/>Stack Trace: #0 /public_html/includes/db_handlers/pdo_functions_include.php(43): PDOStatement->execute() #1 /public_html/administration/upgrade.php(62): dbquery('ALTER DATABASE ...') #2 {main}<br/>Error Nature: SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active. Consider using PDOStatement::fetchAll(). Alternatively, if your code is only ever going to run against mysql, you may enable query buffering by setting the PDO::MYSQL_ATTR_USE_BUFFERED_QUERY attribute.
Thread Information
3 posts
254 times
Last Post
Last updated on 6 months ago
You can view all discussion threads in this forum.
You cannot set up a bounty in this discussion thread.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.
You cannot up or down-vote on the post in this discussion thread.
Users who participated in discussion: Oleg, RobiNN