Copied to clipboard

Flag this post as spam?

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


  • Martijn van der Put 44 posts 65 karma points
    Feb 17, 2012 @ 16:38
    Martijn van der Put
    0

    Renaming the DocumentType Alias in 4.7.1.1 using SQL CE

    When I try to rename the Alias of a DocumentType in Umbraco 4.7.1.1 using SQL CE 4, it throws an error about the SQL query:

    Error running NonQuery:
    SQL Statement:
    truncate table cmsContentXml

    Exception:
    System.Data.SqlServerCe.SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = truncate ]
      at System.Data.SqlServerCe.SqlCeCommand.ProcessResults(Int32 hr)
      at System.Data.SqlServerCe.SqlCeCommand.CompileQueryPlan()
      at System.Data.SqlServerCe.SqlCeCommand.ExecuteCommand(CommandBehavior behavior, String method, ResultSetOptions options)
      at System.Data.SqlServerCe.SqlCeCommand.ExecuteNonQuery()
      at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteNonQuery(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

Please Sign in or register to post replies

Write your reply to:

Draft