Copied to clipboard

Flag this post as spam?

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


  • Alex 16 posts 97 karma points
    Apr 27, 2014 @ 05:45
    Alex
    0

    Dashboard not displaying

  • Luke Alderton 191 posts 508 karma points
    Apr 28, 2014 @ 18:20
    Luke Alderton
    0

    Hi Alex,

    Have you got any other error logs?

    Thanks, Luke

  • Joshua White 3 posts 23 karma points
    May 02, 2014 @ 18:27
    Joshua White
    0

    I have the same error - fresh install of 7.1.1 / nothing else installed / using v2.0.5 Smart Blog. No other error logs, sorry.

  • Luke Alderton 191 posts 508 karma points
    May 07, 2014 @ 10:25
    Luke Alderton
    0

    Could you confirm that the control exists for me? Thanks.

  • Darren Clark 52 posts 249 karma points
    May 08, 2014 @ 23:35
    Darren Clark
    100

    Hi Luke,

    Just spotted the problem, the namespace in the smartblogManagement.dll for the user control is SmartLibraries. But the user control smartblogManagement.ascx inherits from SmartBlogLibraries

    <%@ Control Language="C#" AutoEventWireup="true" Inherits="SmartBlogLibraries.smartBlogManagement" Codebehind="smartBlogManagement.ascx.cs" %>
    

    Alex you might get away with changing the line in the user control to the following as a workaround

    <%@ Control Language="C#" AutoEventWireup="true" Inherits="SmartLibraries.smartBlogManagement" Codebehind="smartBlogManagement.ascx.cs" %>
    

    Regards Darren

  • Alex 16 posts 97 karma points
    May 09, 2014 @ 05:44
    Alex
    0

    Thanks Darren! I gave it a try and got a different error message. Though it looks like a step in the right direction.

     

    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)

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

    Exception Details: SqlCE4Umbraco.SqlCeProviderException: 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)

    Source Error: 

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


    Stack Trace: 

    [SqlCeProviderException: 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)]
       SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +184
       SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +37
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +82
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +202
       SmartLibraries.smartBlogManagement.GetAllDocuments(SearchTerm searchTerm) +362
       SmartLibraries.smartBlogManagement.showResults(EventArgs e) +61
       SmartLibraries.smartBlogManagement.OnLoad(EventArgs e) +62
       System.Web.UI.Control.LoadRecursive() +54
       System.Web.UI.Control.LoadRecursive() +145
       System.Web.UI.Control.LoadRecursive() +145
       System.Web.UI.Control.LoadRecursive() +145
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +772
    



    Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34009

  • Darren Clark 52 posts 249 karma points
    May 09, 2014 @ 10:14
    Darren Clark
    0

    Hi Alex,

    It looks like the query that loads the data into the dashboard control is not working with sqlce.

    I would maybe try installing umbraco with a sql server db and not a sqlce instance, unless luke can reproduce the error and see what is going wrong with query.

    Cheers Darren

  • Alex 16 posts 97 karma points
    May 12, 2014 @ 08:07
    Alex
    0

    Thanks Darren! That did the trick.

    After making the change to the user control and switching to SQL Express, the Smart Blog dashboard is working.

  • Luke Alderton 191 posts 508 karma points
    May 12, 2014 @ 10:31
    Luke Alderton
    0

    Hi Alex & Darren,

    I've been away since Thursday, so I haven't had a chance to look at this thread. I've now looked at the smartBlogManagement dll and the ascx and they seem to all reference 'SmartBlogLibraries.smartBlogManagement', perhaps you're using an older version?

    Thanks, Luke

  • Alex 16 posts 97 karma points
    May 12, 2014 @ 10:56
    Alex
    0

    Hi Luke, I have SmartBlog 2.0.5 installed.

    Thanks,
    Alex 

  • Luke Alderton 191 posts 508 karma points
    May 13, 2014 @ 10:53
    Luke Alderton
    0

    Hmm, that's the latest version! I've gone over the package and it seems to reference SmartBlogLibraries, however the dll provided, does not. I'll release a new version later on today or earlier tomorrow as a fix.

    Thanks for letting me know.

Please Sign in or register to post replies

Write your reply to:

Draft