Last modified: 2013-02-04 19:41:21 UTC
I just upgraded to MediaWiki 1.20.2 today. I downloaded and put in place the wikimedia-mediawiki-extensions-ConfirmAccount-83ae0c9.tar.gz file and following the instructions http://www.mediawiki.org/wiki/Extension:ConfirmAccount When I ran php-5.3 maintenance/update.php I got the following: [...] ...have cuc_private field in cu_changes table. Creating account_requests table ...A database query syntax error has occurred. The last attempted database query was: "CREATE INDEX acr_email_token ON `wiki_account_requests` (acr_email_token) " from within function "DatabaseBase::sourceFile( [...]/w/extensions/ConfirmAccount/backend/schema/mysql/ConfirmAccount.sql )". Database returned error "1170: BLOB/TEXT column 'acr_email' used in key specification without a key length (mysql.partimus.org)"
[...]w/extensions/ConfirmAccount/backend/schema/mysql/patch-account_credentials.sql had similar problems with the ALTER TABLE line "ADD INDEX acr_type_del_reg (acr_type,acr_deleted,acr_registration) "
*** This bug has been marked as a duplicate of bug 43694 ***
I think there are several separate problems that any new user of this extension will encounter when following the instructions. This problem on a new, vanilla install seems to be with the creation of a key on a blog field that seem related to the version of MySQL (5.1.56) that my hosting provider is running. This is indeed described in the bug 43694. I tried to approve my first account and it had another problem that may need a new bug. To make it work I changed the file x. It seems to have created an account successfully. >--- AccountConfirmSubmission.orig 2012-11-03 16:20:59.000000000 -0700 >+++ AccountConfirmSubmission.php 2013-01-21 05:01:05.880254769 -0800 >@@ -219,8 +219,8 @@ > 'acd_notes' => $accReq->getNotes(), > 'acd_urls' => $accReq->getUrls(), > 'acd_ip' => $accReq->getIP(), >- 'acd_xff' => $accReq->getXFF(), >- 'acd_agent' => $accReq->getAgent(), >+ #'acd_xff' => $accReq->getXFF(), >+ #'acd_agent' => $accReq->getAgent(), > 'acd_filename' => $accReq->getFileName(), > 'acd_storage_key' => $accReq->getFileStorageKey(), > 'acd_areas' => $accReq->getAreas( 'flat' ),
Created attachment 11667 [details] required submission patch Oops, the markup didn't work on my comment so I'm attaching this two liner.
grantbow: This bug report is closed - please attach comments and patches to bug 43694 instead, see comment 2.