Conversion from phpBB2 (2.0.21) to 3.3 not working

[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.

[JLA]

Have you thought about switching to another host who supports legacy platforms like PHPBB2?

[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