Resolved. ALTERED the account_requests table changing the tinytext type to varchar(255), then uncommented the ConfirmAccount extension in LocalSettings and re-run the update.php script in maintenance.
...so far, so good. V On Thu, Apr 23, 2015 at 9:35 PM Valerio <[email protected]> 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 <[email protected]> > 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/3dc7bd1d03e58d960eb355a7c99ff7062a639155/backend%2Fschema%2Fmysql%2FConfirmAccount.sql >> and >> >> https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FConfirmAccount.git/3dc7bd1d03e58d960eb355a7c99ff7062a639155/backend%2Fschema%2Fmysql%2Fpatch-email-index.sql >> please >> read problem at >> http://www.mydigitallife.info/mysql-error-1170-42000-blobtext-column-used-in-key-specification-without-a-key-length/ >> tinytext >> cannot be used with unique indexed. >> >> >> On Thursday, 23 April 2015, 17:06, Valerio <[email protected]> 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 <[email protected]> wrote: >> >> > Are you using the most current confirm account version or the 1.24 >> version? >> > >> > On Thursday, April 23, 2015, Valerio <[email protected]> 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 >> > _______________________________________________ MediaWiki-l mailing list To unsubscribe, go to: https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
