https://bugzilla.wikimedia.org/show_bug.cgi?id=32861

       Web browser: ---
             Bug #: 32861
           Summary: php rebuildrecentchanges.php postgres
           Product: MediaWiki
           Version: 1.18
          Platform: All
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: Unprioritized
         Component: Database
        AssignedTo: [email protected]
        ReportedBy: [email protected]
    Classification: Unclassified


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

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to