Defect #29819
open3.4.6, SQLSERVER 2014. Incorrect syntax near 'OFFSET'
0%
Description
I'm trying to setup a new Redmine instance of version 3.4.6 using SQLSERVER 2014. When I run rake db:migrate I get the following error.
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_General_CS_AS_WS ORDER BY [roles].[id] ASC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY'
C:/Sites/redmine346/db/migrate/062_insert_builtin_roles.rb:6:in `up'
C:in `migrate'
Caused by:
ActiveRecord::StatementInvalid: TinyTds::Error: Incorrect syntax near 'OFFSET'.: EXEC sp_executesql N'SELECT 1 AS one FROM [roles] WHERE [roles].[name] = N''Non member'' COLLATE Latin1_General_CS_AS_WS ORDER BY [roles].[id] ASC OFFSET 0 ROWS FETCH NEXT 1 ROWS ONLY'
C:/Sites/redmine346/db/migrate/062_insert_builtin_roles.rb:6:in `up'
C:in `migrate'
Caused by:
TinyTds::Error: Incorrect syntax near 'OFFSET'.
C:/Sites/redmine346/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)
Any suggestions would be greatly appreciated