Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

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


  • Adam 51 posts 81 karma points
    Jul 10, 2012 @ 11:20
    Adam
    0

    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.

     

    Copy Link
  • Adam 51 posts 81 karma points
    Jul 10, 2012 @ 11:24
    Adam
    0

    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

    CategoryMessageFrom 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)    		 0.00979509965652059 0.002108

    Control Tree

    Control UniqueIDTypeRender Size Bytes (including children)ViewState Size Bytes (excluding children)ControlState Size Bytes (excluding children)
    __Page ASP.default_aspx 0 0 0

    Session State

    Session KeyTypeValue

    Application State

    Application KeyTypeValue
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    umbracoUrl System.String jjachinasupplies.com:80/umbraco
    umbracoNeedConfiguration System.Boolean False
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM
    vnc38ykjnkjdnk2jt98ygkxjng System.DateTime 7/10/2012 9:55:04 AM

    Request Cookies Collection

    NameValueSize
    __utma 240010328.228070064.1319020667.1334258339.1335874384.110 63
    __utmz (240010328.1334073663.107.32.utmcsr=identi.ca|utmccn=(referral)|utmcmd=referral|utmcct=/zdamatrillion)   107

    Response Cookies Collection

    NameValueSize

    Headers Collection

    NameValue
    Connection keep-alive
    Accept text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    Accept-Charset ISO-8859-1,utf-8;q=0.7,*;q=0.3
    Accept-Encoding gzip,deflate,sdch
    Accept-Language en-GB,en-US;q=0.8,en;q=0.6
    Cookie __utma=240010328.228070064.1319020667.1334258339.1335874384.110; __utmz=240010328.1334073663.107.32.utmcsr=identi.ca|utmccn=(referral)|utmcmd=referral|utmcct=/zdamatrillion
    Host www.jjachinasupplies.com
    User-Agent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11
    DNT 1
    X-REWRITE-URL /

    Response Headers Collection

    NameValue
    X-AspNet-Version 4.0.30319
    Cache-Control private
    Content-Type text/html

    Form Collection

    NameValue

    Querystring Collection

    NameValue

    Server Variables

    NameValue
    ALL_HTTP HTTP_CONNECTION:keep-alive HTTP_ACCEPT:text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.3 HTTP_ACCEPT_ENCODING:gzip,deflate,sdch HTTP_ACCEPT_LANGUAGE:en-GB,en-US;q=0.8,en;q=0.6 HTTP_COOKIE:__utma=240010328.228070064.1319020667.1334258339.1335874384.110; __utmz=240010328.1334073663.107.32.utmcsr=identi.ca|utmccn=(referral)|utmcmd=referral|utmcct=/zdamatrillion HTTP_HOST:www.jjachinasupplies.com HTTP_USER_AGENT:Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11 HTTP_DNT:1
    ALL_RAW Connection: keep-alive Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3 Accept-Encoding: gzip,deflate,sdch Accept-Language: en-GB,en-US;q=0.8,en;q=0.6 Cookie: __utma=240010328.228070064.1319020667.1334258339.1335874384.110; __utmz=240010328.1334073663.107.32.utmcsr=identi.ca|utmccn=(referral)|utmcmd=referral|utmcct=/zdamatrillion Host: www.jjachinasupplies.com User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11 DNT: 1
    APPL_MD_PATH /LM/W3SVC/60/ROOT
    APPL_PHYSICAL_PATH D:\HostingSpaces\jjachina\jjachinasupplies.com\wwwroot\
    AUTH_TYPE  
    AUTH_USER  
    AUTH_PASSWORD  
    LOGON_USER  
    REMOTE_USER  
    CERT_COOKIE  
    CERT_FLAGS  
    CERT_ISSUER  
    CERT_KEYSIZE  
    CERT_SECRETKEYSIZE  
    CERT_SERIALNUMBER  
    CERT_SERVER_ISSUER  
    CERT_SERVER_SUBJECT  
    CERT_SUBJECT  
    CONTENT_LENGTH 0
    CONTENT_TYPE  
    GATEWAY_INTERFACE CGI/1.1
    HTTPS off
    HTTPS_KEYSIZE  
    HTTPS_SECRETKEYSIZE  
    HTTPS_SERVER_ISSUER  
    HTTPS_SERVER_SUBJECT  
    INSTANCE_ID 60
    INSTANCE_META_PATH /LM/W3SVC/60
    LOCAL_ADDR 109.203.122.166
    PATH_INFO /default.aspx
    PATH_TRANSLATED D:\HostingSpaces\jjachina\jjachinasupplies.com\wwwroot\default.aspx
    QUERY_STRING  
    REMOTE_ADDR 86.155.62.48
    REMOTE_HOST 86.155.62.48
    REMOTE_PORT 62248
    REQUEST_METHOD GET
    SCRIPT_NAME /default.aspx
    SERVER_NAME www.jjachinasupplies.com
    SERVER_PORT 80
    SERVER_PORT_SECURE 0
    SERVER_PROTOCOL HTTP/1.1
    SERVER_SOFTWARE Microsoft-IIS/7.0
    URL /default.aspx
    HTTP_CONNECTION keep-alive
    HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
    HTTP_ACCEPT_CHARSET ISO-8859-1,utf-8;q=0.7,*;q=0.3
    HTTP_ACCEPT_ENCODING gzip,deflate,sdch
    HTTP_ACCEPT_LANGUAGE en-GB,en-US;q=0.8,en;q=0.6
    HTTP_COOKIE __utma=240010328.228070064.1319020667.1334258339.1335874384.110; __utmz=240010328.1334073663.107.32.utmcsr=identi.ca|utmccn=(referral)|utmcmd=referral|utmcct=/zdamatrillion
    HTTP_HOST www.jjachinasupplies.com
    HTTP_USER_AGENT Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/536.11 (KHTML, like Gecko) Chrome/20.0.1132.47 Safari/536.11
    HTTP_DNT 1
    HTTP_X_REWRITE_URL /
    Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272
    Copy Link
  • Adam 51 posts 81 karma points
    Jul 10, 2012 @ 12:46
    Adam
    0

    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

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft