Conversion from phpBB2 (2.0.21) to 3.3 not working

Get help with installation and running phpBB 3.3.x here. Please do not post bug reports, feature requests, or extension related questions here.
phinster
Registered User
Posts: 1
Joined: Thu Apr 11, 2024 3:37 am

Conversion from phpBB2 (2.0.21) to 3.3 not working

Post by phinster »

I had phpBB2 (2.0.21) running in an EC2 Amazon Linux server with PostgreSQL for several years. I was recently informed that the Amazon Linux was now an unsupported OS and I needed to rebuild using a more recent AMI image. I have now setup another EC2 instance running Amazon Linux 2023 that has PostgreSQL 15 and PHP 8.2 installed. I have downloaded phpBB3 (3.3.11) and followed the directions for converting the database but keep getting an error when I use the URL [website]/phpBB3/install/app.php/convert:

Code: Select all

{"errors":[{"title":"General Error:SQL ERROR [ postgres ]ERROR: column \"is_dynamic\" does not exist\nLINE 1: SELECT config_name, config_value, is_dynamic\n ^ []SQLSELECT config_name, config_value, is_dynamic\n\t\t\t\tFROM phpbb_config in file \/var\/www\/vdoms\/mths1957\/phpBB3\/phpbb\/db\/driver\/driver.php on line 1023"}],"warnings":[{"title":"[phpBB Debug] \"pg_query(): Query failed: ERROR: column "is_dynamic" does not exist\nLINE 1: SELECT config_name, config_value, is_dynamic\n ^\" in file \/var\/www\/vdoms\/mths1957\/phpBB3\/phpbb\/db\/driver\/postgres.php on line 191"}],"over":true}
I know the is_dynamic column does not exist in phpBB2, so I am not sure why it is looking for it. Any assistance or guidance would be appreciated as I have exhausted my search options without finding a working solution.
Last edited by Mick on Thu Apr 11, 2024 7:55 am, edited 1 time in total.
Reason: Code tags added for clarity.
User avatar
JLA
Registered User
Posts: 618
Joined: Tue Nov 16, 2004 5:23 pm
Location: USA
Name: JLA FORUMS

Re: Conversion from phpBB2 (2.0.21) to 3.3 not working

Post by JLA »

Have you thought about switching to another host who supports legacy platforms like PHPBB2?
User avatar
Helter Skelter
Registered User
Posts: 151
Joined: Tue Jan 25, 2005 8:22 am
Location: integramod.com

Re: Conversion from phpBB2 (2.0.21) to 3.3 not working

Post by Helter Skelter »

Heres a suggestion. I have a phpBB3.0x that will run on php8.3.
https://github.com/IntegraMOD/phpbb3.0.15
its a natural update path for phpBB2.
You could update to it and then update it to 3.3

note.. phpBB3.3 will probably look for the version number so before installing 3.0.15, edit install/schemas/schema_data.sql
FIND

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '3.0.15');
change the 15 to 14 (the last official version)

now the 3.3 update should be uneventful
just remember to make good db backups for each stage

Return to “[3.3.x] Support Forum”