Jump to content

Topic on Project:Support desk

[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.

Kghbln (talkcontribs)

I ran into this when using a foreign file repo via the ForeignDBRepo class. The providing wiki was updated to 1.35 the receiving wiki was still at 1.31. After also updating the receiving wiki to 1.35 the error went away.

Kghbln (talkcontribs)

Oops, actually in my case the issue was Error: 1054 Unknown column 'img_description' in 'field list' (localhost)