SQL Error after updating phpBB from 3.3.11 to 3.3.12

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
doomyboy
Registered User
Posts: 8
Joined: Sun Feb 12, 2017 12:22 pm

SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by doomyboy »

Support Request Template
What version of phpBB are you using? phpBB 3.3.12
What is your board's URL? https://showtimehockey.ca/forum/
Who do you host your board with? CrocWeb
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? No
What version of phpBB3 did you update from? phpBB 3.3.11
What styles do you currently have installed? prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MariaDB
What is your level of experience? +8yrs with PHP and phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Following the instruction of updating the phpbb 3.3.11 to the new version 3.3.12
Please describe your problem. While performing the update procedure from phpBB 3.3.11 to 3.3.12 using the Full Package, I encountered this error:

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 444: Undefined array key "user_last_active"

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'user_last_active' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Obviously, I made a backup before performing the update. I am unable to upgrade to version 3.3.12. Therefore, I have reverted to version 3.3.11 while waiting for your response.

Thank you.
User avatar
ssl
Registered User
Posts: 1869
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by ssl »

I encountered this issue with a 3.3.11 to 3.3.12 update using the Changed Files method.
Do this and start the update procedure again: viewtopic.php?p=16014946#p16014946
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"
doomyboy
Registered User
Posts: 8
Joined: Sun Feb 12, 2017 12:22 pm

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by doomyboy »

ssl wrote: Sun Jun 02, 2024 11:06 am In /cache folder delete:
  • install folder
  • production folder
In /store folder delete:
  • install_config.php file
  • .lock and migration file
and start the update procedure again

Done, but same SQL Error appeared as before
User avatar
ssl
Registered User
Posts: 1869
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by ssl »

This was the solution that worked for me.
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"
Silhouette
Registered User
Posts: 1
Joined: Fri Jun 07, 2024 1:59 pm

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by Silhouette »

The exact error happened with my 3.3.11 upgrade to 3.3.12 after using the Bluehost Softaculous script to do the upgrade. The 3.3.11 folders and files along with the database were restored to get the board back up and running. I will not attempt another 3.3.12 upgrade until this issue is resolved definitively.
User avatar
janus_zonstraal
Registered User
Posts: 6493
Joined: Sat Aug 30, 2014 1:30 pm

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by janus_zonstraal »

The exact error happened with my 3.3.11 upgrade to 3.3.12 after using the Bluehost Softaculous script to do the upgrade.
Please never use Softaculous to update your board.
Sorry! My English is bat ;) !!!
User avatar
ssl
Registered User
Posts: 1869
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by ssl »

I got this same error using the Changed Files method
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"
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10569
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by Noxwizard »

doomyboy wrote: Fri Jun 07, 2024 5:37 am While performing the update procedure from phpBB 3.3.11 to 3.3.12 using the Full Package, I encountered this error:

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/session.php on line 444: Undefined array key "user_last_active"

Code: Select all

General Error
SQL ERROR [ mysqli ]

Unknown column 'user_last_active' in 'field list' [1054]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Obviously, I made a backup before performing the update. I am unable to upgrade to version 3.3.12. Therefore, I have reverted to version 3.3.11 while waiting for your response.

Thank you.
You're getting this after running the database update? It sounds like the files were updated, but not the database.

You can run this query to check if the migration was run:

Code: Select all

SELECT migration_schema_done, migration_data_done FROM phpbb_migrations WHERE migration_name = '\\phpbb\\db\\migration\\data\\v33x\\add_user_last_active';
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
doomyboy
Registered User
Posts: 8
Joined: Sun Feb 12, 2017 12:22 pm

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by doomyboy »

Noxwizard wrote: Sat Jun 08, 2024 2:34 am You're getting this after running the database update? It sounds like the files were updated, but not the database.

You can run this query to check if the migration was run:

Code: Select all

SELECT migration_schema_done, migration_data_done FROM phpbb_migrations WHERE migration_name = '\\phpbb\\db\\migration\\data\\v33x\\add_user_last_active';
Exactly, the database wasn't updated. I'm unable to go to install/, I get this error right after as the files are updated. I followed the steps as usual.
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10569
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by Noxwizard »

I only get that when visiting the forum. Visiting the installer page doesn't give me that error. Try going to the updater directly: <yoursite>/install/app.php/update
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
User avatar
ssl
Registered User
Posts: 1869
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by ssl »

doomyboy wrote: Fri Jun 07, 2024 5:37 am What version of phpBB are you using? phpBB 3.3.12
What version of phpBB3 did you update from? phpBB 3.3.11
Why does prosilver's style.cfg file say 3.3.8?

Code: Select all

# General Information about this style
name = prosilver
copyright = © phpBB Limited, 2007
style_version = 3.3.8
phpbb_version = 3.3.8
Last edited by ssl on Sun Jun 16, 2024 7:29 am, edited 2 times in total.
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"
hrx
Registered User
Posts: 230
Joined: Wed Nov 18, 2015 11:21 am
Location: PL

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by hrx »

I just had the same error, but in the address bar I entered: mysite.pl/forum/install and the updater appeared and I managed to update the database. I also used this guide earlier:

viewtopic.php?p=16016056#p16016056
gpinpin
Registered User
Posts: 22
Joined: Fri May 29, 2015 9:16 am

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by gpinpin »

Bonjour
Meme problème ici cette colonne n'existe pas et bloque l'installation.
J'ai ouvert un post dans https://forums.phpbb-fr.com

Same problem here, this column does not exist and blocks the installation.
I opened a post in https://forums.phpbb-fr.com
forum en phpbb 3.3.10 et php 8.2.14
rxu
Extensions Development Team
Posts: 3804
Joined: Wed Oct 25, 2006 12:46 pm
Location: Siberia, Russian Federation

Re: SQL Error after updating phpBB from 3.3.11 to 3.3.12

Post by rxu »

If you log out the board first and then try updating again, will the error persist?

Return to “[3.3.x] Support Forum”