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
Updated by Daniel Felix over 11 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.
Updated by Christian Zagrodnick over 11 years ago
This was fixed with a new version. Close please.
Updated by Daniel Felix over 11 years ago
- Status changed from Needs feedback to Closed
- Resolution set to Fixed
Thanks for the quick feedback! Closed.
Updated by John Grubb over 10 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
Actions