Upgrading 3.3.2 to 3.3.10 database update issue.

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
agaveville
Registered User
Posts: 44
Joined: Fri Nov 13, 2020 6:19 pm

Upgrading 3.3.2 to 3.3.10 database update issue.

Post by agaveville »

Upgrading from 3.3.2 to the latest 3.3.10 and encountered the following during database update. I don't have a clue. Please help.

Code: Select all

General Error:SQL ERROR [ postgres ]ERROR: syntax error at or near "FROM" LINE 2: SELECT FROM information_schema.tables ^ []SQLSELECT CAST(EXISTS( SELECT FROM information_schema.tables WHERE table_schema = 'public' AND table_name = 'phpbb_migrations' ) AS INTEGER) LIMIT 1 OFFSET 0 in file /home3/germanst/public_html/phpbb/db/driver/driver.php on line 1023
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
Last edited by agaveville on Sat Jun 03, 2023 4:43 pm, edited 4 times in total.
agaveville
Registered User
Posts: 44
Joined: Fri Nov 13, 2020 6:19 pm

Re: Install Issue

Post by agaveville »

It appears that the Setup was unable to update the postgres database, and HostMonster has no idea.

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

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

Files Version
3.3.10

Database version
3.3.2
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Install Issue

Post by Lumpy Burgertushie »

upload the folder named "install" from the full package of phpBB 3.3.10 to your board root.

go to yourboard/install.
click on update database only

when that gives you a success message delete the folder named install and you should be fine.

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.
agaveville
Registered User
Posts: 44
Joined: Fri Nov 13, 2020 6:19 pm

Re: Install Issue

Post by agaveville »

Lumpy Burgertushie wrote: Sat Jun 03, 2023 1:14 am upload the folder named "install" from the full package of phpBB 3.3.10 to your board root.

go to yourboard/install.
click on update database only

when that gives you a success message delete the folder named install and you should be fine.

robert
Doing exactly that is what generated the error message. Database is apparently not updating for reason or reasons unknown.
User avatar
janus_zonstraal
Registered User
Posts: 6414
Joined: Sat Aug 30, 2014 1:30 pm

Re: Install Issue

Post by janus_zonstraal »

Can you test the update on a other server?
Sorry! My English is bat ;) !!!
User avatar
ssl
Registered User
Posts: 1580
Joined: Sat Feb 08, 2020 2:15 pm
Location: Le Lude, Pays de la Loire - France
Name: Fred Rimbert
Contact:

Re: Upgrading 3.2 to 3.3 database update issue.

Post by ssl »

Try this, delete the install_config.php file present in the store/ directory at the root of your forum.
There you can restart the update (with the install folder from full upgrade). It will give you an orange alert, you continue and there it will just update the database.
Sorry for my English ... I do my best!

phpBB: 3.3.11 | PHP: 8.2.16
[GitHub] - [Kill spam on phpBB] - [Some French translation of extensions]
"Mistress, Mistress someone is bothering me in pm"
User avatar
Mick
Support Team Member
Support Team Member
Posts: 26455
Joined: Fri Aug 29, 2008 9:49 am

Re: Install Issue

Post by Mick »

agaveville wrote: Sat Jun 03, 2023 12:15 am
Files Version
3.3.10

Database version
3.3.2
Have you had a previous upgrade fail?
  • "The more connected we get the more alone we become" - Kyle Broflovski©
  • "The good news is hell is just the product of a morbid human imagination.
    The bad news is, whatever humans can imagine, they can usually create.
    " - Harmony Cobel
agaveville
Registered User
Posts: 44
Joined: Fri Nov 13, 2020 6:19 pm

Re: Upgrading 3.2 to 3.3 database update issue.

Post by agaveville »

ssl wrote: Sat Jun 03, 2023 8:59 am Try this, delete the install_config.php file present in the store/ directory at the root of your forum.
There you can restart the update (with the install folder from full upgrade). It will give you an orange alert, you continue and there it will just update the database.
Thanks, just tried it, but it ended with the same error message.
agaveville
Registered User
Posts: 44
Joined: Fri Nov 13, 2020 6:19 pm

Re: Install Issue

Post by agaveville »

Mick wrote: Sat Jun 03, 2023 10:10 am
agaveville wrote: Sat Jun 03, 2023 12:15 am
Files Version
3.3.10

Database version
3.3.2
Have you had a previous upgrade fail?
No, I haven't.
agaveville
Registered User
Posts: 44
Joined: Fri Nov 13, 2020 6:19 pm

Re: Install Issue

Post by agaveville »

janus_zonstraal wrote: Sat Jun 03, 2023 8:47 am Can you test the update on a other server?
I have no way to do that. Forum is currently hosted on HostMonster. My first assumption was that this was a hosting issue, and I've been on the phone with them trying to shake it out, but no joy.
User avatar
janus_zonstraal
Registered User
Posts: 6414
Joined: Sat Aug 30, 2014 1:30 pm

Re: Upgrading 3.3.2 to 3.3.10 database update issue.

Post by janus_zonstraal »

You can use my server if you want to test it out.
Sorry! My English is bat ;) !!!
agaveville
Registered User
Posts: 44
Joined: Fri Nov 13, 2020 6:19 pm

Re: Upgrading 3.3.2 to 3.3.10 database update issue.

Post by agaveville »

janus_zonstraal wrote: Sat Jun 03, 2023 4:46 pm You can use my server if you want to test it out.
Thanks that's very generous, but it's a pretty big site with a LOT of attachments (18 gb) and I am not server side savvy at all.

It seems to me that either the server is causing a database access or permissions issue, or there is an issue with the database. I am guessing phpBB would report a corrupt database, so I suspect the former. Hostmonster escalated support is supposed to contact me today. Fingers crossed.
User avatar
janus_zonstraal
Registered User
Posts: 6414
Joined: Sat Aug 30, 2014 1:30 pm

Re: Upgrading 3.3.2 to 3.3.10 database update issue.

Post by janus_zonstraal »

You only need the database for a update, not the files.
Sorry! My English is bat ;) !!!
agaveville
Registered User
Posts: 44
Joined: Fri Nov 13, 2020 6:19 pm

Re: Upgrading 3.3.2 to 3.3.10 database update issue.

Post by agaveville »

janus_zonstraal wrote: Sat Jun 03, 2023 7:21 pm You only need the database for a update, not the files.
I'm not sure about the database. It takes up about 750 mb on the postgres server. I exported all data and structure, and the uncompressed result is only 111 mb. And it's an SQL file. Does that sound right on any level?
User avatar
janus_zonstraal
Registered User
Posts: 6414
Joined: Sat Aug 30, 2014 1:30 pm

Re: Upgrading 3.3.2 to 3.3.10 database update issue.

Post by janus_zonstraal »

That is possible.
Sorry! My English is bat ;) !!!
Post Reply

Return to “[3.3.x] Support Forum”