• 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.

Kane Hart

Active member
#1
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.
 

Brogan

XenForo moderator
Staff member
#4
Have you tried truncating both tables?

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

Mike

XenForo developer
Staff member
#5
They are damaged or something somehow though. Its not letting me backup at all anymore because of them. Any suggestions on that?
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.