Wikimedia Bugzilla is closed!

I have renamed the existing aft_article_% and article_feedback% tables with the '_back' prefix.


(mw@deployment-sql) [enwiki]> show tables like 'aft%';
+---------------------------------------------------+
| Tables_in_enwiki (aft%)                           |
+---------------------------------------------------+
| aft_article_answer_back                           |
| aft_article_answer_text_back                      |
| aft_article_feedback_back                         |
| aft_article_feedback_properties_back              |
| aft_article_feedback_ratings_rollup_back          |
| aft_article_feedback_select_rollup_back           |
| aft_article_field_back                            |
| aft_article_field_group_back                      |
| aft_article_field_option_back                     |
| aft_article_filter_count_back                     |
| aft_article_revision_feedback_ratings_rollup_back |
| aft_article_revision_feedback_select_rollup_back  |
+---------------------------------------------------+
12 rows in set (0.00 sec)

(mw@deployment-sql) [enwiki]> show tables like 'article%';
+-----------------------------------+
| Tables_in_enwiki (article%)       |
+-----------------------------------+
| article_feedback_back             |
| article_feedback_pages_back       |
| article_feedback_properties_back  |
| article_feedback_revisions_back   |
| article_feedback_stats_back       |
| article_feedback_stats_types_back |
+-----------------------------------+
6 rows in set (0.00 sec)

(mw@deployment-sql) [enwiki]> 

When running the installer with:

 mwscript update.php --wiki=enwiki --quick
MediaWiki 1.20alpha Updater

I get the following error:



Creating article_feedback table...done.
...article_feedback table already exists.
...index aa_page_id already set on article_feedback table.
...have aa_design_bucket field in article_feedback table.
...have afp_value_text field in article_feedback_properties table.
...article_feedback_properties table already exists.
...article_feedback_revisions table already exists.
...article_feedback_stats_types table already exists.
...article_feedback_stats table already exists.
...index article_feedback_timestamp already set on article_feedback table.
...index aa_page_user_token already set on article_feedback table.
...aa_user_page_revision key doesn't exist.
...article_feedback table already exists.
Creating aft_article_answer_text table...A database query syntax error has occurred.
The last attempted database query was:
"ALTER TABLE `aft_article_answer`
 ADD COLUMN aat_id integer unsigned NULL AFTER aa_response_text
"
from within function "DatabaseBase::sourceFile( /usr/local/apache/common-local/php-master/extensions/ArticleFeedbackv5/sql/offload_large_feedback.sql )".
Database returned error "1146: Table 'enwiki.aft_article_answer' doesn't exist (deployment-sql)"


So the aft_article_answer table is not created for some reason. Only the `aft_article_answer_text` table is created.

Table cleaning is done with:


DROP TABLE article_feedback;
DROP TABLE article_feedback_pages;
DROP TABLE article_feedback_properties;
DROP TABLE article_feedback_revisions;
DROP TABLE article_feedback_stats ;
DROP TABLE article_feedback_types ;
DROP TABLE article_feedback_stats_types;
DROP TABLE aft_article_answer_text ;

I had to tweak ArticleFeedbackv5 extension:

https://gerrit.wikimedia.org/r/#/c/15731/ fix install on SQLite
https://gerrit.wikimedia.org/r/#/c/15734/ fix DB install when ArticleFeedback is already there

Deployed 15734 on beta as a live hack.


The special page seems to be working again. Assuming fixed.

http://en.wikipedia.beta.wmflabs.org/wiki/Special:ArticleFeedbackv5