Bug at dashboard in content section if Umbraco installed on SQL CE database
On SQL CE database after installation of Smart Blog, when i go to "Content" -> "Smart Blog Management" i get:
Server Error in '/' Application.
Error running Reader: SQL Statement: SELECT
umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as
Published, DocType.Text as nodeTypeName from umbracoNode Left Join
cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1
INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN
umbracoNode DocType ON cmsContent.contentType = DocType.Id and
DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb' INNER
JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId
WHERE (umbracoNode.nodeObjectType =
'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <>
-20And cmsContentType.alias = @Alias And
isNull(CMSDocument.Published,0) = @Published
Exception: System.Data.SqlServerCe.SqlCeException
(0x80004005): Неверное число аргументов, указанных для функции. [
Minimum argument count = 1, Maximum argument count = 1,Name of
function(if known) = isNull ] 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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlCeParameter[] commandParameters)
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 Reader: SQL Statement: SELECT
umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as
Published, DocType.Text as nodeTypeName from umbracoNode Left Join
cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1
INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN
umbracoNode DocType ON cmsContent.contentType = DocType.Id and
DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb' INNER
JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId
WHERE (umbracoNode.nodeObjectType =
'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <>
-20And cmsContentType.alias = @Alias And
isNull(CMSDocument.Published,0) = @Published
Exception: System.Data.SqlServerCe.SqlCeException
(0x80004005): Неверное число аргументов, указанных для функции. [
Minimum argument count = 1, Maximum argument count = 1,Name of
function(if known) = isNull ] 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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlCeParameter[] commandParameters)
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 Reader:
SQL Statement:
SELECT umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as Published, DocType.Text as nodeTypeName from umbracoNode Left Join cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1 INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN umbracoNode DocType ON cmsContent.contentType = DocType.Id and DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb' INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId WHERE (umbracoNode.nodeObjectType = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <> -20And cmsContentType.alias = @Alias And isNull(CMSDocument.Published,0) = @Published
Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): Неверное число аргументов, указанных для функции. [ Minimum argument count = 1, Maximum argument count = 1,Name of function(if known) = isNull ]
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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +417
SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +26
umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +161
[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +361
SmartBlogLibraries.smartBlogManagement.GetAllDocuments(SearchTerm searchTerm) +547
SmartBlogLibraries.smartBlogManagement.showResults(EventArgs e) +90
SmartBlogLibraries.smartBlogManagement.OnLoad(EventArgs e) +144
System.Web.UI.Control.LoadRecursive() +71
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Control.LoadRecursive() +190
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34237
Hmm, ok...It may be that the package does not support CE SQL. But I'm not sure. I'll see if I can test it myself.
Yeah CE SQL is the default DB when running the Umbraco installer unless you choose "Customize" during the wizard where it's possible to setup a connectionstring for MSSQL for instance.
I just tested the package on a 7.2 CE SQL installation as well and I get the same error as you. So perhaps you should try to migrate the CE SQL database to MSSQL if possible and see if it works. If it does not then the package creator probably need to have a look at the bug.
Cool, that you have reproduces that bug so fast. I just have to inform you, that such a problem exists. I will consider migration to Azure SQL, because i'm in Azure. But i believe, that mature Umbraco package should support all databases that Umraco supports.
Bug at dashboard in content section if Umbraco installed on SQL CE database
On SQL CE database after installation of Smart Blog, when i go to "Content" -> "Smart Blog Management" i get:
Server Error in '/' Application.
Error running Reader:
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.SQL Statement:
SELECT umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as Published, DocType.Text as nodeTypeName from umbracoNode Left Join cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1 INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN umbracoNode DocType ON cmsContent.contentType = DocType.Id and DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb' INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId WHERE (umbracoNode.nodeObjectType = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <> -20And cmsContentType.alias = @Alias And isNull(CMSDocument.Published,0) = @Published
Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): Неверное число аргументов, указанных для функции. [ Minimum argument count = 1, Maximum argument count = 1,Name of function(if known) = isNull ]
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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
Exception Details: SqlCE4Umbraco.SqlCeProviderException: Error running Reader:
SQL Statement:
SELECT umbracoNode.Id,umbracoNode.Text, isNull(CMSDocument.Published,0) as Published, DocType.Text as nodeTypeName from umbracoNode Left Join cmsDocument ON umbracoNode.Id = cmsDocument.NodeId and Published = 1 INNER JOIN cmsContent ON umbracoNode.Id = cmsContent.NodeId INNER JOIN umbracoNode DocType ON cmsContent.contentType = DocType.Id and DocType.nodeObjectType = 'a2cb7800-f571-4787-9638-bc48539a0efb' INNER JOIN cmsContentType ON cmsContent.contentType = cmsContentType.NodeId WHERE (umbracoNode.nodeObjectType = 'c66ba18e-eaf3-4cff-8a22-41b16d66a972')AND umbracoNode.ParentId <> -20And cmsContentType.alias = @Alias And isNull(CMSDocument.Published,0) = @Published
Exception:
System.Data.SqlServerCe.SqlCeException (0x80004005): Неверное число аргументов, указанных для функции. [ Minimum argument count = 1, Maximum argument count = 1,Name of function(if known) = isNull ]
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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
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:
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34237
Hi Dmitriy
What version of SmartBlog have you installed? And on which version of Umbraco?
/Jan
Hello, Jan.
Umbraco version 7.2.0 assembly: 1.0.5451.27165 , Smart Blog 2.0.9.
It may be important - umbraco installed on SQL CE database.
Hi Dmitriy
Hmm, ok...It may be that the package does not support CE SQL. But I'm not sure. I'll see if I can test it myself.
Yeah CE SQL is the default DB when running the Umbraco installer unless you choose "Customize" during the wizard where it's possible to setup a connectionstring for MSSQL for instance.
I'll get back to you.
/Jan
Hi Dmitriy
I just tested the package on a 7.2 CE SQL installation as well and I get the same error as you. So perhaps you should try to migrate the CE SQL database to MSSQL if possible and see if it works. If it does not then the package creator probably need to have a look at the bug.
/Jan
Cool, that you have reproduces that bug so fast. I just have to inform you, that such a problem exists. I will consider migration to Azure SQL, because i'm in Azure. But i believe, that mature Umbraco package should support all databases that Umraco supports.
Thank you, Jan.
is working on a reply...