Upgrade procedure on PostgreSQL is broken

[MasterMind2k]

Hi.

I am trying to upgrade phpbb 3.2.11 to 3.3.14 on PostgreSQL 9.1 server. I've encountered the following error:

Code: Select all

PHP Fatal error:  SQL ERROR [ postgres ]<br /><br />ERROR:  relation "phpbb_migrations" already exists []<br /><br />An SQL error occurred while fetching this page. Please contact the <a href="mailto:[email protected]">Board Administrator</a> if this problem persists. in /var/www/podnapisi/forum/phpbb/db/driver/driver.php on line 1031

Applying following patch fixes the problem:

Code: Select all

commit f9ff7c2f0260688e3c8445684b9f38579af2c9c1 (HEAD -> upgrade-phpbb)
Author: Gregor Kališnik <[email protected]>
Date:   Sat Jan 4 13:49:07 2025 +0000

    Allow migration to finish

diff --git a/docker/phpbb/forum/phpbb/db/tools/postgres.php b/docker/phpbb/forum/phpbb/db/tools/postgres.php
index 2074dbc9..26cb5896 100644
--- a/docker/phpbb/forum/phpbb/db/tools/postgres.php
+++ b/docker/phpbb/forum/phpbb/db/tools/postgres.php
@@ -105,7 +105,7 @@ class postgres extends tools
                        SELECT * FROM information_schema.tables
                                WHERE table_schema = 'public'
                                        AND table_name   = '" . $this->db->sql_escape($table_name) . "'
-                       ) AS INTEGER)";
+                       ) AS INTEGER) AS exists";
                $result = $this->db->sql_query_limit($sql, 1);
                $row = $this->db->sql_fetchrow($result);
                $table_exists = (booL) $row['exists'];

Thank you!

[thecoalman]

Tickets can be submitted to bug tracker: https://tracker.phpbb.com/secure/Dashboard.jspa