Page MenuHomePhabricator

php maintenance/update.php fails with "1146: Table 'lambdadb.ald_account_requests' doesn't exist (localhost)"
Closed, DeclinedPublic

Description

Author: adrian.aichner

Description:
Hi!

I must admit I ran the setup multiple times until I got my LocalSettings.php right.

This is how far I got after using correct DB user and password.

Is there a way to uninstall/reinstall the ConfirmAccount extension?

My version information:

Product Version
MediaWiki 1.15.5-1
PHP 5.3.3-1ubuntu9.3 (apache2handler)
MySQL 5.1.49-1ubuntu8.1
ConfirmAccount-MW1.15-r52640.tar.gz
Linux tanga 2.6.35-27-generic #48-Ubuntu SMP Tue Feb 22 20:25:29 UTC 2011 i686 GNU/Linux

Thanks!

Adrian

/var/lib/mediawiki # php maintenance/update.php
...
Checking filearchive indices...
...have ss_active_users field in site_stats table.
...ss_active_users user count set...
...have ipb_allow_usertalk field in ipblocks table.
...pl_namespace, tl_namespace, il_to indices are already UNIQUE.
...change_tag table already exists.
...tag_summary table already exists.
...valid_tag table already exists.
Creating account_credentials table...A database query syntax error has occurred.
The last attempted database query was:
"ALTER TABLE ald_account_requests
ADD acr_type tinyint(255) default 0,
DROP INDEX acr_deleted_reg,
ADD INDEX acr_type_del_reg (acr_type,acr_deleted,acr_registration)
"
from within function "Database::sourceStream".
Database returned error "1146: Table 'lambdadb.ald_account_requests' doesn't exist (localhost)"
/var/lib/mediawiki #


Version: unspecified
Severity: normal
OS: Linux

Details

Reference
bz28008

Event Timeline

bzimport raised the priority of this task from to Lowest.Nov 21 2014, 11:30 PM
bzimport set Reference to bz28008.

adrian.aichner wrote:

Workaround:

I was able to overcome this problem with

root@tanga:/var/lib/mediawiki# cd extensions/ConfirmAccount/
root@tanga:/var/lib/mediawiki/extensions/ConfirmAccount# mysql -h localhost -u root -p lambdadb < ConfirmAccount.sql
Enter password:
root@tanga:/var/lib/mediawiki/extensions/ConfirmAccount#

I had done this to ConfirmAccount.sql first:
(query-replace "/*$wgDBprefix*/" "ald_" nil)

Adrian

MediaWiki 1.15 is out of support per http://www.mediawiki.org/wiki/Version_lifecycle, as well as extensions in its branch. This particluar bug is fixed in ConfirmAccount for 1.16+, please upgrade.

adrian.aichner wrote:

Thanks!

I can confirm this from my and.

I got 1.16+ to work with my MW 1.5 installation.

The trunk version of ConfirmAccount fails with following error
(with debugging enabled via following two lines in LocalSettings.php

error_reporting(E_ALL);
ini_set("display_errors", 1);

)

Fatal error: Call to undefined method OutputPage::addModules() in /var/lib/mediawiki/extensions/ConfirmAccount/ConfirmAccount.php on line 157

adrian.aichner wrote:

(In reply to comment #3)

Thanks!

I can confirm this from my and.

I got 1.16+ to work with my MW 1.5 installation.

Correction:
I am using
MediaWiki 1.15.5-1

(In reply to comment #4)

(In reply to comment #3)

Thanks!

I can confirm this from my and.

I got 1.16+ to work with my MW 1.5 installation.

Correction:
I am using
MediaWiki 1.15.5-1

ConfirmAccount 1.16 needs MediaWiki 1.16; if it works with 1.15, that's purely by accident. Likewise, for trunk ConfirmAccount you need trunk MediaWiki.