Reason for database errors?

[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!

[Zachery]

How are you storing the datastore? default or in the filesystem/xcache/apc/memcache?

[Simon Lloyd]

Well here's the rub, around 4 days ago my forum experienced major problems, no access to admincp...etc, the hosts couldn't see what was wrong and asked cpanel to check it out, they said the issue is with cpanel and APC (they dont support it) however its been working fine for a year, but sure enough comment out the line for acp and i had control back (after changing config.php to filecache and turning off apc usage in dbtechs vboptimies mod), so now im running on filecache but it all appears to be there inm the databse just fine?

[Zachery]

Chances are it cannot write/lock the datastore cache file. Switch back to the normal datastore cache (nothing).

Then try the same query again. Also double check your database user has ALL permissions (short of grant) on its own database.

[Simon Lloyd]

Hmmm i dont see why the databse user should have changed the forums been the same (all barr creating mods and tinkering) for the last 4 years

So you recon if i comment out all caching in config.php that should do it?

[Zachery]

Its not going to hurt anything, if it doexn't fix anything you can change it back just as easily.

[Simon Lloyd]

Ok just done that and the query executed fine?? now that we've established that what can i do to enable caching of some sort?