So confirmaccount works again.
On Thursday, 23 April 2015, 21:16, Thomas Mulhall
<[email protected]> wrote:
Please see problem described at https://phabricator.wikimedia.org/T84999 and
please say you have the problem there.
On Thursday, 23 April 2015, 20:36, 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
