This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.
I am new in PHP and Octobercms,
I install October cms with SQL server everything is fine but when I click setting /administrators this error has happened
SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot find either column "dbo" or the user-defined function or aggregate "dbo.GROUP_CONCAT_D", or the name is ambiguous. (SQL: select top 20 [backend_users].*, (select dbo.GROUP_CONCAT_D(name, ', ') from [backend_user_groups] inner join [backend_users_groups] on [backend_user_groups].[id] = [backend_users_groups].[user_group_id] where [backend_users].[id] = [backend_users_groups].[user_id]) as [groups], (select name from [backend_user_roles] where [backend_users].[role_id] = [backend_user_roles].[id]) as [role] from [backend_users] order by [login] desc)
how can I fix this error?
and when I try to install User plugin this error happened: Update failed "SQLSTATE[42S01]: [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]There is already an object named 'rainlab_user_mail_blockers' in the database. (SQL: create table "rainlab_user_mail_blockers" ("id" int identity primary key not null, "email" nvarchar(191) null, "template" nvarchar(191) null, "user_id" int null, "created_at" datetime null, "updated_at" datetime null))" on line 664 of C:\xampp\htdocs\crm\vendor\laravel\framework\src\Illuminate\Database\Connection.php
please help me
The first issue should be fixed in v2.0 of October CMS
The second issue would require some investigation, it seems like the tables already exist and the plugin is trying to install twice. So it indicates something is corrupt
1-2 of 2