Author: mail

Description:
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_...

Version: 1.18.x
Severity: normal
OS: Linux