https://bugzilla.wikimedia.org/show_bug.cgi?id=36179
Web browser: ---
Bug #: 36179
Summary: rebuildall.php invalid input syntax for integer:
"NULL" at character 149
Product: MediaWiki
Version: 1.18.2
Platform: HP
OS/Version: Linux
Status: UNCONFIRMED
Severity: normal
Priority: Unprioritized
Component: Maintenance scripts
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
Classification: Unclassified
Mobile Platform: ---
Product Version
MediaWiki 1.18.2
PHP 5.3.8 (apache2handler)
PostgreSQL 9.0.4
When I run the rebuildall.php I am getting this error
Error: 1 ERROR: invalid input syntax for integer: "NULL" at character 149
Here is the stack trace
** 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" at character 149 in
/usr/local/mediawiki/includes/db/DatabasePostgres.php on line 253
PHP Stack trace:
PHP 1. {main}() /usr/local/mediawiki/maintenance/rebuildall.php:0
PHP 2. require_once() /usr/local/mediawiki/maintenance/rebuildall.php:55
PHP 3. RebuildAll->execute()
/usr/local/mediawiki/maintenance/doMaintenance.php:105
PHP 4. RebuildRecentchanges->execute()
/usr/local/mediawiki/maintenance/rebuildall.php:43
PHP 5. RebuildRecentchanges->rebuildRecentChangesTablePass2()
/usr/local/mediawiki/maintenance/rebuildrecentchanges.php:35
PHP 6. DatabaseBase->update()
/usr/local/mediawiki/maintenance/rebuildrecentchanges.php:148
PHP 7. DatabaseBase->query()
/usr/local/mediawiki/includes/db/Database.php:1669
PHP 8. DatabasePostgres->doQuery()
/usr/local/mediawiki/includes/db/Database.php:802
PHP 9. pg_query() /usr/local/mediawiki/includes/db/DatabasePostgres.php: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 = '27' WHERE rc_cur_id = '21' AND
rc_this_oldid = '150'
Function: RebuildRecentchanges::rebuildRecentChangesTablePass2
Error: 1 ERROR: invalid input syntax for integer: "NULL" at character 149
I have run update.php and that seems to run fine without throwing any errors.
--
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
