DB Update from 3.0.12 to 3.2.11 fails

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Yepman67
Registered User
Posts: 5
Joined: Thu Dec 07, 2006 9:05 am

DB Update from 3.0.12 to 3.2.11 fails

Post by Yepman67 »

Since the v3.0.x section is closed, i am asking here.

I tried to update from phpBB 3.0.12 to 3.2.11 and the DB update fails. I am using PostgresQL 13 and the error message is:
ERROR: column "consrc" does not exist

SQLSELECT consrc as constraint_data FROM pg_constraint, pg_class bc WHERE ...
For whatever reason, a postgres system catalog is queried, but the field "consrc" has been removed from the system table "pg_constraint" with Postgres v12. So this can not work. Is no one using Postgres, or why is this bug for so long undetected? Has anyone an idea, how to fix the problem?
User avatar
janus_zonstraal
Registered User
Posts: 6494
Joined: Sat Aug 30, 2014 1:30 pm

Re: DB Update from 3.0.12 to 3.2.11 fails

Post by janus_zonstraal »

What update method are you following?
See https://www.phpbb.com/support/docs/en/3 ... /upgrade3/
Why going to 3.2.11?
I would try to go to 3.1.0 first
Sorry! My English is bat ;) !!!
Yepman67
Registered User
Posts: 5
Joined: Thu Dec 07, 2006 9:05 am

Re: DB Update from 3.0.12 to 3.2.11 fails

Post by Yepman67 »

When the code accesses a non-existing field of a system table (that is: an internal table that belongs to the Postgres database, not to phpBB), it doesn't matter which method you use or to what version you update first. The problem will remain.
Yepman67
Registered User
Posts: 5
Joined: Thu Dec 07, 2006 9:05 am

Re: DB Update from 3.0.12 to 3.2.11 fails

Post by Yepman67 »

I checked now the source code of phpBB 3.1.12

line 1320: // Generate constraint clauses for CHECK constraints
$sql_checks = "SELECT conname as index_name, consrc
FROM pg_constraint, pg_class bc
WHERE

As I tried to explain: the column "consrc" was removed from the Postgres system table "pg_constraint" in Postgres version 12. Postgres is now at version 16, so this bug must be in the phpBB code since October 2019 (release date of Postgres v12).
Yepman67
Registered User
Posts: 5
Joined: Thu Dec 07, 2006 9:05 am

Re: DB Update from 3.0.12 to 3.2.11 fails

Post by Yepman67 »

How can I reach the developers?
User avatar
janus_zonstraal
Registered User
Posts: 6494
Joined: Sat Aug 30, 2014 1:30 pm

Re: DB Update from 3.0.12 to 3.2.11 fails

Post by janus_zonstraal »

Sorry! My English is bat ;) !!!

Return to “[3.2.x] Support Forum”