Please see problem described at https://phabricator.wikimedia.org/T84999%C2%A0and please say you have the problem there.
On Thursday, 23 April 2015, 20:36, Valerio vmp@silkwood.it wrote:
The (supposed) wrong table has the following schema:
+-------------------------+-----------------------+------+-----+---------+----------------+| Field | Type | Null | Key | Default | Extra |+-------------------------+-----------------------+------+-----+---------+----------------+| acr_id | int(10) unsigned | NO | PRI | NULL | auto_increment || acr_name | varchar(255) | NO | UNI | | || acr_real_name | varchar(255) | NO | | | || acr_email | tinytext | NO | UNI | NULL | || acr_email_authenticated | binary(14) | YES | | NULL | || acr_email_token | binary(32) | YES | MUL | NULL | || acr_email_token_expires | binary(14) | YES | | NULL | || acr_bio | mediumblob | NO | | NULL | || acr_notes | mediumblob | NO | | NULL | || acr_urls | mediumblob | NO | | NULL | || acr_ip | varchar(255) | YES | | | || acr_filename | varchar(255) | YES | | NULL | || acr_storage_key | varchar(64) | YES | | NULL | || acr_type | tinyint(255) unsigned | YES | MUL | 0 | || acr_areas | mediumblob | NO | | NULL | || acr_registration | char(14) | NO | | NULL | || acr_deleted | tinyint(1) | NO | | NULL | || acr_rejected | binary(14) | YES | | NULL | || acr_held | binary(14) | YES | | NULL | || acr_user | int(10) unsigned | NO | | 0 | || acr_comment | varchar(255) | NO | | | |+-------------------------+-----------------------+------+-----+---------+----------------+21 rows in set (0.08 sec) Now the Wiki is running w/o the ConfirmAccount extension.What I have to do?Please help me! Valerio On Thu, Apr 23, 2015 at 6:20 PM Thomas Mulhall thomasmulhall410@yahoo.com wrote:
It seems that one of the patches to change the table has wrong type in it please see https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FConfirmAccount/3dc7b... https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FConfirmAccount.git/3... read problem at http://www.mydigitallife.info/mysql-error-1170-42000-blobtext-column-used-in... cannot be used with unique indexed.
On Thursday, 23 April 2015, 17:06, Valerio vmp@silkwood.it wrote:
I'm using the latest stable one (1.24) as per download link ( http://www.mediawiki.org/wiki/Special:ExtensionDistributor/ConfirmAccount). Ciao, V
On 23 April 2015 at 15:53, John phoenixoverride@gmail.com wrote:
Are you using the most current confirm account version or the 1.24 version?
On Thursday, April 23, 2015, Valerio vmp@silkwood.it wrote:
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.
-- Valerio M. Pelliccioni _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
-- Valerio M. Pelliccioni _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
_______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l