Defect #30285
Microsoft SQL server support is broken
| Status: | New | Start date: | ||
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | - | % Done: | 0% | |
| Category: | Database | |||
| Target version: | Candidate for next minor release | |||
| Resolution: | Affected version: |
Description
Redmine 4.0.0 does not work with Microsoft SQL Server.
One of the causes is that a dependent library activerecord-sqlserver-adapter does not support Rails 5.2 yet.
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/issues/636
Related issues
History
#1
Updated by Go MAEDA 5 months ago
- Related to Defect #30284: Internal Server Error When Deleting a User added
#2
Updated by Go MAEDA 5 months ago
- Related to Defect #30211: Crash with the message "undefined method `alias_method_chain'" when connecting to Microsoft SQL Server added
#3
Updated by Go MAEDA 5 months ago
- Related to Defect #30210: Application crash when deleting an issue from issue list with SQLServer added
#4
Updated by Go MAEDA 5 months ago
- Related to Feature #23630: Migrate to Rails 5.2 added
#6
Updated by Jean-Philippe Lang 4 months ago
- Target version changed from 4.0.1 to 4.0.2
#7
Updated by Go MAEDA 3 months ago
activerecord-sqlserver-adapter 5.2.0.rc1 has been released on February 12.
#8
Updated by Jean-Philippe Lang 3 months ago
- Target version changed from 4.0.2 to Candidate for next minor release
Waiting for final release of activerecord-sqlserver-adapter 5.2.0
#9
Updated by Marius BALTEANU 3 months ago
- Related to Defect #28506: Error Setup Redmine with Win10 added
#10
Updated by Marius BALTEANU 3 months ago
- Related to deleted (Defect #28506: Error Setup Redmine with Win10)
#11
Updated by Marius BALTEANU 3 months ago
- Related to Defect #28506: Error Setup Redmine with Win10 added
#12
Updated by Go MAEDA 2 months ago
activerecord-sqlserver-adapter 5.2.0 has been released on March 19.
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/blob/master/CHANGELOG.md#v520
Can anyone test if Redmine 4.0 works with MS SQL Server? Please note that you have to run bundle update to install the latest activerecord-sqlserver-adapter gem.
#13
Updated by sebastián scarano 2 months ago
yeap, here's the release, it would be great if redmine latest version could be confirmed to work ok with sql server...
and update the note at http://www.redmine.org/projects/redmine/wiki/RedmineInstall#Supported-database-back-ends
Redmine 4.0 does not support SQL Server as of December 2018 because a dependent library activerecord-sqlserver-adapter does not support Rails 5.2 yet.
#14
Updated by Pavel Rosický 2 months ago
I tested it on SQL Server 2017 with these gems
activerecord-sqlserver-adapter (5.2.0)
tiny_tds (2.1.2-x64-mingw32)
it passes all tests, but unfortunatelly there's a problem with migrations due to this bug
https://github.com/rails-sqlserver/activerecord-sqlserver-adapter/pull/691
TinyTds::Error: The object 'DF_projects_description' is dependent on column 'description'. 087_change_projects_description_to_text.rb:5:in `up'
there might be an option to add a workaround in redmine, but it won't be pretty, so I would prefer to fix the problem in activerecord-sqlserver-adapter.
#15
Updated by John Bolthouse 28 days ago
Is there any progress on this? I would definitely like to upvote this as I have clients on Sql Server. I would also be happy to test potential solutions in our dev environments.
#16
Updated by Pavel Rosický 28 days ago
sorry, no feedback from activerecord-sqlserver-adapter's maintainers yet
but you can test my (unofficial) patch by changing the Gemfile
when /sqlserver/
gem "tiny_tds", "2.1.2", :platforms => [:mri, :mingw, :x64_mingw]
gem "activerecord-sqlserver-adapter", :git => 'https://github.com/ahorek/activerecord-sqlserver-adapter.git', :branch => 'constrains_bug', :platforms => [:mri, :mingw, :x64_mingw]
on my environment it passes all activerecord-sqlserver-adapter's tests and redmine's tests. Let us know if it works for you.