Skip to content

Incompatibility with Microsoft SQL (Express)

After successfully installing redhopper on redmine 3.4.3 I can configure the plugin and set the modules in projects. But when entering the kanbans tab I encounter an internal server error.

Find the log attached below:

  Rendered plugins/redhopper/app/views/kanbans/_kanban.html.haml (0.0ms)
  Rendered plugins/redhopper/app/views/kanbans/_kanban.html.haml (140.6ms)
  Rendered plugins/redhopper/app/views/kanbans/index.haml within layouts/base (296.9ms)
Completed 500 Internal Server Error in 516ms (ActiveRecord: 93.8ms)

ActionView::Template::Error (TinyTds::Error: 'LENGTH' is not a recognized built-in function name.: EXEC sp_executesql N'SELECT COUNT(*) FROM [journals] INNER JOIN [issues] ON [issues].[id] = [journals].[journalized_id] INNER JOIN [projects] ON [projects].[id] = [issues].[project_id] WHERE [journals].[journalized_id] = @0 AND [journals].[journalized_type] = @1 AND (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 ((journals.private_notes = 0 OR journals.user_id = 1 OR (projects.status <> 9))) AND (LENGTH(journals.notes) > 0)', N'@0 int, @1 nvarchar(30)', @0 = 105, @1 = N'Issue'):
    83: 										= textilizable(desc)
    84: 							- else
    85: 								%span.icon.icon-issue{title: t('.description')}
    86: 						- unless comments.empty?
    87: 							%span.icon.icon-comment{title: t('.notes_count')}= comments.count
    88: 						- unless issue.attachments.empty?
    89: 							%span.icon.icon-attachment{title: t('.attachments_count')}= issue.attachments.count
  plugins/redhopper/app/views/kanbans/_kanban.html.haml:86:in `_plugins_redhopper_app_views_kanbans__kanban_html_haml___828827270_67331088'
  plugins/redhopper/app/views/kanbans/index.haml:40:in `block in _plugins_redhopper_app_views_kanbans_index_haml___818735642_67748076'
  plugins/redhopper/app/views/kanbans/index.haml:25:in `each'
  plugins/redhopper/app/views/kanbans/index.haml:25:in `_plugins_redhopper_app_views_kanbans_index_haml___818735642_67748076'
  lib/redmine/sudo_mode.rb:63:in `sudo_mode'

After some googling I found that mssql does not have the built-in function 'LENGTH' but the same functionality with a function called 'LEN'.

Due to my very limited experience with the ruby on rails framework I am not able to sort this out myself but maybe there is just a trivial change of code necessary?

Frank