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

SQL Errors with 2 tables.

Discussion in 'Troubleshooting and Problems' started by Kane Hart, Jun 16, 2011.

  1. Kane Hart

    Kane Hart Active Member

    I been having SQL errors and not a big into SQL but I do learn like the rest of you using google <3

    Anyways I checked out my database in ssh and found the following 2 errors on 2 tables:
    xen.xf_thread_view
    note : The storage engine for the table doesn't support optimize

    xen.xf_session_activity
    note : The storage engine for the table doesn't support optimize

    I found out I had issues when I could not backup my database anymore. Trying to backup using navicat produced a error 28 storage engine.

    When I figured it out what 2 tables even opening produced the same error.

    I assume the 2 tables could be deleted and recreated but I'm not good at creation so if someone can pass me a query for the 2 that be wonderful.
     
  2. Brogan

    Brogan XenForo Moderator Staff Member

    Those 2 tables are MEMORY type, which is why they aren't able to be optimised.
     
  3. Kane Hart

    Kane Hart Active Member

    They are damaged or something somehow though. Its not letting me backup at all anymore because of them. Any suggestions on that?
     
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Have you tried truncating both tables?

    It's unlikely the table structure will have become damaged or corrupt.
     
  5. Mike

    Mike XenForo Developer Staff Member

    What you posted isn't an error. It's just informational.

    Those tables won't have any effect on whether you can do a backup. Error 28 is an out of space on disk error.
     

Share This Page