Copied to clipboard

Flag this post as spam?

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


  • Ole Kirkholt 8 posts 38 karma points
    Sep 16, 2014 @ 11:03
    Ole Kirkholt
    0

    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)

  • Luke Alderton 191 posts 508 karma points
    Sep 16, 2014 @ 11:14
    Luke Alderton
    0

    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

  • Ole Kirkholt 8 posts 38 karma points
    Sep 16, 2014 @ 11:46
    Ole Kirkholt
    0

    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

  • Luke Alderton 191 posts 508 karma points
    Sep 16, 2014 @ 11:50
    Luke Alderton
    0

    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.

  • Shiraz 11 posts 33 karma points
    Oct 02, 2015 @ 03:57
    Shiraz
    0

    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

Please Sign in or register to post replies

Write your reply to:

Draft