Reason for database errors?

[Simon Lloyd]

Hi all, i'm getting lots of the below database errors, anyone got a suggestion as to why they hhave started appearing?

Database error in vBulletin 3.8.7:

Invalid SQL:

UPDATE vb_adminutil SET
text = UNIX_TIMESTAMP()
WHERE title = 'datastorelock' AND text < UNIX_TIMESTAMP() - 15;

MySQL Error :
Error Number :
Request Date : Monday, June 17th 2013 @ 09:38:12 PM
Error Date : Monday, June 17th 2013 @ 09:38:12 PM
Script : http://www.mysite.com/forumz/archive...f-86-p-30.html
Referrer :
IP Address : xxx.xx.xxx.xxx
Username :
Classname : vB_Database
MySQL Version :

[snakes1100]

Did you disable any exec functionality from php using disable_functions?

[Simon Lloyd]

No, only thing thats been disabled (AFAIK) is APC caching.

[snakes1100]

Try a repair on the table first, run it a couple times.

Post up the error logs for php, when this is happening as well.

What caching system are you using?

[Simon Lloyd]

Im using filecache, i'll take a look at the logs.

[snakes1100]

Id use memcache or xcache, versus the filecache.

Disable the filecache for now as well in your testing.

[Simon Lloyd]

the system steup im using doesn't support xcache, i'll take a look at memcache, unfortunately im at work so can't ssh, i cant check the logs or change caching!

[snakes1100]

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

[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

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