Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
I would like to develop a site with Umbraco.
I opened a project and created the project by adding Umbraco Cms Dll. Everything was going well. I have published my blog and wanted to publish the article named "My Blog Post".
Note: There is no version update I installed directly 8.2
Received an error from the server
An error occured
Invalid column name 'Id'. Invalid column name 'id'.
System.Data.SqlClient.SqlException: Invalid column name 'Id'. Invalid column name 'id'.
Sql kullanıcım sa and this user Dbowner
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
I shared a screenshot.
I've detected the problem, but I can't find the solution. The mapping in the npoco system does not work.
For me, the problem was the table [UFUserFormSecurity] was missing the ID column.
This was the correct schema:
CREATE TABLE [dbo].[UFUserFormSecurity] (
[Id] [int] IDENTITY(1,1) NOT NULL,
[User] nvarchar NOT NULL,
[Form] [uniqueidentifier] NOT NULL,
[HasAccess] [bit] NOT NULL,
[AllowInEditor] [bit] NOT NULL,
[SecurityType] [int] NOT NULL,
CONSTRAINT [Id] PRIMARY KEY CLUSTERED
)WITH (PADINDEX = OFF, STATISTICSNORECOMPUTE = OFF, IGNOREDUPKEY = OFF, ALLOWROWLOCKS = ON, ALLOWPAGELOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted