Multiple DB errors updating to 3.2.2

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Multiple DB errors updating to 3.2.2

Post by buksida »

Support Request Template
What version of phpBB are you using? phpBB 3.2.2
What is your board's URL? www.huahinforum.com
Who do you host your board with? ASO
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? Yes
What version of phpBB3 did you update from? phpBB 3.2.0
What extensions do you have installed? No answer given
What styles do you currently have installed? prosilver
What language(s) is your board currently using? English
Which database type/version are you using? MySQL 5
What is your level of experience? Experienced 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? Updated using the auto update package 3.2.0 > 3.2.2
Please describe your problem. Blank white page after update completes. No access to ACP.
Generated by SRT Generator
Last edited by buksida on Tue Feb 20, 2018 11:08 am, edited 1 time in total.
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Re: Blank white page after update to 3.2.2

Post by buksida »

Managed to rerun the updater and got these DB errors ...


General Error:SQL ERROR [ mysqli ] [0]SQLNo values specified for SQL IN comparison in file /home/forum/public_html/install/update/new/phpbb/db/driver/driver.php on line 996BACKTRACEFILE: (not given by php)LINE: (not given by php)CALL: installer_msg_handler()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 996CALL: trigger_error()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 547CALL: phpbb\db\driver\driver->sql_error()FILE: /home/forum/public_html/phpbb/db/driver/factory.phpLINE: 441CALL: phpbb\db\driver\driver->sql_in_set()FILE: [ROOT]/phpbb/db/migration/data/v32x/fix_user_styles.phpLINE: 48CALL: 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.phpLINE: 714CALL: call_user_func_array()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 661CALL: phpbb\db\migrator->run_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 436CALL: phpbb\db\migrator->process_data_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 288CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 241CALL: phpbb\db\migrator->update_do()FILE: /home/forum/public_html/phpbb/install/module/update_database/task/update.phpLINE: 160CALL: phpbb\db\migrator->update()FILE: /home/forum/public_html/phpbb/install/module_base.phpLINE: 149CALL: phpbb\install\module\update_database\task\update->run()FILE: /home/forum/public_html/phpbb/install/installer.phpLINE: 219CALL: phpbb\install\module_base->run()FILE: /home/forum/public_html/phpbb/install/controller/update.phpLINE: 133CALL: 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/forum/public_html/vendor/symfony/http-foundation/StreamedResponse.phpLINE: 111CALL: call_user_func()FILE: /home/forum/public_html/vendor/symfony/http-foundation/Response.phpLINE: 377CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()FILE: /home/forum/public_html/install/app.phpLINE: 62CALL: Symfony\Component\HttpFoundation\Response->send()


Followed instructions in known issues on fix_user_styles.php - problem remains.

Back to blank white page again ... HTTP 500 error
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Re: Multiple DB errors updating to 3.2.2

Post by buksida »

phpbb.jpg
User avatar
KevC
Support Team Member
Support Team Member
Posts: 72343
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Re: Multiple DB errors updating to 3.2.2

Post by KevC »

buksida wrote: Tue Feb 20, 2018 10:40 am Updated using the auto update package 3.2.0 > 3.2.2
I suspect you just don't have fully up to date files.

You don't need to use the auto update if you didn't edit any core files.
Do this
Knowledge Base - Updating 3.2.x
-:|:- Support Request Template -:|:-
Image
"Step up to red alert. Sir, are you absolutely sure? It does mean changing the bulb"
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Re: Multiple DB errors updating to 3.2.2

Post by buksida »

The core files have been edited.

I've run the update 3 times now and still get this error when it gets to the database stage.

So you think it is a file problem and not a database problem? Would using the clean 3.2.2 install package be a better option?
User avatar
GanstaZ
Registered User
Posts: 1187
Joined: Wed Oct 11, 2017 10:29 pm
Location: GZOverse

Re: Multiple DB errors updating to 3.2.2

Post by GanstaZ »

It's always better to use full package to update.
Usus est magister optimus! phpBB pre-Triton & latest php environment.
When answer lies in the question, question becomes redundant!
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Re: Multiple DB errors updating to 3.2.2

Post by buksida »

Ok - I will attempt this now and report back.
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Re: Multiple DB errors updating to 3.2.2

Post by buksida »

Makes no difference with full install - still get the same errors as posted in the screenshot above.

Is there anywhere I can go to get this fixed? Happy to pay for the work.
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Multiple DB errors updating to 3.2.2

Post by Lumpy Burgertushie »

did you delete all the old files except for the ones it tells you to keep?

even if you did, go into the folder named "store" and delete all the migration files and anything that is not a database backup file.

then purge the cache and try again.

once you have replaced all old files with new ones, the only other step is running the database update from the folder named install.
click the update tab, click update, click update database only and submit.


robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Re: Multiple DB errors updating to 3.2.2

Post by buksida »

Please try it here, i followed the guide to the letter

http://www.huahinforum.com/install/
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Multiple DB errors updating to 3.2.2

Post by Lumpy Burgertushie »

yep, you are absolutely correct. try this:
viewtopic.php?p=14903321#p14903321
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Re: Multiple DB errors updating to 3.2.2

Post by buksida »

As posted above I have already applied this code patch to phpbb/db/migration/data/v32x/fix_user_styles.php

The error remains.
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Multiple DB errors updating to 3.2.2

Post by Lumpy Burgertushie »

check the edits, maybe you made a mistake when doing them.


robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
buksida
Registered User
Posts: 336
Joined: Thu Feb 04, 2010 9:11 am

Re: Multiple DB errors updating to 3.2.2

Post by buksida »

Thanks for the quick replies.

Both files patched, repatched, check and rechecked.

Problem remains.
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Multiple DB errors updating to 3.2.2

Post by Lumpy Burgertushie »

the only other thing I can think of is are you sure you are using the install folder from the complete 3.2.2 package and not the one from the auto update package?

luck,
robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
Post Reply

Return to “[3.2.x] Support Forum”