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

An unexpected database error occurred. Please try again later.

Discussion in 'Troubleshooting and Problems' started by ShadyX, Feb 6, 2011.

  1. ShadyX

    ShadyX Well-Known Member

    i have just woke up and went to check my forum and i get a blank page saying

    An unexpected database error occurred. Please try again later.

    i have a database backup from early yesterday but thats minus about 500 posts :)

    any ideas? thanks.
     
  2. Mike

    Mike XenForo Developer Staff Member

    You can view the source of the page to find a more specific error message.
     
  3. ShadyX

    ShadyX Well-Known Member

    i get
    <!-- Mysqli prepare error: Unknown table engine 'InnoDB' -->

    in the source :)
     
  4. Mike

    Mike XenForo Developer Staff Member

    You need to contact your host. They removed InnoDB. That's not cool. :)
     
  5. ShadyX

    ShadyX Well-Known Member

    thanks, i just contacted them. So would Xenforo not be able to function without InnoDB? :)
     
  6. Brogan

    Brogan XenForo Moderator Staff Member

    Most of the tables are InnoDB.
     
  7. ShadyX

    ShadyX Well-Known Member

    i just tried using my backup to see if it will work and it did :) its working right now, i checked the database that it was using and it has somehow shrunk to 3.95mb :eek: any ideas of what could of caused this so i can prevent it in the future? :) Thanks.
     
  8. Brogan

    Brogan XenForo Moderator Staff Member

    Did you make any changes between it working and not working?

    Upgrades, add-ons, etc?

    You could also compare the 2 databases to see what the differences are - missing or truncated tables for instance.
     
  9. ShadyX

    ShadyX Well-Known Member

    nope, it was working last night when i went to bed but when i woke up this morning it was giving that error :)
     
  10. Brogan

    Brogan XenForo Moderator Staff Member

    In which case I would contact your host to see if there was some kind of server related issue as under normal circumstances that shouldn't happen.
     
  11. ShadyX

    ShadyX Well-Known Member

    yeah ive contacted them, just waiting on a reply :)
     
  12. Brogan

    Brogan XenForo Moderator Staff Member

    Are you able to compare the 2 databases to see what the differences are?
     
  13. ShadyX

    ShadyX Well-Known Member

    how would i compare them? :)
     
  14. Brogan

    Brogan XenForo Moderator Staff Member

Share This Page