Sign in Register
Copied to clipboard

Flag this post as spam?

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


  • Johan Roug 97 posts 153 karma points
    May 24, 2011 @ 21:45
    Johan Roug
    0

    uComment and SQL CE

    Hi

    I tried uComment with a normal microsoft sql database, and it worked fine. Now I tried with SQL CE, and I get an error in the dashboard.

     

    Error running Reader:
    SQL Statement:
    select * from comment where spam != 1 order by created desc

    Exception:
    System.Data.SqlServerCe.SqlCeException: 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 SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

    Copy Link
  • Petr Snobelt 923 posts 1534 karma points
    May 24, 2011 @ 22:02
    Petr Snobelt
    0

    I use uComponents with sqlCE, please try to be more specific, what to do to reproduce error.

    Petr

    Copy Link
  • Johan Roug 97 posts 153 karma points
    May 24, 2011 @ 22:23
    Johan Roug
    0

    The only thing I did was install uComment. After this I went to the content area where I could see the error. Did you change anything ? I installed version 1.2

    Copy Link
  • Petr Snobelt 923 posts 1534 karma points
    May 25, 2011 @ 06:34
    Petr Snobelt
    0

    This error is caused by starterkit, not by uComponents.

    http://umbraco.codeplex.com/workitem/30190

     

    Petr 

    Copy Link
  • Johan Roug 97 posts 153 karma points
    May 25, 2011 @ 10:22
    Johan Roug
    0

    It could be a solution.

    However I didn't install any starterkit or theme. It is a completly empty Umbraco install with uComment installet afterwards

    Copy Link
  • Johan Roug 97 posts 153 karma points
    May 25, 2011 @ 19:11
    Johan Roug
    0

    Ok

    I followed your link.

    Extracted uComment.zip edited the xml with that of your link, and zipped it again. Then I uninstalled my uComment, and installed the modified version. Now I don't get the error anymore, and I can create comments. Cool

     

    The only problem is now, that I can't seem to delete the comments again. I'll look into that

    Thanks for your help

    Copy Link

  • This forum is in read-only mode while we transition to the new forum.

    You can continue this topic on the new forum by tapping the "Continue discussion" link below.

Please Sign in or register to post replies