In have done a clean install of Umbraco 7.1.6 and SmartBlog 2.0.9.
When I hit the "Smart Blog Management" page, I get the following error:
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): The number of arguments specified for the function is not correct. [ 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 System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior) at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
I have to admit the management interface has an sql script that does not run well if you're using sql ce or mysql, if you'd like I can provide the source for you to edit?
I will have a look at packaging the source up for you into a zip, but it won't be soon because I have a lot of work on at the moment.
I can confirm though that it is only the management area that has an issue. Though you can still update settings for smartblog by editing the settings file within the config folder.
Im having the same issue with the smartblog management area using mysql. It would be great help if you could provide me the source code. The issue is with ISNULL not supporting in mysql.
Error on management on clean install
Hi
In have done a clean install of Umbraco 7.1.6 and SmartBlog 2.0.9.
When I hit the "Smart Blog Management" page, I get the following error:
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): The number of arguments specified for the function is not correct. [ 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 System.Data.SqlServerCe.SqlCeCommand.ExecuteReader(CommandBehavior behavior)
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)
Hi Ole,
I have to admit the management interface has an sql script that does not run well if you're using sql ce or mysql, if you'd like I can provide the source for you to edit?
Thanks, Luke
Hi
Is it only the managenemt page, that has a problem with sql ce, or is it SmartBlog in general?
I would like to have a look at the source.
Best regards
Ole
I will have a look at packaging the source up for you into a zip, but it won't be soon because I have a lot of work on at the moment.
I can confirm though that it is only the management area that has an issue. Though you can still update settings for smartblog by editing the settings file within the config folder.
Hi Luke,
Im having the same issue with the smartblog management area using mysql. It would be great help if you could provide me the source code. The issue is with ISNULL not supporting in mysql.
Thnkx
Shiraz
is working on a reply...