Defect #935

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

Added by Marc Horowitz almost 4 years ago. Updated almost 4 years ago.

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

0%
Category:Issues
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 Jean-Philippe Lang almost 4 years ago

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

History

#1
Updated by Jean-Philippe Lang almost 4 years ago

  • Category set to Issues
  • 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