Defect #30285

Microsoft SQL server support is broken

Added by Go MAEDA 3 months ago. Updated 4 days ago.

Status:NewStart date:
Priority:NormalDue 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

Related to Redmine - Defect #30284: Internal Server Error When Deleting a User New
Related to Redmine - Defect #30211: Crash with the message "undefined method `alias_method_ch... Confirmed
Related to Redmine - Defect #30210: Application crash when deleting an issue from issue list ... New
Related to Redmine - Feature #23630: Migrate to Rails 5.2 Closed
Related to Redmine - Defect #28506: Error Setup Redmine with Win10 Reopened

History

#1 Updated by Go MAEDA 3 months ago

  • Related to Defect #30284: Internal Server Error When Deleting a User added

#2 Updated by Go MAEDA 3 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 3 months ago

  • Related to Defect #30210: Application crash when deleting an issue from issue list with SQLServer added

#4 Updated by Go MAEDA 3 months ago

#5 Updated by Go MAEDA 3 months ago

  • Subject changed from Microsoft SQL server is broken to Microsoft SQL server support is broken

#6 Updated by Jean-Philippe Lang 2 months ago

  • Target version changed from 4.0.1 to 4.0.2

#7 Updated by Go MAEDA about 1 month ago

activerecord-sqlserver-adapter 5.2.0.rc1 has been released on February 12.

#8 Updated by Jean-Philippe Lang about 1 month 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 19 days ago

#10 Updated by Marius BALTEANU 19 days ago

  • Related to deleted (Defect #28506: Error Setup Redmine with Win10)

#11 Updated by Marius BALTEANU 19 days ago

#12 Updated by Go MAEDA 5 days 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 5 days 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√Ĺ 4 days 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.

Also available in: Atom PDF