https://bugzilla.wikimedia.org/show_bug.cgi?id=31007
Web browser: ---
Bug #: 31007
Summary: rebuildrecentchanges.php fails for Postgresql with
strings for integers
Product: MediaWiki
Version: 1.17.0
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Export/Import
AssignedTo: [email protected]
ReportedBy: [email protected]
Classification: Unclassified
After importing XML dump from a MySQL into empty Postgresql 8.4.8 backend
using rebuildrecentchanges.php fails with:
php maintenance/rebuildrecentchanges.php
Loading from page and revision tables...
$wgRCMaxAge=7862400 (91 days)
Updating links and size differences...
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
/data/services/wiki/mediawiki-1.17.0/includes/db/DatabasePostgres.php on line
237
A database query syntax error has occurred.
The last attempted database query was:
"UPDATE recentchanges SET rc_last_oldid = '0',rc_new = '1',rc_type =
'1',rc_old_len = 'NULL',rc_new_len = '7008' WHERE rc_cur_id = '5' AND
rc_this_oldid = '6'"
from within function "RebuildRecentchanges::rebuildRecentChangesTablePass2".
Database returned 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
