Last modified: 2010-05-15 15:54:54 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.
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
Error: 1 ERROR: invalid input syntax for integer: "NULL"
#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()
Updating to a newer Version from svn fixed the error... Sorry for the inconvenience.