Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Rubiyooo
Registered User
Posts: 5
Joined: Sun Apr 18, 2021 6:09 am

Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by Rubiyooo »

Support Request Template
What version of phpBB are you using? phpBB 3.2.0
What version of PHP are you using? PHP 7.3.27
What is your board's URL? http://rubnv14.sg-host.com/
Who do you host your board with? siteground.es
How did you install your board? This is an old install. I'm webmaster trying to update with 3.3.3 full package from phpBB.com
What is the most recent action performed on your board? Nothing
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? No
What styles do you currently have installed? prosilver 3.2.0
What language(s) is your board currently using? English
Which database type/version are you using? MySQL(i) 5.7.32-35-log
What is your level of experience? Uncomfortable with PHP and phpBB
What username can be used to view this issue? No
What password can be used to view this issue? No
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? No
Please describe your problem:

Hi everybody I'm here for first time so I hope to resolve this problem. Thanks in advance

First of all this is an old forum that I get the responsability to migrate and update in the last version. The problem is that I did all this steps and I have this problem:

Fatal error: SQL ERROR [ mysqli ]<br /><br />Unknown column 'user_msnm' in 'field list' [1054]


Steps that I did even using SSH to use the command php ./bin/phpbbcli.php db:migrate --safe-mode
This update method will remove most existing files and then put the new ones in place.

Make a backup of the original files

Make a backup of the database

Download the phpBB 3.3 Full Package archive

Extract the contents of the archive to your computer and open the phpBB3 directory

Delete the following files from the package:

The config.php file

The images/ directory

The files/ directory

The store/ directory

On your website, delete all files from your board EXCEPT for:

The config.php file

The ext/ directory

The images/ directory

The files/ directory

The store/ directory

The styles/ directory

Upload the contents of the phpBB3 directory from your computer to your forum's directory. You may be prompted to overwrite the remaining files. If prompted to merge or overwrite directories, choose to merge them.

The docs/ folder is for your personal use and it is not necessary to upload it to your forum.

Update the database:

Tip
For large boards, you may wish to update via the command line instead of using a web browser. From your board's root, execute the following command: php ./bin/phpbbcli.php db:migrate --safe-mode
Can you help me? ;)
Last edited by Rubiyooo on Fri Apr 23, 2021 6:23 pm, edited 1 time in total.
User avatar
janus_zonstraal
Registered User
Posts: 6475
Joined: Sat Aug 30, 2014 1:30 pm

Re: Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by janus_zonstraal »

What version of PHP are you using? PHP Version 5.6.40
You need 7.1 or better a higher version for phpbb3.3.3
Sorry! My English is bat ;) !!!
Rubiyooo
Registered User
Posts: 5
Joined: Sun Apr 18, 2021 6:09 am

Re: Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by Rubiyooo »

Thank you by help me Janus. My mistake with php version. I have PHP 7.3.27 (I updated in the first post)

Even with a correct PHP version (I try with PHP 7.1 too to update the database).

The problem is another I think it. Because all time It say me, It is not avaible to find a field in my bbd "Unknown column 'user_msnm' in 'field list' [1054]" I finding in Google and is a field about "Messenger info account" for user profile maybe?


Thanks in advance for your interest.
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10568
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster

Re: Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by Noxwizard »

Run this query:

Code: Select all

DELETE FROM phpbb_migrations WHERE migration_name = "\\phpbb\\db\\migration\\data\\v310\\profilefield_wlm";
It should then re-check to see if it really needs to apply that migration.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Rubiyooo
Registered User
Posts: 5
Joined: Sun Apr 18, 2021 6:09 am

Re: Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by Rubiyooo »

Thank you. I progress a little. Now appears another error U_u

[ERROR] A module already exists: ACP_CONTACT_SETTINGS


Image

Unfortunable I see maybe this forum have several MODs (I'm a new webmaster this forum have maybe 15 years old and I don't know what they maybe installed here. In extensions section only appears one and It is not activate.


I was looking in this forum the same error and maybe this screenshot of my FTP It can help you.

Image
Thanks in advance and thank you for your patient. I appreciate all your wonderful support for this noob ^_^U
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10568
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster

Re: Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by Noxwizard »

I can give a fix for that, but first, do you have any history on this database? It looks like these database migrations were run in the past, but the migration table isn't reflecting that. Were there partial restores done in the past or anything else odd done to it?

Also, what is the result of this query:

Code: Select all

SELECT * FROM phpbb_migrations WHERE migration_name = "\\phpbb\\db\\migration\\data\\v310\\contact_admin_acp_module";
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Rubiyooo
Registered User
Posts: 5
Joined: Sun Apr 18, 2021 6:09 am

Re: Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by Rubiyooo »

Unfortunable not. We only have backups since 1 month ago in the server and I never did an update. I ask the owner but she does not know so much about it.

This is the result of your query:

Image

In English zero results about tables.

Any idea?

Thanks by your replys and your support.
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10568
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster

Re: Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by Noxwizard »

It appears that perhaps a partial backup was restored at some point, but without the migrations table. The updater is attempting to apply a migration that has already been completed, but the migration table which tracks all that shows no record of it.

Open: phpbb/db/migration/data/v310/contact_admin_acp_module.php
Find:

Code: Select all

class contact_admin_acp_module extends \phpbb\db\migration\migration
{
After, add:

Code: Select all

	public function effectively_installed()
	{
		$sql = 'SELECT module_id
			FROM ' . MODULES_TABLE . "
			WHERE module_class = 'acp'
				AND module_basename = 'acp_contact'
				AND module_langname = 'ACP_CONTACT_SETTINGS'";
		$result = $this->db->sql_query($sql);
		$module_id = $this->db->sql_fetchfield('module_id');
		$this->db->sql_freeresult($result);
		

		return $module_id != false;
	}
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Rubiyooo
Registered User
Posts: 5
Joined: Sun Apr 18, 2021 6:09 am

Re: Problem Updating 3.2.0 to 3.3.3 - Fatal error: SQL ERROR [ mysqli ]Unknown column 'user_msnm'

Post by Rubiyooo »

Ariariariariariariariariariarigagagagagatooooooooooooooooooooooooooooooooooo!!

Gozaimasuuuu!!!

Finally 1 week later thank by your help I upgrade this forum and I can post without errors!!

Image

Thanks in advance in my name and my owner!! Dear Noxwizard!! ^^

Image

Return to “[3.2.x] Support Forum”