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

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
Subversion 1.8.4
Git 1.8.3
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.