Page MenuHomePhabricator

ug_expiry column of the user_groups table is not present after update from 1.28.2 to 1.29.0
Closed, DeclinedPublic

Description

Just updated our productive wiki from v1.28.2 to v1.29.0.

Run same procedure as always and for sure ran "maintenance/update.php".

I can view our wiki but cannot login.

Whenever I try to log in I get an "Fataler Ausnahmefehler des Typs „Wikimedia\Rdbms\DBQueryError“!" which means fatal error.

Debug output :
Error: 1054 "Unknown column 'ug_expiry' in 'field list'".

Solution:
I had to add column 'ug_expiry' manually to DB.

Related reports (found by searching for debug output):

System information:

Server: Localhost via UNIX socket
Server-Typ: MySQL
Server-Version: 5.7.19-0ubuntu0.16.04.1 - (Ubuntu)
Protokoll-Version: 10
Server-Zeichensatz: UTF-8 Unicode (utf8)

Basic problem:
Update script is not adding missing column

Event Timeline

We had the same issue during update from 1.28.2 to 1.29.0; in our case it appeared Flow was enabled and seemed to require this schema change before it was applied by MediaWiki updater (hypothesis to be verified). It worked by deactivating Flow, updating, reactivating Flow, re-updating.

Just for the records: We do not use Flow

Reedy subscribed.

No further reports... Both releases are no longer supported