Page MenuHomePhabricator

Can't save pages with category links on PostgreSQL
Closed, ResolvedPublic

Description

When saving a page with a Category: link on a PostgreSQL-powered wiki, the save fails trying to touch the category page for
cache purging:

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input syntax for type timestamp: "20040906083948" in /
var/www/html/gres/includes/DatabasePostgreSQL.php on line 96
A database error has occurred Query: UPDATE cur SET cur_touched='20040906083948' WHERE cur_namespace='14' AND
cur_title='Cats' Function: Title::invalidateCache Error: 1 ERROR: invalid input syntax for type timestamp: "20040906083948"

Backtrace:

  • DatabasePostgreSQL.php line 366 calls wfDebugDieBacktrace()
  • Database.php line 297 calls DatabasePostgreSQL::reportQueryError()
  • Database.php line 777 calls DatabasePostgreSQL::query()
  • Database.php line 767 calls DatabasePostgreSQL::update()
  • Title.php line 652 calls DatabasePostgreSQL::updateArray()
  • LinksUpdate.php line 154 calls Title::invalidateCache()
  • index.php line 195 calls LinksUpdate::doUpdate()

Version: 1.4.x
Severity: major

Details

Reference
bz391

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 bz391.
bzimport added a subscriber: Unknown Object (MLST).

domas.mituzas wrote:

fixed in Title.php:1.108

Jdforrester-WMF subscribed.

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