Copied to clipboard

Flag this post as spam?

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


  • Dmitriy Larionov 10 posts 30 karma points
    Jan 16, 2015 @ 23:43
    Dmitriy Larionov
    0

    Bug at dashboard in content section if Umbraco installed on SQL CE database

    On SQL CE database after installation of Smart Blog, when i go to "Content" -> "Smart Blog Management" i get:

    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): Неверное число аргументов, указанных для функции. [ 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 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): Неверное число аргументов, указанных для функции. [ 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 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): Неверное число аргументов, указанных для функции. [ 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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
       SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +417
       SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +26
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +161
    
    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +361
       SmartBlogLibraries.smartBlogManagement.GetAllDocuments(SearchTerm searchTerm) +547
       SmartBlogLibraries.smartBlogManagement.showResults(EventArgs e) +90
       SmartBlogLibraries.smartBlogManagement.OnLoad(EventArgs e) +144
       System.Web.UI.Control.LoadRecursive() +71
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Control.LoadRecursive() +190
       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3178
    



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

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Jan 17, 2015 @ 07:35
    Jan Skovgaard
    0

    Hi Dmitriy

    What version of SmartBlog have you installed? And on which version of Umbraco?

    /Jan

  • Dmitriy Larionov 10 posts 30 karma points
    Jan 17, 2015 @ 11:51
    Dmitriy Larionov
    0

    Hello, Jan.

    Umbraco version 7.2.0 assembly: 1.0.5451.27165 , Smart Blog 2.0.9.

    It may be important - umbraco installed on SQL CE database.

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Jan 17, 2015 @ 16:40
    Jan Skovgaard
    0

    Hi Dmitriy

    Hmm, ok...It may be that the package does not support CE SQL. But I'm not sure. I'll see if I can test it myself.

    Yeah CE SQL is the default DB when running the Umbraco installer unless you choose "Customize" during the wizard where it's possible to setup a connectionstring for MSSQL for instance.

    I'll get back to you.

    /Jan

  • Jan Skovgaard 11280 posts 23678 karma points MVP 11x admin c-trib
    Jan 17, 2015 @ 17:58
    Jan Skovgaard
    0

    Hi Dmitriy

    I just tested the package on a 7.2 CE SQL installation as well and I get the same error as you. So perhaps you should try to migrate the CE SQL database to MSSQL if possible and see if it works. If it does not then the package creator probably need to have a look at the bug.

    /Jan

  • Dmitriy Larionov 10 posts 30 karma points
    Jan 17, 2015 @ 22:43
    Dmitriy Larionov
    0

    Cool, that you have reproduces that bug so fast. I just have to inform you, that such a problem exists. I will consider migration to Azure SQL, because i'm in Azure. But i believe, that mature Umbraco package should support all databases that Umraco supports.

    Thank you, Jan. 

Please Sign in or register to post replies

Write your reply to:

Draft