Project

General

Profile

Actions

Defect #10045

closed

Postgresl: Bulk edit -> PGError: ERROR: invalid input syntax for integer

Added by Christian Zagrodnick almost 13 years ago. Updated over 10 years ago.

Status:
Closed
Priority:
Normal
Assignee:
-
Category:
Database
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:
Fixed
Affected version:

Description

After the bulk edit I get an 500 internal server error:

Processing IssuesController#index (for 195.62.106.104 at 2012-01-23 16:24:51) [GET]
  Parameters: {"v"=>{"fixed_version_id"=>["437?c[]=project", "437"]}, "group_by"=>"", "op"=>{"fixed_version_id"=>"=", "status_id"=>"o"}, "project_id"=>"zeit-cms", "c"=>[" 
project", "tracker", "status", "priority", "subject", "assigned_to", "updated_on", "category", "fixed_version", "tracker", "status", "priority", "subject", "assigned_to",
 "updated_on", "category", "fixed_version"], "set_filter"=>"1", "action"=>"index", "f"=>["status_id", "fixed_version_id", "", "status_id", "fixed_version_id", ""], "contr
oller"=>"issues"}
Query::StatementInvalid: PGError: ERROR:  invalid input syntax for integer: "437?c[]=project" 
LINE 1: ...es".status_id WHERE ((issues.fixed_version_id IN ('437?c[]=p...
                                                             ^
: SELECT count(DISTINCT "issues".id) AS count_all FROM "issues"  LEFT OUTER JOIN "projects" ON "projects".id = "issues".project_id  LEFT OUTER JOIN "issue_statuses" ON "issue_statuses".id = "issues".status_id WHERE ((issues.fixed_version_id IN ('437?c[]=project','437')) AND (issue_statuses.is_closed='f') AND projects.id IN (33,47,46,79,115,88,87,86,91,96,89,116,90,95,98,118,109,85,93,92)) AND (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='issue_tracking')) 

Interestingly the URL contains the parameters twice:

https://projects.gocept.com/projects/zeit-cms/issues?c[]=project&c[]=tracker&c[]=status&c[]=priority&c[]=subject&c[]=assigned_to&c[]=updated_on&c[]=category&c[]=fixed_version&f[]=status_id&f[]=fixed_version_id&f[]=&group_by=&op[fixed_version_id]==&op[status_id]=o&set_filter=1&v[fixed_version_id][]=437?c[]=project&c[]=tracker&c[]=status&c[]=priority&c[]=subject&c[]=assigned_to&c[]=updated_on&c[]=category&c[]=fixed_version&f[]=status_id&f[]=fixed_version_id&f[]=&group_by=&op[fixed_version_id]==&op[status_id]=o&set_filter=1&v[fixed_version_id][]=437

About your application's environment
Ruby version              1.8.7 (i686-linux)
RubyGems version          1.3.7
Rack version              1.1.1
Rails version             2.3.14
Active Record version     2.3.14
Active Resource version   2.3.14
Action Mailer version     2.3.14
Active Support version    2.3.14
Application root          /srv/redmine/redmine
Environment               production
Database adapter          postgresql
Database schema version   20110902000000

About your Redmine plugins
Redmine Time Column plugin   0.0.1
Redmine Quips plugin         0.0.2
Actions

Also available in: Atom PDF