It seems that one of the patches to change the table has wrong type in it please see
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 (
).
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: