https://bugzilla.wikimedia.org/show_bug.cgi?id=43694
--- Comment #2 from Gregor Hagedorn <[email protected]> --- Confirm Accounts does not specify versions (see e.g. http://terms.gbif.org/wiki/Special:Version) We use the master version as of 2012-12-12. I believe this change https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/ConfirmAccount.git;a=shortlog did not fix it, but for safety I have just updated confirmAccount to todays git head and tried again, the error persists. Updating (tables already existing): Adding acr_agent field to table account_requests ...A database query syntax error has occurred. The last attempted database query was: "ALTER TABLE `account_requests` ADD acr_xff VARCHAR(255) NULL default '', ADD acr_agent VARCHAR(255) NULL default '' " from within function "DatabaseBase::sourceFile( /usr/share/mediawiki20/extensions/ConfirmAccount/backend/schema/mysql/patch-acr_agent.sql )". Database returned error "1170: BLOB/TEXT column 'acr_email' used in key specification without a key length (localhost)" Both Account_xxx tables created, all other tables are fully on 1.20.2 successfully update (with ConfirmAccount disabled), when reenbling Confirm account it tries to create new tables but fails with: Creating account_requests table ...A database query syntax error has occurred. The last attempted database query was: "CREATE INDEX acr_email_token ON `account_requests` (acr_email_token) " from within function "DatabaseBase::sourceFile( /usr/share/mediawiki20/extensions/ConfirmAccount/backend/schema/mysql/Co nfirmAccount.sql )". Database returned error "1170: BLOB/TEXT column 'acr_email' used in key specification without a key length (localhost)" Thanks for looking into this! -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
