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.
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} ""
Updating to a newer Version from svn fixed the error... Sorry for the inconvenience.