Last modified: 2010-05-15 15:54:54 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 14372 - DB connection error on running maintenance script "rebuildall.php"
DB connection error on running maintenance script "rebuildall.php"
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
All Linux
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
Depends on:
  Show dependency treegraph
Reported: 2008-06-01 21:18 UTC by David Nies
Modified: 2010-05-15 15:54 UTC (History)
0 users

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


Description David Nies 2008-06-01 21:18:23 UTC
Whenever I try to run the "rebuildall.php" (maintenance script in the maintenance/ folder), I get the error:

"DB connection error: Access denied for user '(...)'@'localhost' (using password: YES) (localhost)" (The "(...)" has been edited by me)

I am using exactly the same username and password in the AdminSettings.php as in the LocalSettings.php. This user has full rights on the database. Also, I can log in with this user on the shell, so it is not a problem of the database or my settings, I think.

I am using: MediaWiki 1.12.0, PHP 5.2.0 as lib_apache and PostgreSQL 8.1.11.
Comment 1 David Nies 2008-06-01 22:29:28 UTC
Additional Comment:

I downloaded a new version of "maintenance/rebuildall.php" from the svn-repository, revision #31958 - the next version of this file after the one I have (MediaWiki 1.12). In the comment to this revision it says: "Fix for bug 13251, allows some rebuld scripts to work with Postgres.", and bug #13251 seemed to be something similar to my problem. Now I get the following error output ($wgShowExceptionDetails = true):

sudo php rebuildall.php 

** Rebuilding recentchanges table:
Loading from page and revision tables...
Updating links and size differences...

Warning: pg_query(): Query failed: ERROR:  invalid input syntax for integer: "NULL" in /home/david/www/ on line 553
A database error has occurred
Query: UPDATE recentchanges SET rc_last_oldid=0,rc_new=1,rc_type=1,rc_old_len='NULL',rc_new_len='86' WHERE rc_cur_id=39 AND rc_this_oldid=169
Error: 1 ERROR:  invalid input syntax for integer: "NULL"

#0 /home/david/www/ DatabasePostgres->reportQueryError('ERROR:  invalid...', 1, 'UPDATE recentch...', '', false)
#1 /home/david/www/ Database->query('UPDATE recentch...')
#2 /home/david/www/ rebuildRecentChangesTablePass2()
#3 /home/david/www/ rebuildRecentChangesTable()
#4 {main}
Comment 2 David Nies 2008-06-03 21:36:43 UTC
Updating to a newer Version from svn fixed the error... Sorry for the inconvenience.

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