Public bug reported:
Export issues using the CSV link generate an http 500 response errore
page with apparently no useful informations (see error.jpg) instead
dowloading a csv file with selected issues.
Changing log level to debug using
/usr/share/redmine/config/additional_environment.rb config file resulted
in this error after submit to the csv export window.
==========================================
Started GET
"/issues.csv?utf8=%E2%9C%93&set_filter=1&f%5B%5D=status_id&op%5Bstatus_id%5D=o&v%5Bstatus_id%5D%5B%5D=&c%5B%5D=id&c%5B%5D=project&c%5B%5D=tracker&c%5B%5D=status&c%5B%5D=priority&c%5B%5D=subject&c%5B%5D=assigned_to&c%5B%5D=updated_on&sort=id%3Adesc&c%5B%5D=&encoding=ISO-8859-1"
for 100.100.100.100 at 2021-03-30 17:49:40 +0200
Processing by IssuesController#index as CSV
Parameters: {"utf8"=>"✓", "set_filter"=>"1", "f"=>["status_id"],
"op"=>{"status_id"=>"o"}, "v"=>{"status_id"=>[""]}, "c"=>["id", "project",
"tracker", "status", "priority", "subject", "assigned_to", "updated_on", ""],
"sort"=>"id:desc", "encoding"=>"ISO-8859-1"}
Token Update All (3.3ms) UPDATE `tokens` SET `tokens`.`updated_on` =
'2021-03-30 17:49:40' WHERE `tokens`.`user_id` = 5 AND `tokens`.`value` =
'61f0c68ed5409b8851e2e931d4618f0fedb886da' AND `tokens`.`action` = 'session'
(0.1ms) SELECT MAX(`settings`.`updated_on`) FROM `settings`
User Load (0.2ms) SELECT `users`.* FROM `users` WHERE `users`.`type` IN
('User', 'AnonymousUser') AND `users`.`status` = 1 AND `users`.`id` = 5 LIMIT 1
Current user: redmineadmin (id=5)
Tracker Load (0.1ms) SELECT DISTINCT `trackers`.* FROM `trackers` INNER JOIN
`projects_trackers` ON `projects_trackers`.`tracker_id` = `trackers`.`id` INNER
JOIN `projects` ON `projects`.`id` = `projects_trackers`.`project_id` WHERE
(projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE
em.project_id = projects.id AND em.name='issue_tracking')) ORDER BY
`trackers`.`position` ASC
IssuePriority Load (0.2ms) SELECT `enumerations`.* FROM `enumerations` WHERE
`enumerations`.`type` IN ('IssuePriority') ORDER BY `enumerations`.`position`
ASC
IssueCustomField Load (0.1ms) SELECT `custom_fields`.* FROM `custom_fields`
WHERE `custom_fields`.`type` IN ('IssueCustomField') AND
`custom_fields`.`is_filter` = TRUE ORDER BY `custom_fields`.`position` ASC
CustomField Load (0.1ms) SELECT `custom_fields`.* FROM `custom_fields` WHERE
`custom_fields`.`is_filter` = TRUE
IssueCustomField Load (0.2ms) SELECT `custom_fields`.* FROM `custom_fields`
WHERE `custom_fields`.`type` IN ('IssueCustomField')
SQL (0.1ms) SELECT `issues`.`id` AS t0_r0, `issues`.`tracker_id` AS t0_r1,
`issues`.`project_id` AS t0_r2, `issues`.`subject` AS t0_r3,
`issues`.`description` AS t0_r4, `issues`.`due_date` AS t0_r5,
`issues`.`category_id` AS t0_r6, `issues`.`status_id` AS t0_r7,
`issues`.`assigned_to_id` AS t0_r8, `issues`.`priority_id` AS t0_r9,
`issues`.`fixed_version_id` AS t0_r10, `issues`.`author_id` AS t0_r11,
`issues`.`lock_version` AS t0_r12, `issues`.`created_on` AS t0_r13,
`issues`.`updated_on` AS t0_r14, `issues`.`start_date` AS t0_r15,
`issues`.`done_ratio` AS t0_r16, `issues`.`estimated_hours` AS t0_r17,
`issues`.`parent_id` AS t0_r18, `issues`.`root_id` AS t0_r19, `issues`.`lft` AS
t0_r20, `issues`.`rgt` AS t0_r21, `issues`.`is_private` AS t0_r22,
`issues`.`closed_on` AS t0_r23, `issue_statuses`.`id` AS t1_r0,
`issue_statuses`.`name` AS t1_r1, `issue_statuses`.`is_closed` AS t1_r2,
`issue_statuses`.`position` AS t1_r3, `issue_statuses`.`default_done_ratio` AS
t1_r4, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1,
`projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3,
`projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5,
`projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7,
`projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9,
`projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11,
`projects`.`inherit_members` AS t2_r12, `projects`.`default_version_id` AS
t2_r13, `projects`.`default_assigned_to_id` AS t2_r14 FROM `issues` INNER JOIN
`projects` ON `projects`.`id` = `issues`.`project_id` INNER JOIN
`issue_statuses` ON `issue_statuses`.`id` = `issues`.`status_id` WHERE
(projects.status <> 9 AND EXISTS (SELECT 1 AS one FROM enabled_modules em WHERE
em.project_id = projects.id AND em.name='issue_tracking')) AND
((issues.status_id IN (SELECT id FROM issue_statuses WHERE is_closed=FALSE)))
ORDER BY issues.id DESC LIMIT 500
IssuePriority Load (0.1ms) SELECT `enumerations`.* FROM `enumerations` WHERE
`enumerations`.`type` IN ('IssuePriority') AND `enumerations`.`id` IN (2, 4)
ORDER BY `enumerations`.`position` ASC
Tracker Load (0.1ms) SELECT `trackers`.* FROM `trackers` WHERE
`trackers`.`id` IN (3, 4)
Principal Load (0.1ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 9
UserPreference Load (0.1ms) SELECT `user_preferences`.* FROM
`user_preferences` WHERE `user_preferences`.`user_id` = 5 LIMIT 1
Completed 500 Internal Server Error in 22ms (ActiveRecord: 4.9ms)
FrozenError (can't modify frozen String: ""):
lib/redmine/codeset_util.rb:59:in `force_encoding'
lib/redmine/codeset_util.rb:59:in `from_utf8'
lib/redmine/export/csv.rb:52:in `block in <<'
lib/redmine/export/csv.rb:49:in `map'
lib/redmine/export/csv.rb:49:in `<<'
app/helpers/queries_helper.rb:283:in `block (2 levels) in query_to_csv'
app/helpers/queries_helper.rb:282:in `each'
app/helpers/queries_helper.rb:282:in `block in query_to_csv'
lib/redmine/export/csv.rb:44:in `generate'
lib/redmine/export/csv.rb:26:in `generate'
app/helpers/queries_helper.rb:278:in `query_to_csv'
app/controllers/issues_controller.rb:67:in `block (2 levels) in index'
app/controllers/issues_controller.rb:47:in `index'
lib/redmine/sudo_mode.rb:63:in `sudo_mode'
==========================================
Ubuntu version
Description: Ubuntu 20.04.2 LTS
Release: 20.04
Redmine version
redmine:
Installed: 4.0.6-2
Candidate: 4.0.6-2
Version table:
*** 4.0.6-2 500
500 http://eu-north-1.ec2.archive.ubuntu.com/ubuntu focal/universe
amd64 Packages
Ruby version
ruby:
Installed: 1:2.7+1
Candidate: 1:2.7+1
Version table:
*** 1:2.7+1 500
500 http://eu-north-1.ec2.archive.ubuntu.com/ubuntu focal/main amd64
Packages
100 /var/lib/dpkg/status
** Affects: redmine (Ubuntu)
Importance: Undecided
Status: New
** Tags: 20.04 redmine
** Attachment added: "error.jpg"
https://bugs.launchpad.net/bugs/1921936/+attachment/5482430/+files/error.jpg
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/1921936
Title:
redmine export error
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/redmine/+bug/1921936/+subscriptions
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
