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

Please Sign in or register to post replies

Write your reply to:

Draft