Last modified: 2010-05-15 15:54:54 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 T16372, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 14372 - DB connection error on running maintenance script "rebuildall.php"
DB connection error on running maintenance script "rebuildall.php"
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.12.x
All Linux
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  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: ---


Attachments

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/david.theparticulars.org/htdocs/w/includes/DatabasePostgres.php 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
Function: 
Error: 1 ERROR:  invalid input syntax for integer: "NULL"

Backtrace:
#0 /home/david/www/david.theparticulars.org/htdocs/w/includes/Database.php(799): DatabasePostgres->reportQueryError('ERROR:  invalid...', 1, 'UPDATE recentch...', '', false)
#1 /home/david/www/david.theparticulars.org/htdocs/w/maintenance/rebuildrecentchanges.inc(98): Database->query('UPDATE recentch...')
#2 /home/david/www/david.theparticulars.org/htdocs/w/maintenance/rebuildrecentchanges.inc(12): rebuildRecentChangesTablePass2()
#3 /home/david/www/david.theparticulars.org/htdocs/w/maintenance/rebuildall.php(28): 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.


Navigation
Links