Copied to clipboard

Flag this post as spam?

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


  • Zeb Sadiq 1 post 21 karma points
    Feb 07, 2011 @ 01:16
    Zeb Sadiq
    0

    4.6.1 for SQL CE

    After installing from Web Platform Installer 3.0. 

     

    I got the following error when I go to the content node after logging in:

    Help/

     

    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 * from comment where spam != 1 order by created desc

     

    Exception:

    System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ comment ]

      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 * from comment where spam != 1 order by created desc

     

    Exception:

    System.Data.SqlServerCe.SqlCeException (0x80004005): The specified table does not exist. [ comment ]

       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) +382

       SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +63

       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +87

     

    [SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]

       umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +142

       Runway.Blog.Dashboard.CommentModeration.BindData() +192

       Runway.Blog.Dashboard.CommentModeration.Page_Load(Object sender, EventArgs e) +100

       System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +14

       System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +35

       System.Web.UI.Control.OnLoad(EventArgs e) +91

       System.Web.UI.Control.LoadRecursive() +74

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Control.LoadRecursive() +146

       System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2207

     

     

     

     

    --------------------------------------------------------------------------------

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

  • Sebastiaan Janssen 5045 posts 15476 karma points MVP admin hq
    Feb 07, 2011 @ 10:42
    Sebastiaan Janssen
    0

    This looks more like something that should be up on Codeplex, looks like it's an issue with the blog install. This forum here is for bugs in the our.umbraco.org site, not for umbraco specific bugs.

     

  • ANSHIT 10 posts 30 karma points
    Feb 01, 2012 @ 13:08
    ANSHIT
    0

    i created an application using umbraco. everything is working fine on my localhost but when i am uploading it on the server, it is returning a error saying:

    Error running Reader:
    SQL Statement:
    select id, domainName from umbracoDomains.

    what could be the problem , all worked well on my local host but not running on server.

    plz help if anyone knows this...

Please Sign in or register to post replies

Write your reply to:

Draft