Page MenuHomePhabricator

test.wikipedia.beta.wmflabs.org is misconfigured (AFTv5 database tables not set up)
Closed, ResolvedPublic

Description

http://test.wikipedia.beta.wmflabs.org/wiki/Special:Contributions/67.188.213.98 gives a database error. Please either run the SQL script to set up AFT tables, or disable the feature.


Version: unspecified
Severity: major

Details

Reference
bz45318

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 1:20 AM
bzimport set Reference to bz45318.
bzimport added a subscriber: Unknown Object (MLST).

The error message is:

from within function "ArticleFeedbackv5Hooks::contributionsData". Database returned error "1054: Unknown column 'af_net_helpfulness' in 'field list' (10.4.0.53)".

I suspect the AFTv5 is missing the database updater to populate that field. Reassigning bug to the AFTv5 component. Once the updater is added, we can run the database update.

Antoine: there is no history of what db update came when - at that time, no update scripts were made.

The missing column has been introduced in extensions/ArticleFeedbackv5/sql/wmfupdate-jan31.sql (and there appears to be a follow-up update extensions/ArticleFeedbackv5/sql/wmfupdate-mar8.sql)

I guess you could either:

  • try running these 2 scripts, then running the updater (which is since being maintained)
  • nuke the existing aft_* tables and run extensions/ArticleFeedbackv5/sql/ArticleFeedbackv5.sql
  • reach me on IRC to help me get into the beta db, and I'll figure out what shape the AFTv5 tables are in and fix them up myself (I've so far been unable to connect)

Thanks Matthias! Will run the SQL snippet on the various databases using AFT.

To connect to the sql databases I use a lame shell wrapper like:

USER=php -r 'include("/home/wikipedia/common/wmf-config/PrivateSettings.php"); print $wgDBuser;'
PASS=php -r 'include("/home/wikipedia/common/wmf-config/PrivateSettings.php"); print $wgDBpassword;'
HOST="deployment-sql"

mysql -u $USER -p$PASS -h $HOST

We should really use the production wrapper for which I opened bug 45706

I thought that fixing the tables manually was going to take a bit of a time so I just deleted all 'aft%' tables and ran update.php on the wiki using it: testwiki enwiki and dewiki