Page MenuHomePhabricator

IP block fails on PostgreSQL
Closed, ResolvedPublic

Description

Another timestamp type mismatch.

Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid input
syntax for type timestamp: "20040907015658" in
/var/www/html/gres/includes/DatabasePostgreSQL.php on line 96
A database error has occurred Query: INSERT INTO ipblocks
(ipb_address,ipb_user,ipb_by,ipb_reason,ipb_timestamp,ipb_auto,ipb_expiry)
VALUES ('10.0.0.87','0','1','for being a big
jerk','20040907015658','0','20040907070000') Function: Database::insertArray
Error: 1 ERROR: invalid input syntax for type timestamp: "20040907015658"

Backtrace:

  • DatabasePostgreSQL.php line 370 calls wfDebugDieBacktrace()
  • Database.php line 297 calls DatabasePostgreSQL::reportQueryError()
  • Database.php line 760 calls DatabasePostgreSQL::query()
  • Database.php line 714 calls DatabasePostgreSQL::insert()
  • DatabasePostgreSQL.php line 208 calls DatabasePostgreSQL::insertArray()
  • Block.php line 207 calls DatabasePostgreSQL::insertArray()
  • SpecialBlockip.php line 166 calls Block::insert()
  • SpecialBlockip.php line 23 calls IPBlockForm::doSubmit()
  • SpecialPage.php line 257 calls wfSpecialBlockip()
  • SpecialPage.php line 172 calls SpecialPage::execute()
  • index.php line 93 calls SpecialPage::executePath()

Version: 1.4.x
Severity: normal

Details

Reference
bz405

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:53 PM
bzimport set Reference to bz405.
bzimport added a subscriber: Unknown Object (MLST).
Jdforrester-WMF subscribed.

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