Last modified: 2010-05-15 15:32:59 UTC

Wikimedia Bugzilla is closed!

Wikimedia has migrated from Bugzilla to Phabricator. Bug reports should be created and updated in Wikimedia Phabricator instead. Please create an account in Phabricator and add your Bugzilla email address to it.
Wikimedia Bugzilla is read-only. If you try to edit or create any bug report in Bugzilla you will be shown an intentional error message.
In order to access the Phabricator task corresponding to a Bugzilla report, just remove "static-" from its URL.
You could still run searches in Bugzilla or access your list of votes but bug reports will obviously not be up-to-date in Bugzilla.
Bug 407 - rebuildrecentchanges.php fails on PostgreSQL
rebuildrecentchanges.php fails on PostgreSQL
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
General/Unknown (Other open bugs)
1.4.x
All All
: Normal normal (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks: postgres
  Show dependency treegraph
 
Reported: 2004-09-07 02:22 UTC by Brion Vibber
Modified: 2010-05-15 15:32 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Brion Vibber 2004-09-07 02:22:49 UTC
]$ php rebuildrecentchanges.php
Loading from CUR table...
 
Warning: pg_query(): Query failed: ERROR:  function if(smallint, integer,
integer) does not exist
HINT:  No function matches the given name and argument types. You may need to
add explicit type casts. in /var/www/html/gres/includes/DatabasePostgreSQL.php
on line 96
A database error has occurred
Query: INSERT INTO recentchanges
(rc_timestamp,rc_cur_time,rc_user,rc_user_text,rc_namespace,rc_title,rc_comment,rc_minor,rc_bot,rc_new,rc_cur_id,rc_this_oldid,rc_last_oldid,rc_type)
SELECT
cur_timestamp,cur_timestamp,cur_user,cur_user_text,cur_namespace,cur_title,cur_comment,cur_minor_edit,0,cur_is_new,cur_id,0,0,IF(cur_is_new,1,0)
FROM cur
Function: rebuildRecentChangesTablePass1
Error: 1 ERROR:  function if(smallint, integer, integer) does not exist
HINT:  No function matches the given name and argument types. You may need to
add explicit type casts.
 
Backtrace:
DatabasePostgreSQL.php line 370 calls wfDebugDieBacktrace()
Database.php line 297 calls DatabasePostgreSQL::reportQueryError()
Database.php line 1034 calls DatabasePostgreSQL::query()
rebuildrecentchanges.inc line 38 calls DatabasePostgreSQL::insertSelect()
rebuildrecentchanges.php line 19 calls rebuildRecentChangesTablePass1()
Comment 1 Brion Vibber 2004-09-09 00:04:37 UTC
Modified Files:
	includes/Database.php includes/DatabasePostgreSQL.php 
	maintenance/rebuildrecentchanges.inc 
	maintenance/postgresql/pg_tables.sql
Log Message:
Add Database::conditional() function to build IF() or CASE statements 
depending on the RDBMS used. Allowed NULL in some RC fields on PostgreSQL.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links