Page MenuHomePhabricator

Special:Ancientpages fails on PostgreSQL
Closed, ResolvedPublic

Description

Warning: pg_query() [function.pg-query]: Query failed: ERROR: function unix_timestamp(timestamp without time zone) 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: SELECT 'Ancientpages' as type, cur_namespace as namespace, cur_title as title,
UNIX_TIMESTAMP(cur_timestamp) as value FROM cur WHERE cur_namespace=0 AND cur_is_redirect=0 ORDER BY value LIMIT 50
OFFSET 0 Function: AncientPagesPage::doQuery Error: 1 ERROR: function unix_timestamp(timestamp without time zone) 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 366 calls wfDebugDieBacktrace()
  • Database.php line 295 calls DatabasePostgreSQL::reportQueryError()
  • QueryPage.php line 158 calls DatabasePostgreSQL::query()
  • SpecialAncientpages.php line 59 calls AncientPagesPage::doQuery()
  • SpecialPage.php line 257 calls wfSpecialAncientpages()
  • SpecialPage.php line 172 calls SpecialPage::execute()
  • index.php line 93 calls SpecialPage::executePath()

Version: 1.4.x
Severity: normal

Details

Reference
bz386

Related Objects

View Standalone Graph
This task is connected to more than 200 other tasks. Only direct parents and subtasks are shown here. Use View Standalone Graph to show more of the graph.
StatusSubtypeAssignedTask
InvalidNone
ResolvedNone

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 6:48 PM
bzimport set Reference to bz386.
bzimport added a subscriber: Unknown Object (MLST).
Jdforrester-WMF subscribed.

Migrating from the old tracking task to a tag for PostgreSQL-related tasks.