PRODUCT VERSION: MediaWiki 1.24.2 PHP 5.3.16 (cgi-fcgi) MySQL 5.1.63-cll SMW 2.1.3
Hi, after upgrading MW from 1.21 to 1.24 and (among other extensions) to the newest ConfirmAccount Extension, when I run the update script from the command line I get the following error:
*Adding acr_agent field to table account_requests ...A database query error has o ccurred.* *Query: ALTER TABLE `account_requests`* * ADD acr_xff VARCHAR(255) NULL default '',* * ADD acr_agent VARCHAR(255) NULL default ''*
*Function: DatabaseBase::sourceFile( /home/tunearch/public_html/w/extensions/Conf irmAccount/backend/schema/mysql/patch-acr_agent.sql )* *Error: 1170 BLOB/TEXT column 'acr_email' used in key specification without a key length (localhost)*
*<br />* *<b>Notice</b>: Uncommitted DB writes (transaction from DatabaseUpdater::doUpdat es). in <b>/home/tunearch/public_html/w/includes/db/Database.php</b> on line <b> 4266</b><br />* *es). in <b>/home/tunearch/public_html/w/includes/db/Database.php</b> on line <b> *
I had to comment out ConfirmAccount in LocalSettings and re-run the update script to get the site up and running. Any other encountered a similar problem with ConfirmAccount? Any suggestion to work around the problem?
Thank you.