Last modified: 2013-03-04 17:50:45 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T47318, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 45318 - test.wikipedia.beta.wmflabs.org is misconfigured (AFTv5 database tables not set up)
test.wikipedia.beta.wmflabs.org is misconfigured (AFTv5 database tables not s...
Status: RESOLVED FIXED
Product: MediaWiki extensions
Classification: Unclassified
ArticleFeedbackv5 (Other open bugs)
unspecified
All All
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2013-02-24 06:25 UTC by This, that and the other (TTO)
Modified: 2013-03-04 17:50 UTC (History)
8 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description This, that and the other (TTO) 2013-02-24 06:25:25 UTC
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.
Comment 1 Antoine "hashar" Musso (WMF) 2013-02-28 22:35:53 UTC
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.
Comment 2 Matthias Mullie 2013-03-04 15:49:10 UTC
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)
Comment 3 Antoine "hashar" Musso (WMF) 2013-03-04 17:24:28 UTC
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
Comment 4 Antoine "hashar" Musso (WMF) 2013-03-04 17:50:45 UTC
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

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links