https://bugzilla.wikimedia.org/show_bug.cgi?id=38422
--- Comment #1 from Antoine "hashar" Musso <[email protected]> 2012-07-16 19:20:21 UTC --- 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. -- Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
