Last modified: 2012-08-14 11:27:35 UTC
Imported a backup from another 1.18 install then run the rebuildrecentchanges.php. getting a error to do with the NULL value. [root@networkmanager maintenance]# php importDump.php /fullbackup.dmp Done! You might want to run rebuildrecentchanges.php to regenerate RecentChanges [root@networkmanager maintenance]# php rebuildrecentchanges.php Loading from page and revision tables... $wgRCMaxAge=7862400 (91 days) Updating links and size differences... PHP Warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: "NULL" LINE 1: ...did = '0',rc_new = '1',rc_type = '1',rc_old_len = 'NULL',rc_... ^ in /var/www/wiki/includes/db/DatabasePostgres.php on line 253 Warning: pg_query(): Query failed: ERROR: invalid input syntax for integer: "NULL" LINE 1: ...did = '0',rc_new = '1',rc_type = '1',rc_old_len = 'NULL',rc_... ^ in /var/www/wiki/includes/db/DatabasePostgres.php on line 253 A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: http://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: UPDATE "recentchanges" SET rc_last_oldid = '0',rc_new = '1',rc_type = '1',rc_old_len = 'NULL',rc_new_len = '423' WHERE rc_cur_id = '1' AND rc_this_oldid = '15' Function: RebuildRecentchanges::rebuildRecentChangesTablePass2 Error: 1 ERROR: invalid input syntax for integer: "NULL" LINE 1: ...did = '0',rc_new = '1',rc_type = '1',rc_old_len = 'NULL',rc_...
Created attachment 9635 [details] Rebuild
Same as bug 31007? *** This bug has been marked as a duplicate of bug 31007 ***