SMF
SMF copied to clipboard
[3.0]: New columns not being added to tables
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
- Try upgrading a forum on PostgreSQL (this should affect MySQL as well but #8197 is preventing it from getting that far at that point)
- 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:
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.