Project

General

Profile

Redmine 3.0 problem with MSSQL 2008

Added by Alexey Markin almost 10 years ago

Hello.
I'm trying to install Redmine 3.0 on Server 2003. Storage I'm going to use MSSQL 2008 R2.

Ruby: 2.0.0-p643
Rails: 4.2

When I run command:

rake db:migrate

I see:
== 62 InsertBuiltinRoles: migrating ===========================================
rake aborted!
StandardError: An error has occurred, this and all later migrations canceled:

TinyTds::Error: Incorrect syntax near 'OFFSET'.: EXEC sp_executesql N'SELECT  1
AS one FROM [roles] WHERE [roles].[name] = N''Non member'' COLLATE Latin1_Genera
l_CS_AS_WS   ORDER BY [roles].[id] ASC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY'C:/I
netpub/redmine-3.0.0/db/migrate/062_insert_builtin_roles.rb:6:in `up'
C:in `migrate'
Tasks: TOP => db:migrate
(See full trace by running task with --trace)

What could be the problem ?

P.S.: sorry for my english. I used google translate.


Replies (2)

RE: Redmine 3.0 problem with MSSQL 2008 - Added by Alexey Markin almost 10 years ago

Thank you for your answer.

Apparently, further efforts are useless.

    (1-2/2)