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)
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)
is working on a reply...