Topic on Project:Support desk

Jump to navigation Jump to search

[RESOLVED] After Update Error: 1054 Unknown column 'ug_expiry' in 'field list' (localhost)

Nelodie (talkcontribs)


After a upgrade of Ubuntu ( to 16.04) My dear wiki developped on mediawiki 1.23 was not work. After some search on web, I decided to update also mediawiki to last version 1.29 by following all instructions described in Update manuel.

So basicaly, I dump my DB, save in tar.gz files before download the mediawiki-1.29.1.tar.gz.

After all my images folder was copied and extensions are updated I run also the update.php script wiith no error.

The first run my wiki home page I obtain just a error about "wfLoadSkin( 'Vector' );" forgotten. So I modified correctly the LocalSettings.php file and run again the home page of my wiki... but I have this SQL error 

6e1e893ddacaf2198378f128] /wiki/index.php/Accueil Wikimedia\Rdbms\DBQueryError from line 1075 of /var/lib/mediawiki/includes/libs/rdbms/database/Database.php: A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? 

Query: SELECT ug_user,ug_group,ug_expiry FROM `user_groups` WHERE ug_user = '31' 

Function: UserGroupMembership::getMembershipsForUser

Error: 1054 Unknown column 'ug_expiry' in 'field list' (localhost)

I was tried to update manually the DB by dump but the error stay.

Could you help me ? 

Produit Version
MediaWiki 1.29.1
PHP 7.0.22-0ubuntu0.16.04.1 (apache2handler)
MySQL 5.7.19-0ubuntu0.16.04.1


Osnard (talkcontribs)
Nelodie (talkcontribs)

Thanks you very much @Osnard

I  applied manually your SQL Code and the wiki appeared and worked fine.


MarkAHershberger (talkcontribs)

I ran into this when I tried to upgrade with Flow enabled. Disabling Flow temporarily allowed the upgrade o work.

Reply to "[RESOLVED] After Update Error: 1054 Unknown column 'ug_expiry' in 'field list' (localhost)"