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
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
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:
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