HI guys,

Just want to say thanks for a superb CMS, been looking forward to using a stable release for a good while.

However, I do have a small problem. There seems to be no support for SQL Server. While October installs with no problems, I am unable to access the user management screens due to certain mysql functions not supported on SQL Server. Namely group_concat and ifnull.

The errors I am getting are as follows:

Accessing the backend/users: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near 'separator'. (SQL: select top 20 [backend_users].*, (select group_concat(name separator ', ') from [backend_user_groups] inner join [backend_users_groups] on [backend_user_groups].[id] = [backend_users_groups].[user_group_id] where [backend_users_groups].[user_id] = [backend_users].[id]) as [groups] from [backend_users] order by [login] desc)

Accessing the Customise Back-end page: SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]'ifnull' is not a recognized built-in function name. (SQL: select * from [system_files] where (exists (select * from [deferred_bindings] where slave_id = system_files.id and [master_field] = logo and [master_type] = Backend\Models\BrandSetting and [session_key] = b1ehFavapHbNnM37pqTNNHQUK0RhY7mnJoNhPb0a and [is_bind] = 1)) and not exists (select * from [deferred_bindings] where slave_id = system_files.id and [master_field] = logo and [master_type] = Backend\Models\BrandSetting and [session_key] = b1ehFavapHbNnM37pqTNNHQUK0RhY7mnJoNhPb0a and [is_bind] = 0 and id > ifnull((select max(id) from deferred_bindings where slave_id = system_files.id and master_field = logo and master_type = Backend\Models\BrandSetting and session_key = b1ehFavapHbNnM37pqTNNHQUK0RhY7mnJoNhPb0a and is_bind = 1 ), 0)) order by [sort_order] asc)

I inspected the Dongle.php file while specifies the functions that need to be replaced depending on the database. There is no cases for SQL Server support in there. Was that just an oversight and will be this supported at some point? Any help on this would be greatly appreciated.

Thanks,

Emmanuel

You should probably open an issue on Github for this.