1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Site Crash - Help!

Discussion in 'Troubleshooting and Problems' started by bluemartian, Jan 31, 2014.

  1. bluemartian

    bluemartian Member

    Well, my day has just been made. I just recently moved to a new webhost (MDDHosting) about half a month ago. My forum has run flawlessly up until about an hour ago when it simply stopped rendering. I got the following from my webhost after about an hour. The site is back up but showing posts from half a month ago. I am deeply despondent as I was thrilled with my new host and how fast everything was running. Can anybody clue me in as to what if anything I can do or even what happened? I had made no changes whatsoever to my site in weeks. Thanks! (running XF 1.2.4)

  2. Mike

    Mike XenForo Developer Staff Member

    That error message is misleading because it's not going to be an internal column. From http://dev.mysql.com/doc/refman/5.1/en/innodb-restrictions.html:
    None of those are in the table and this isn't something we've ever had reported before.

    Unfortunately, it's clear your host has run into data corruption and has attempted to recover from it. It sounds as if there are still remnants of the old data there. You can see references to that in these cases:


    The latter indicates that there may be more information in the actual MySQL error log. The former refers to creating a new database to get away from the old one (possibly for the same reasons as mentioned in the other question). Regardless, these are very likely options that your host would need to take.
  3. bluemartian

    bluemartian Member

    Thanks, Mike! I'll pass it on.
  4. bluemartian

    bluemartian Member

    You were spot on, Mike. My host has had silent file corruption issues on my server. When I gave them your response (above), they came back stating that today's issue is in fact due to SSD caching problems (which - just my luck - render all recent backups duds, too). My forum is up and running again but I've lost a week of data. My own last backup is a day older than the one my host was able to restore (from the 24th). I'm really disappointed in this host. They started off so well and in just 3 weeks they managed to have two hardware issues and lose over a week of my data. I know I'm responsible for my own data but still.

    My worry now is whether my current database could be corrupt or not. Is it possible to have a functioning but still corrupted database/forum? Should I roll back to my original dataset from 3 weeks ago (when I first came on board with MDDHosting) to avoid any lingering/continuing corruption, or am I safe to go on with my current dataset? Thanks for your help!
  5. Brogan

    Brogan XenForo Moderator Staff Member

    If you aren't experiencing any errors then it's safe to assume the DB is sound.

Share This Page