https://bugzilla.wikimedia.org/show_bug.cgi?id=31648
Web browser: ---
Bug #: 31648
Summary: Maintenance script rebuildall.php fails for
postgresql.
Product: MediaWiki
Version: 1.17.0
Platform: All
OS/Version: All
Status: NEW
Severity: normal
Priority: Unprioritized
Component: Database
AssignedTo: wikibugs-l@lists.wikimedia.org
ReportedBy: mich...@profarius.com
Classification: Unclassified
root@wiki:/var/www/mediawiki/maintenance# php rebuildall.php
** Rebuilding recentchanges table:
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/mediawiki/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 = '4956' WHERE rc_cur_id = '8' AND
rc_this_oldid = '7084'"
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_...
^"
root@wiki:/var/www/mediawiki/maintenance#
--
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
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
