Actions
Defect #10045
closedPostgresl: Bulk edit -> PGError: ERROR: invalid input syntax for integer
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:
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