unable to view some closed issues

Added by Doug Scott over 8 years ago

I am using BitNami installed on a Windows Server 2012 x64

I have an odd issue. I have 10 projects, some have sub-projects. When I list Issues in a project, most projects will let me see all the issues, regardless of the status. Just as you would expect it to do. I have a couple of projects that will show me all issues, except 'Closed" issues. When I attempt to view a closed issue in those projects, I get the most helpful error message "Internal Error". I have many other projects that have no issue showing Closed issues.

Looking at the production log file, I can see this..

ActionView::Template::Error (Mysql2::Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',))' at line 1: SELECT `issues`.* FROM `issues` INNER JOIN `watchers` ON `watchers`.`watchable_id` = `issues`.`id` AND `watchers`.`watchable_type` = 'Issue' WHERE `issues`.`project_id` = 38 AND `issues`.`fixed_version_id` IN (14, 28) AND (watchers.user_id IN (6 , ,,))):

The information on my system is:

Redmine 2.4.1.stable
Default administrator account changed True
Attachments directory writable True
Plugin assets directory writable True
RMagick available (optional) True
ImageMagick convert available (optional) True

Environment:
Redmine version 2.4.1.stable
Ruby version 1.9.3-p231 (2012-05-25) [i386-mingw32]
Rails version 3.2.16
Environment production
Database adapter Mysql2
SCM:
Subversion 1.8.4
Git 1.8.3
Filesystem
Redmine plugins:
clipboard_image_paste 1.8
project_alias 0.1.0
project_section 0.0.1b
redmine_app__space 1.0.0
redmine_app_timesheets 1.3.5
redmine_better_gantt_chart 0.9.0
redmine_category_tree 0.0.4
redmine_dmsf 1.4.8 devel
redmine_issue_checklist 2.0.5
redmine_my_roadmaps 0.1.13_redmine2.3
redmine_release_notes 1.3.1
redmine_theme_changer 0.1.0
redmine_todos 2.0.5
redmine_watcher_groups 1.0.0
role_shift 0.1.0b
status_button 0.1.0

Thanks for any help you can offer me.