Press Ctrl / CMD + C to copy this to your clipboard.
This post will be reported to the moderators as potential spam to be looked at
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.
Same Problem . Two years later, and the Bug Persists ?
is working on a reply...
Write your reply to:
Image will be uploaded when post is submitted