SMF icon indicating copy to clipboard operation
SMF copied to clipboard

[3.0]: New columns not being added to tables

Open Oldiesmann opened this issue 9 months ago • 1 comments

Basic Information

When running upgrade.php, you will run into an error when you hit the db_fetch call on line 1933 of upgrade.php because we're trying to pull id_event and uid from the calendar table but no uid column has been added at that point

Steps to reproduce

  1. Try upgrading a forum on PostgreSQL (this should affect MySQL as well but #8197 is preventing it from getting that far at that point)
  2. Blank screen after backup because there is no "uid" column in the calendar table

Expected result

Expect upgrade to run smoothly

Actual result

Fatal error: Uncaught TypeError: SMF\\Db\\APIs\\PostgreSQL::fetch_assoc(): Argument #1 ($result) must be of type object, false given, called in /.../upgrade.php on line 1933

Version/Git revision

76f5ccf

Database Engine

PostgreSQL

Database Version

PostgreSQL 14.11

PHP Version

8.3.6

Logs

No response

Additional Information

Screenshots showing that the new columns haven't been added to the calendar table in either MySQL or Postgres: image image

Oldiesmann avatar May 05 '24 23:05 Oldiesmann

I should also note that I didn't run into this while working to debug the previous upgrade issues because I had already manually added the missing columns in phpMyAdmin.

Oldiesmann avatar May 05 '24 23:05 Oldiesmann