Project

General

Profile

Forums » Help »

Redmine 3.0 problem with MSSQL 2008

Added by Alexey Markin about 9 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 about 9 years ago

Thank you for your answer.

Apparently, further efforts are useless.

    (1-2/2)