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.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Suspected Bugs and Errors - 8
  5. Error updating database

Error updating database

Asked Modified Viewed 1,007 times
Back to Forum Index Previous Topic Next Topic
Print
O
Oleg
O
Oleg 10
  • Junior Member, joined since
  • Contributed 46 posts on the community forums.
  • Started 10 threads in the forums
  • Started this discussions
asked
Junior Member

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
Edited by Oleg on 01-01-2020 13:29,
0 replies

2 posts

R
Anonymous User
R
Anonymous User 367
  • Veteran Member, joined since
  • Contributed 939 posts on the community forums.
  • Started 2 threads in the forums
  • Answered 20 questions
answered
Veteran Member

Fixed https://github.com/PHPFusion/PHPFusion/commit/55c822feabfed685e6efe30b4fbb1174c660346f
0 replies
O
Oleg
O
Oleg 10
  • Junior Member, joined since
  • Contributed 46 posts on the community forums.
  • Started 10 threads in the forums
  • Started this discussions
answered
Junior Member

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.
0 replies

Category Forum

Suspected Bugs and Errors - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 2 posts
  • Votes 0 votes
  • Topic users 2 members

2 participants

O
O
Oleg 10
  • Junior Member, joined since
  • Contributed 46 posts on the community forums.
  • Started 10 threads in the forums
  • Started this discussions
R
R
Anonymous User 367
  • Veteran Member, joined since
  • Contributed 939 posts on the community forums.
  • Started 2 threads in the forums
  • Answered 20 questions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet