Page MenuHomePhabricator

Drop the unused userft_order column from the user_fantag table
Closed, ResolvedPublic

Description

It appears to be literally unused since forever, and that it's defined as NOT NULL is causing issues under PostgreSQL as FanBox::addUserFan does not set a value for that colum and thus it ends up being NULL and that results in DB errors under PostgreSQL at least when trying to create a new userbox via Special:UserBoxes: Error: 23502 ERROR: null value in column "userft_order" violates not-null constraint.

(Note that PostgreSQL support for FanBoxes is not yet in master and won't land until the work on T227345 is finished.)

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Change 570165 had a related patch set uploaded (by Jack Phoenix; owner: Jack Phoenix):
[mediawiki/extensions/FanBoxes@master] Drop unused user_fantag.userft_order column

https://gerrit.wikimedia.org/r/570165

Change 570165 merged by Jack Phoenix:
[mediawiki/extensions/FanBoxes@master] Drop unused user_fantag.userft_order column

https://gerrit.wikimedia.org/r/570165

ashley removed a project: Patch-For-Review.