Last modified: 2011-03-13 18:06:08 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T30008, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 28008 - php maintenance/update.php fails with "1146: Table 'lambdadb.ald_account_requests' doesn't exist (localhost)"
php maintenance/update.php fails with "1146: Table 'lambdadb.ald_account_requ...
Status: RESOLVED WONTFIX
Product: MediaWiki extensions
Classification: Unclassified
ConfirmAccount (Other open bugs)
unspecified
All Linux
: Lowest normal (vote)
: ---
Assigned To: Aaron Schulz
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2011-03-12 19:32 UTC by Adrian Aichner
Modified: 2011-03-13 18:06 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Adrian Aichner 2011-03-12 19:32:09 UTC
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 #
Comment 1 Adrian Aichner 2011-03-12 20:03:37 UTC
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
Comment 2 Max Semenik 2011-03-12 20:56:32 UTC
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.
Comment 3 Adrian Aichner 2011-03-12 22:15:02 UTC
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
Comment 4 Adrian Aichner 2011-03-13 09:58:38 UTC
(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
Comment 5 Roan Kattouw 2011-03-13 15:43:34 UTC
(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.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links