I have Umbraco 4.7.1 , Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272. I have included the error message and stack trace I see when visiting our homepage (www.jjachinasupplies.com). My hosting company, eUKhost, seems to be slow in updating support tickets and the only thing they have said is that the database seems to be corrupted and that they could not help any further. They installed Umbraco for me last year and recently migrated their servers. I have not made any changes to the site in the last 2 or 3 months so it has not been caused by us. I really don't know what I need to do as I am just a web designer and SEO. Any help would be appreciated to get the site back online.
I have asked the hosting company if they have any backup but am yet to hear back so am posting here in the meantime.
I tried pasting in the error info from the homepage but it doesn't seem to work - must be because of the HTML so here it is as plain text (might be easier just to look at the homepage in the link from my first post)
Stack Trace:
[SqlCeProviderException: Error running Reader:
SQL Statement:
select id, domainName from umbracoDomains
Exception:
System.Data.SqlServerCe.SqlCeException: The database file may be corrupted. Run the repair utility to check the database file. [ Database name = \\?\D:\HostingSpaces\jjachina\jjachinasupplies.com\wwwroot\App_Data\Umbraco.sdf ]
at System.Data.SqlServerCe.SqlCeConnection.ProcessResults(Int32 hr)
at System.Data.SqlServerCe.SqlCeConnection.Open(Boolean silent)
at System.Data.SqlServerCe.SqlCeConnection.Open()
at SQLCE4Umbraco.SqlCeContextGuardian.ensureOpenBackgroundConnection(String connectionString)
at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +192
SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +37
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
umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0() +89
umbraco.cms.businesslogic.cache.Cache.GetCacheItem(String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) +132
umbraco.cms.businesslogic.web.Domain.GetDomains() +158
umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName) +44
umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain) +232
umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url) +523
umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) +1062
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.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.Page.OnPreInit(EventArgs e) +9010534
System.Web.UI.Page.PerformPreInit() +31
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +328
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
Request Details
Session Id:
bwjp3xvh05bg3e5mzqlhkai0
Request Type:
GET
Time of Request:
7/10/2012 9:55:04 AM
Status Code:
500
Request Encoding:
Unicode (UTF-8)
Response Encoding:
Unicode (UTF-8)
Trace Information
Category
Message
From First(s)
From Last(s)
aspx.page
Begin PreInit
umbracoInit
handling request
1.76000022349209E-05
0.000018
request handler
current url ''
0.007686731134823
0.007669
Unhandled Execution Error
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) at umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0() at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem) at umbraco.cms.businesslogic.web.Domain.GetDomains() at umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName) at umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain) at umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url) at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.EventHandler.Invoke(Object sender, EventArgs e) at System.Web.UI.Page.OnPreInit(EventArgs e) at System.Web.UI.Page.PerformPreInit() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Okay, issue was resolved by the hosting company using a recent backup. Not sure why I had to suggest this in the first place but everything is okay now. Apologies for wasting anyone's time.
Website Suddenly Down: 'Error running reader' Hosting Company says Database is Corrupted - Please, please help if you can
Hi,
I have Umbraco 4.7.1 , Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272. I have included the error message and stack trace I see when visiting our homepage (www.jjachinasupplies.com). My hosting company, eUKhost, seems to be slow in updating support tickets and the only thing they have said is that the database seems to be corrupted and that they could not help any further. They installed Umbraco for me last year and recently migrated their servers. I have not made any changes to the site in the last 2 or 3 months so it has not been caused by us. I really don't know what I need to do as I am just a web designer and SEO. Any help would be appreciated to get the site back online.
I have asked the hosting company if they have any backup but am yet to hear back so am posting here in the meantime.
I tried pasting in the error info from the homepage but it doesn't seem to work - must be because of the HTML so here it is as plain text (might be easier just to look at the homepage in the link from my first post)
Stack Trace:
Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
Request Details
Trace Information
Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
at umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0()
at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
at umbraco.cms.businesslogic.web.Domain.GetDomains()
at umbraco.cms.businesslogic.web.Domain.GetDomain(String DomainName)
at umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain)
at umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url)
at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Page.OnPreInit(EventArgs e)
at System.Web.UI.Page.PerformPreInit()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Control Tree
Session State
Application State
Request Cookies Collection
Response Cookies Collection
Headers Collection
Response Headers Collection
Form Collection
Querystring Collection
Server Variables
Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
Okay, issue was resolved by the hosting company using a recent backup. Not sure why I had to suggest this in the first place but everything is okay now. Apologies for wasting anyone's time.
Thanks
is working on a reply...