Defect #10045
Postgresl: Bulk edit -> PGError: ERROR: invalid input syntax for integer
Status: | Closed | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | - | % Done: | 0% | |
Category: | Database | |||
Target version: | - | |||
Resolution: | Fixed | Affected version: | 1.3.0 |
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
History
#1
Updated by Etienne Massip almost 9 years ago
Try with no plugin installed?
#2
Updated by Daniel Felix about 8 years ago
- Status changed from New to Needs feedback
Any feedback on this? Does anyone else encounter this bug?
@ author: Any news after trying it without your plugins or with a newer release of redmine?
If there's no feedback on this issue, I'm closing this.
#3
Updated by Christian Zagrodnick about 8 years ago
This was fixed with a new version. Close please.
#4
Updated by Daniel Felix about 8 years ago
- Status changed from Needs feedback to Closed
- Resolution set to Fixed
Thanks for the quick feedback! Closed.
#5
Updated by John Grubb about 7 years ago
I just migrated to Postgres a couple days ago and bumped into this error this morning. Same issue, the query string is being repeated.
Environment: Redmine version 2.4.3.stable Ruby version 2.1.1-p76 (2014-02-24) [x86_64-linux] Rails version 3.2.16 Environment production Database adapter PostgreSQL SCM: Subversion 1.6.17 Git 1.7.9.5 Filesystem Redmine plugins: issuefy 0.1.7 redmine_backlogs v1.0.6 redmine_extended_watchers 0.0.2 redmine_stealth 0.6.0 sidebar_hide 0.0.4