Incorrect parameter count in the call to native function 'ISNULL' SmartBlog Management
Hi,
Im getting the following error when i try to view the Smart Blog Management Area.
"Incorrect parameter count in the call to native function 'ISNULL'."
I looked at the logs to see what was going on, to see the following sql is causing the issue,
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
I need to change isnull to ifnull to get it work. pls help.
Incorrect parameter count in the call to native function 'ISNULL' SmartBlog Management
Hi,
Im getting the following error when i try to view the Smart Blog Management Area. "Incorrect parameter count in the call to native function 'ISNULL'." I looked at the logs to see what was going on, to see the following sql is causing the issue, 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
I need to change isnull to ifnull to get it work. pls help.
Umbraco 7+ MySQL SmartBlog 2.2.0
Thnks Shiraz
Same Problem . Two years later, and the Bug Persists ?
is working on a reply...