Defect #935

when bulk editing, setting "Assigned to" to "nobody" causes an sql error

Added by Marc Horowitz 100 days ago. Updated 100 days ago.

Status:Closed Start:2008-03-26
Priority:Normal Due date:
Assigned to:- % Done:

0%
Category:Tickets
Target version:0.7
Affected version:

devel

 Resolution:

Fixed

Description

at least under postgres:

ActiveRecord::StatementInvalid (PGError: ERROR:  invalid input syntax for integer: "none" 
: SELECT * FROM users WHERE (users."id" = 'none')  LIMIT 1):

I've included a patch which fixes this problem, and as a bonus, allows setting the version to "none" as well, using a similar pattern to assigned_to.

none.diff (2.7 KB) Marc Horowitz, 2008-03-26 21:04

Associated revisions

Revision 1294
Added by jplang 100 days ago

Fixed: when bulk editing, setting "Assigned to" to "nobody" causes an sql error with Postgresql (#935).

History

2008-03-26 23:24 - Jean-Philippe Lang

  • Category set to Tickets
  • Status changed from New to Closed
  • Target version set to 0.7
  • Resolution set to Fixed

Thanks, patch applied in r1294 with the ability to set the category to 'none' as well.

Also available in: Atom PDF