Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at

  • Shiraz 11 posts 33 karma points
    Oct 01, 2015 @ 06:22

    Incorrect parameter count in the call to native function 'ISNULL' SmartBlog Management


    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

  • Paulo Amf 4 posts 74 karma points
    May 21, 2017 @ 06:33
    Paulo Amf

    Same Problem . Two years later, and the Bug Persists ?

Please Sign in or register to post replies

Write your reply to: