This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

birnaghdejavan31147
birnaghdejavan31147

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

daftspunky
daftspunky

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

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.