Updating 3.2.0 to 3.3.11, database not updating

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
castewar
Registered User
Posts: 19
Joined: Wed May 07, 2008 7:35 pm

Updating 3.2.0 to 3.3.11, database not updating

Post by castewar »

First off, apologies and thanks to anybody readying this - I did my knuckleheaded best to avoid posting here, as I know I'm now one of so many similar posts (this is because I've read a lot of them in the hopes of finding the solutions I seek).
:P <-- me, knucklehead

Support Request Template
What version of phpBB are you using? phpBB 3.3.11
What is your board's URL? http://forums.kerberos-productions.com/phpBB3
Who do you host your board with? A2hosting
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? Mmmmaaaaaybe? (a few anti-spam attempts were made way back when)
What version of phpBB3 did you update from? phpBB 3.2.0
What styles do you currently have installed? prosilver (default)
What language(s) is your board currently using? British English
Which database type/version are you using? MySQL(i) 8.0.32 (as per phpbb General / Statistic)
What is your level of experience? New to PHP longtime use phpBB, but Grog still caveman, no understand magic box of light.
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Fresh install of 3.2.0 to match database version. Followed phpbb instructions for dropping in updated files;
https://www.phpbb.com/support/docs/en/3 ... upgrade32/
Please describe your problem. The fresh install seemed to work OK, so I moved on to updating to 3.3.11. Following the instructions, all went well, except when I tried to use the browser installer to update the database, I get to Set Installation Data, I set it to update database only, and when I Submit, it briefly lists;
Skip “installer.update_filesystem.download_updated_files” task
Skip “installer.update_filesystem.update_files” task
Skip “installer.update_filesystem.show_file_status” task
Skip “installer.update_filesystem.diff_files” task
Skip “installer.update_filesystem.check_task” task
Skip “installer.obtain_data.update_ftp_settings” task
Skip “installer.obtain_data.update_files” task
Skip “installer.obtain_data.file_updater_method” task
Then adds;
The installer detected a timeout
The installer has detected a timeout, you may try to refresh the page, which may lead to data corruption. We suggest that you either increase your timeout settings or try to use the CLI.
This was anticipated, as my database is around 1.4G, but I gave it a try anyhow.

So I head to the terminal on my host cpanel and follow the CLI instructions. Hit enter, instant new prompt, zero feedback if anything has happened. Check board, ACP says;
Files Version
3.3.11
Database version
3.2.0
Bah. So that's when I took to the support forms. I checked the config file to read;
$dbms = 'phpbb\\db\\driver\\mysqli';
Then I tried it as
$dbms = 'phpbb\db\driver\mysqli';
because that's how people were writing it here.

I checked the permissions on the CLI file bin/phpbbcli.php. Checked the one in the installer, because now I'm getting way outside my ability comfort zone and I'll jiggle any wire I think I can jiggle without breaking something.

I check the logs, and the log files for both the browser attempt and the CLI attempt contain;
[DEBUG] Migration already effectively installed (skipped): \phpbb\db\migration\data\v310\reset_missing_captcha_plugin
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\captcha_plugins.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\rc2.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\rc1.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\beta4.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\beta3.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\beta2.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\beta1.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\alpha3.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\alpha2.
[DEBUG] Apply dependencies of \phpbb\db\migration\data\v310\alpha1.
[DEBUG] Installing Data: \phpbb\db\migration\data\v310\auth_provider_oauth.
Screeeee! I have no idea what any of this means (I understand "apply" and versions, and something about a captcha plugin (see above template where I go maaaaaay we had some anti-spam things jammed in way back when). But also it says it's skipping it, not choking on it.

At which point, I'm now not sure how to proceed.

The only additional info I can think to look for are any errors on the boards themselves, and there are a few - mostly it runs fine, but also if I try a new post, I get;
General Error
SQL ERROR [ mysqli ]

User 'castewarkp_boards' has exceeded the 'max_user_connections' resource (current value: 30) [1226]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Wha?

And clicking on some sub-forums gets;
General Error
SQL ERROR [ mysqli ]

Table 'castewarkp_boards.phpbb2_notification_emails' doesn't exist [1146]

SQL

DELETE FROM phpbb2_notification_emails WHERE notification_type_id IN (1, 2) AND user_id = '2' AND item_id = 58023

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 202
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/notification/method/email.php
LINE: 132
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/phpbb/notification/manager.php
LINE: 177
CALL: phpbb\notification\method\email->mark_notifications()

FILE: [ROOT]/includes/functions.php
LINE: 788
CALL: phpbb\notification\manager->mark_notifications()

FILE: [ROOT]/viewtopic.php
LINE: 2284
CALL: markread()

Generated by SRT Generator

The problem is I don't know if these are from 3.3.11 files running with 3.2.0 database that would be fixed if the database can be updated, or if they are an indication of something hanging loose in the database.

I've poked around myphpadmin, did an optimization here, found a password there, pat myself on the back, but that is sharks and nightmares all the way down to me, if I'm honest. But, if I can just find out why the car won't start, well, I can try a little reading or find a little help.

As at the start, thanks and apologies for being MY BOARD WON'T UPDATE #239848230985. You're all awesome.
User avatar
ssl
Registered User
Posts: 1833
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: Updating 3.2.0 to 3.3.11, database not updating

Post by ssl »

castewar wrote: Mon Feb 19, 2024 5:53 am Then adds;
The installer detected a timeout
The installer has detected a timeout, you may try to refresh the page, which may lead to data corruption. We suggest that you either increase your timeout settings or try to use the CLI.
Please read this: https://www.phpbb.com/support/docs/en/3 ... meoutquot/
Sorry for my English ... I do my best!

phpBB: 3.3.12 | PHP: 8.3.7
[Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"

Return to “[3.3.x] Support Forum”