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.
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
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
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
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... and
https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FConfirmAccount.git/3... please read problem at http://www.mydigitallife.info/mysql-error-1170-42000-blobtext-column-used-in... tinytext 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
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 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... and
https://git.wikimedia.org/blob/mediawiki%2Fextensions%2FConfirmAccount.git/3... please read problem at http://www.mydigitallife.info/mysql-error-1170-42000-blobtext-column-used-in... tinytext 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
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
So confirmaccount works again.
On Thursday, 23 April 2015, 21:16, Thomas Mulhall thomasmulhall410@yahoo.com wrote:
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
mediawiki-l@lists.wikimedia.org