3.2.2 database issue after upgrading from 3.2.1

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Kar2k
Registered User
Posts: 7
Joined: Tue May 03, 2016 4:55 am

3.2.2 database issue after upgrading from 3.2.1

Post by Kar2k »

SQL ERROR [ mysqli ]

Table 'forums.SESSIONS_TABLE' doesn't exist [1146]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.


https://forums.lvcnr.net/


Any ideas? The database is fine. All the tables are populated as they should.

My database kept timing out during the upgrade. I updated by automatic file direct. I changed config from 'mysql' to 'mysqli' and the database upgrade ran successfully.

Code: Select all

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
// $dbms = 'mysqli';
$dbms = 'mysqli';
$dbhost = 'localhost';
$dbport = 3306;
$dbname = 'forums';
$dbuser = 'forum';
$dbpasswd = 'xxx';
$table_prefix = 'phpbb_';
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'file';
$load_extensions = '';

@define('PHPBB_INSTALLED', true);
// @define('PHPBB_ENVIRONMENT', 'production');
// @define('PHPBB_DISPLAY_LOAD_TIME', true);
// @define('DEBUG', true);
// @define('DEBUG_CONTAINER', true);
?>
nginx 1.12.1
PHP 5.6.30-0+deb8u1
mysql 5.7
Last edited by Kar2k on Mon Feb 19, 2018 11:23 am, edited 2 times in total.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26508
Joined: Fri Aug 29, 2008 9:49 am

Re: 3.2.2 database issue after upgrading from 3.2.1

Post by Mick »

Kar2k wrote: Mon Feb 19, 2018 11:06 amI updated by file direct
Do you mean the file replacement method!

There’s more than just the sessions table causing an error, the bots table is the same. Try disabling cloudflare and see what happens.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
Kar2k
Registered User
Posts: 7
Joined: Tue May 03, 2016 4:55 am

Re: 3.2.2 database issue after upgrading from 3.2.1

Post by Kar2k »

Disabled.

Don't see any differences ;\

If it's worth anything to mention that when I had trouble updating, it was stopping on the download_updated_files task.
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26508
Joined: Fri Aug 29, 2008 9:49 am

Re: 3.2.2 database issue after upgrading from 3.2.1

Post by Mick »

  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
Kar2k
Registered User
Posts: 7
Joined: Tue May 03, 2016 4:55 am

Re: 3.2.2 database issue after upgrading from 3.2.1

Post by Kar2k »

I tried that.

When I do that I get a HTTP 500 error when trying to visit the forum.
Kar2k
Registered User
Posts: 7
Joined: Tue May 03, 2016 4:55 am

Re: 3.2.2 database issue after upgrading from 3.2.1

Post by Kar2k »

Apparently ./includes/constants.php was empty

Now it's refusing to connect
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26508
Joined: Fri Aug 29, 2008 9:49 am

Re: 3.2.2 database issue after upgrading from 3.2.1

Post by Mick »

Obviously you have a file transfer problem. Try uploading all the files again.
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
Kar2k
Registered User
Posts: 7
Joined: Tue May 03, 2016 4:55 am

Re: 3.2.2 database issue after upgrading from 3.2.1

Post by Kar2k »

The file we're replaced automatically by the phpBB3 update, I'm looking more into it.

We've fixed it. Apparently that was the issue and the cache folder was set to root.

Idk I never had issues updating before.. but thanks.

It was JUST constants.php tho.
Post Reply

Return to “[3.2.x] Support Forum”