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(a)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/3dc7…
and
https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FConfirmAccount.git/…
please
read problem at
http://www.mydigitallife.info/mysql-error-1170-42000-blobtext-column-used-i…
tinytext
cannot be used with unique indexed.
On Thursday, 23 April 2015, 17:06, Valerio <vmp(a)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(a)gmail.com> wrote:
Are you using the most current confirm account
version or the 1.24
version?
On Thursday, April 23, 2015, Valerio <vmp(a)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