My setup; connected to MSSQL server connection string for Umbraco 13 and database collation is set to Turkish_CI_AS.
When moving Document Type to a folder, "exec sp_executesql N'SELECT coalesce(max(sortOrder),0) FROM umbracoNode WHERE parentid = @0 AND nodeObjectType = @1',N'@0 int,@1 uniqueidentifier',@0=1060,@1='A2CB7800-F571-4787-9638-BC48539A0EFB'" sql statement works. While writing "parentid" in the query; column name in MSSQL server is "parentId". Therefore, "An error occurred Invalid column name 'parentid'." error is received.
When deleting Document Type "exec sp_executesql N'DELETE FROM [umbracoPropertyData] WHERE [propertytypeid] IN (SELECT [propertytypeid] FROM (SELECT DISTINCT umbracoPropertyData.propertytypeid FROM [umbracoPropertyData] INNER JOIN [cmsPropertyType] ON [umbracoPropertyData].[propertyTypeId] = [cmsProperty Type].[id] INNER JOIN [cmsContentType] ON [cmsContentType].[nodeId] = [cmsPropertyType].[contentTypeId] WHERE (([cmsContentType].[nodeId] = @0))) x)',N'@0 int',@0=1095" sql statement is running. While writing "propertytypeid" in the query; The column name in MSSQL server is "propertyTypeId". Therefore, the error "An error occurred
Invalid column name 'propertytypeid'. Invalid column name 'propertytypeid'." is received.
How can I fix the issue? Or could someone can make equalize column names in code???
This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/114785-an-error-occurred-invalid-column-name-starid-invalid-column-name-starid-while-move-or-delete-document-type-i-i-problem