This project is read-only.
2
Vote

Error creating relationships in Umbraco 4.7RC using MS SQL CE 4

description

Here's the error I get when trying to create a relationship:
 
Server Error in '/' Application.
 
Error running Scalar:
SQL Statement:
INSERT INTO umbracoRelationType (dual, parentObjectType, childObjectType, name, alias) VALUES (0, 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'Related Page', 'relatedPage'); SELECT MAX (id) FROM umbracoRelationType
 
Exception:
System.Data.SqlServerCe.SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 211,Token in error = SELECT ]
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.ExecuteScalar()
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCeApplicationBlock.cs:line 42
 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
 
Exception Details: SqlCE4Umbraco.SqlCeProviderException: Error running Scalar:
SQL Statement:
INSERT INTO umbracoRelationType (dual, parentObjectType, childObjectType, name, alias) VALUES (0, 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'Related Page', 'relatedPage'); SELECT MAX (id) FROM umbracoRelationType
 
Exception:
System.Data.SqlServerCe.SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 211,Token in error = SELECT ]
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.ExecuteScalar()
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCeApplicationBlock.cs:line 42
 
Source Error:
 
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
 
Stack Trace:
 
 
[SqlCeProviderException: Error running Scalar:
SQL Statement:
INSERT INTO umbracoRelationType (dual, parentObjectType, childObjectType, name, alias) VALUES (0, 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'c66ba18e-eaf3-4cff-8a22-41b16d66a972', 'Related Page', 'relatedPage'); SELECT MAX (id) FROM umbracoRelationType
 
Exception:
System.Data.SqlServerCe.SqlCeException: There was an error parsing the query. [ Token line number = 1,Token line offset = 211,Token in error = SELECT ]
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.ExecuteScalar()
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCeApplicationBlock.cs:line 42]
SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCeApplicationBlock.cs:50
SqlCE4Umbraco.SqlCEHelper.ExecuteScalar(String commandText, SqlCeParameter[] parameters) in C:\work\codeplex\hgUmbraco\components\SQLCE4Umbraco\SqlCEHelper.cs:59
umbraco.DataLayer.SqlHelper1.ExecuteScalar(String commandText, IParameter[] parameters) +160
 
[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteScalar]
umbraco.DataLayer.SqlHelper
1.ExecuteScalar(String commandText, IParameter[] parameters) +221
Umbraco.RelationTypes.NewRelationType.AddButton_Click(Object sender, EventArgs e) +343
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +118
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +112
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +36
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +5563
 
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1

comments

PetrSnobelt wrote Mar 29, 2012 at 5:17 AM

Error is in latest version of umbraco 4 too (umbraco v 4.7.1.1)

wrote Feb 13, 2013 at 12:14 AM