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 Exception: 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?
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.
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
Exception:
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?
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...
is working on a reply...