Sign in Register
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Deniz ESEN 2 posts 72 karma points notactivated
    Oct 05, 2024 @ 20:27
    Deniz ESEN
    0

    An error occurred Invalid column name '*id'. Invalid column name '*id'. while move or delete "Document Type" (I --> i problem)

    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???

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies