Copied to clipboard

Flag this post as spam?

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

  • Alan Feekery 5 posts 25 karma points
    Sep 28, 2011 @ 17:14
    Alan Feekery

    Possible problem with SQL CE

    I am running into a problem with this package and to me the error seems to be with SQL CE. I can't use the package at all after instalation, it just spits out the following expection.

    Error running Reader: 
    SQL Statement:
    SELECT * FROM umbracoRedirects WHERE StatusCode <> 404
    System.Data.SqlServerCe.SqlCeException: The specified table does not exist. [ umbracoRedirects ]
      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)

    It is the same for both "Top 404" & "Managed redirects". Claims the table umbracoRedirects does not exist, after creating the table it starts looking for specific columns in the table, StatusCode, Url.

    As a quick fix could you share the schema of the umbracoRedirects table for the people using SQL CE?



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

    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: