DB Error

[ravenfaust]

am getting this errro:
Database error in vBulletin 3.8.4:

Invalid SQL:

UPDATE post
SET phpkd_vblvb_lastcheck = 1262654476
WHERE postid = 5569;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, January 4th 2010 06:21:16 PM
Error Date : Monday, January 4th 2010 06:23:08 PM
Script : cronadmin.php?do=runcron&cronid=22
Referrer : /cronadmin.php?do=modify
IP Address : 65.96.237.59
Username : Raven Faust
Classname : vB_Database
MySQL Version :

[PHPKD]

Hello Raven,

From your error I see that it's something on your end that's not related to the product "MySQL server has gone away".
Try to run the cronjob again & see, if the same error occurred again while your forum board itself is running smoothly, you may have to lower the total checked posts per each run.
Please let me know if there's any other issues.

Best Regards
Abdelrahman - PHP KingDom

[danswano]

i'm getting the same error with a thread has 100+ links.

[PHPKD]

All MySQL server has gone away errors are due to the fact that the product when configured to process huge number of posts at once, or if your posts contains too -too too too- many links, the product causes high load on the server & at some point it either can't proceed or the MySQl server goes down because it can't handle that large task. It's the default process & the basic checking process that the product currently use. It will be totally changed in an upcoming featured release. But for now, the temporary solution is to lower down posts checked per batch, if the problems still occurs, lower it again & again till you reach the safe limit, if it's acceptable also you may need to limit checked links per post.
As I said, it's just a temporary solution for those with large forums & huge number of posts with extra huge number of links to be checked. The actual & permanent solution will be introduced in an upcoming release.

Please if you've any other questions or need any help, don't hesitate to ask.
.. Moved to closed issues ..