[Simon Lloyd]

Originally Posted by snakes1100

Any system would support xcache, as long as you install it, i assume your not on a vps/dedi?

Not with the way my setup is, i'm on dedicated box.

Originally Posted by ForceHSS

are you trying to make a new mod if so i can give you site for testing i am not using will install what version u need

Nope just all of a sudden had these database isues, but thanks

Originally Posted by Zachery

Don't ever repair or optimize a database if you don't have to. Repairs should only be run if the table is actually crashed. Optimize if and only if you've removed large groups of data from an myisam table.

If you run that query yourself, do you get any errors?

Without an error message hard to tell. php might have timed out and killed the query/connection. or MySQL timed out and killed the query, which made php exit and give you an error. But its weird you're not getting an error message.

Ok i ran that query through admincp>maintainance>execut query and it spat this out:

Fatal error: Could not obtain file lock in [path]/includes/class_datastore.php on line 807
#0 vb_error_handler(256, Could not obtain file lock, /public_html/forumz/includes/class_datastore.php, 807, Array ([title] => options,[data] => a:1512

And then spat out the entire contents of datastore!