3.2.2 Update Problem updating database (& 3.2.3) SOLVED

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
kholman
Registered User
Posts: 73
Joined: Sun Jan 16, 2005 12:35 am
Location: Maryland USA
Contact:

3.2.2 Update Problem updating database (& 3.2.3) SOLVED

Post by kholman »

I think I've searched all the topics that might be related.
I have a phpbb install at www.ussjamesmadison627.com
It has been functioning well at 3.2.1
I attempted to do the auto update and ran into the noted timeout problem with mysql vs mysqli in the config.php file. I corrected that and tried again.
Then I got the following error when we reached the database update:

Code: Select all

General Error:
SQL ERROR [ mysqli ] [0]
SQL
No values specified for SQL IN comparison in file /home/rkholman/domains/ussjamesmadison627.com/public_html/install/update/new/phpbb/db/driver/driver.php on line 996
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: installer_msg_handler()

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

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

FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/db/driver/factory.php
LINE: 441
CALL: phpbb\db\driver\driver->sql_in_set()

FILE: [ROOT]/phpbb/db/migration/data/v32x/fix_user_styles.php
LINE: 48
CALL: phpbb\db\driver\factory->sql_in_set()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\db\migration\data\v32x\fix_user_styles->styles_fix()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 714
CALL: call_user_func_array()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 661
CALL: phpbb\db\migrator->run_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 436
CALL: phpbb\db\migrator->process_data_step()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 351
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 288
CALL: phpbb\db\migrator->try_apply()

FILE: [ROOT]/phpbb/db/migrator.php
LINE: 241
CALL: phpbb\db\migrator->update_do()

FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/install/module/update_database/task/update.php
LINE: 160
CALL: phpbb\db\migrator->update()

FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/install/module_base.php
LINE: 149
CALL: phpbb\install\module\update_database\task\update->run()

FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/install/installer.php
LINE: 219
CALL: phpbb\install\module_base->run()

FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/phpbb/install/controller/update.php
LINE: 133
CALL: phpbb\install\installer->run()

FILE: (not given by php)
LINE: (not given by php)
CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()

FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/vendor/symfony/http-foundation/StreamedResponse.php
LINE: 111
CALL: call_user_func()

FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/vendor/symfony/http-foundation/Response.php
LINE: 377
CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()

FILE: /home/rkholman/domains/ussjamesmadison627.com/public_html/install/app.php
LINE: 62
CALL: Symfony\Component\HttpFoundation\Response->send()
This error showed up after this showed up in the progress lines below:

Code: Select all

Installing Data: \phpbb\db\migration\data\v32x\fix_user_styles.
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
I was able to get back into ACP which advised the files had been updated but the update had not fully installed, I still needed to update teh database files.
After trying a couple of times with same results, I went back to the manual update where I u/l the 3.2.2 files (less config.php, /images/, /files/, and /store).
Attempts to run the update database only returns the error at the top of this post.
Any thoughts on just what I'm doing wrong?
(Earlier this week, I installed using the auto update on a different host on 5 different installs with no problem other than the change mysql to mysqli in config.php so I'm reasonably confident that I've been doing something right and am following instructions correctly.)
Thanks in advance.

Edited to change title to show recurrence and solution in 3.2.3 as well as 3.2.2
Last edited by kholman on Thu Nov 08, 2018 3:12 am, edited 1 time in total.
kholman
Registered User
Posts: 73
Joined: Sun Jan 16, 2005 12:35 am
Location: Maryland USA
Contact:

Re: 3.2.2 Update Problem with updating database

Post by kholman »

Tried a complete reinstall vice the auto update.
If I run install/update, I still get the same error noted above. If I go to the ACP, I see the following.

Code: Select all

Your phpBB installation has not been correctly updated. Please read the information below in order to fix this error.

Code: Select all

A new feature release 3.2.2 is available. Please read the release announcement to learn about what it has to offer, and how to upgrade.

Code: Select all

Files Version     3.2.2

Database version     3.2.1

Latest version     3.2.2

Announcement     https://www.phpbb.com/community/viewtopic.php?f=14&t=2453381
While the forum appears at first glance, I'm not going to open it back up as I haven't yet found what the differences in the database are. Perhaps I'll see if I can manually make those changes via phpmyadmin.
On a shared host and don't have CLI access.
User avatar
P_I
Community Team Member
Community Team Member
Posts: 2353
Joined: Tue Mar 01, 2011 8:35 pm
Location: Western Canada 🇨🇦
Contact:

Re: 3.2.2 Update Problem with updating database

Post by P_I »

A bit of a long shot to try, clear the cache via ACP. Some configuration values are cached. I found this out during some offline testing with a database restore on a local testbed that I knew was from a 3.2.2 system. I got the same ACP output as you are seeing, claiming that my database was at 3.2.1. ACP->Purge cache resolved the inconsistency.
Normal people… believe that if it ain’t broke, don’t fix it. Engineers believe that if it ain’t broke, it doesn’t have enough features yet. – Scott Adams
kholman
Registered User
Posts: 73
Joined: Sun Jan 16, 2005 12:35 am
Location: Maryland USA
Contact:

Re: 3.2.2 Update Problem with updating database

Post by kholman »

P_I wrote: Wed Jan 17, 2018 11:25 pm A bit of a long shot to try, clear the cache via ACP. Some configuration values are cached. I found this out during some offline testing with a database restore on a local testbed that I knew was from a 3.2.2 system. I got the same ACP output as you are seeing, claiming that my database was at 3.2.1. ACP->Purge cache resolved the inconsistency.
Willing to try long shots and appreciate the suggestion but it didn't do the trick.
kholman
Registered User
Posts: 73
Joined: Sun Jan 16, 2005 12:35 am
Location: Maryland USA
Contact:

Re: 3.2.2 Update Problem with updating database

Post by kholman »

Thinking there might be some unseen problem with my database, I created a copy of the database with a different name and made the config.php point to the new database. Results were the same as described in the first message in this thread.
kholman
Registered User
Posts: 73
Joined: Sun Jan 16, 2005 12:35 am
Location: Maryland USA
Contact:

Re: 3.2.2 Update Problem with updating database

Post by kholman »

Starting from a clean slate, I have been able to create a new installation complete with an empty database with no problems noted.
So I'm trying now to rebuild based on my backup files. Can someone point me to the information of what exactly is to be accomplished with the "update database" routine?
From what I can suss out, it appears that the repeated attempts to update database files have copied/added duplicate records as the database seems to have doubled in size.
While I can (I think) manually recreate the populated database, I think I will be recreating/populating a 3.2.1 database. So what do I need to add/manipulate to have a 3.2.2 compliant database when I'm done?
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: 3.2.2 Update Problem with updating database

Post by janus_zonstraal »

What you want is "almost" impossible.
So better not touch the database.

Did you do a test to point the new 3.2.2 files to the old database?
Sorry! My English is bat ;) !!!
kholman
Registered User
Posts: 73
Joined: Sun Jan 16, 2005 12:35 am
Location: Maryland USA
Contact:

Re: 3.2.2 Update Problem with updating database

Post by kholman »

Changing the config.php file to point to the original database yields

Code: Select all

	
General Error
SQL ERROR [ mysqli ]

Table 'rkholman_627forums.phpbb_config' doesn't exist [1146]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Running install to update database only in the new installation yields the original long General Error as noted in post #1 of this thread.
User avatar
janus_zonstraal
Registered User
Posts: 6418
Joined: Sat Aug 30, 2014 1:30 pm

Re: 3.2.2 Update Problem with updating database

Post by janus_zonstraal »

Delete the folders in site the cache folder
Sorry! My English is bat ;) !!!
kholman
Registered User
Posts: 73
Joined: Sun Jan 16, 2005 12:35 am
Location: Maryland USA
Contact:

Re: 3.2.2 Update Problem with updating database

Post by kholman »

Thanks to each of you who took the time to read and/or comment.
I created a new 3.2.1 installation and restored my database to there so that I am operational again.
I still don't know why this didn't work. I am surprised as I've been using phpbb since 2005, sometimes as many 9 different installations at once, and have never had any significant problem with an upgrade. I have updated 5 different forums to 3.2.2 with no issues in the last week but this one just didn't want to be.
When/if I figure out what happened (or how to avoid it recurring), I'll make this upgrade as well.
todor
Registered User
Posts: 4
Joined: Sun Jan 21, 2018 8:44 pm

Re: 3.2.2 Update Problem with updating database

Post by todor »

I have the same error here.
Have you found any solution?
kholman
Registered User
Posts: 73
Joined: Sun Jan 16, 2005 12:35 am
Location: Maryland USA
Contact:

Re: 3.2.2 Update Problem with updating database

Post by kholman »

I've not found any progress in "why" or how to fix. As noted above, I've just gone back to 3.2.1 for now.
nanno
Registered User
Posts: 39
Joined: Sun Aug 03, 2003 8:01 am

Re: 3.2.2 Update Problem with updating database

Post by nanno »

I have same problem with update from 3.2.1.
phpbb.png
todor
Registered User
Posts: 4
Joined: Sun Jan 21, 2018 8:44 pm

Re: 3.2.2 Update Problem with updating database

Post by todor »

On my installation, it turned out that I had a mod installed and forgotten. I removed it and the upgrade was successful.
nanno
Registered User
Posts: 39
Joined: Sun Aug 03, 2003 8:01 am

Re: 3.2.2 Update Problem with updating database

Post by nanno »

I have no mod installed. I think i try everything i can, but no. I have to restore forum from backup to 3.2.1.
Post Reply

Return to “[3.2.x] Support Forum”