This is what happens: Someone post a long list of [item][/item], anything from 150 and up. They click "post", the thread or new post is posted, but then it gets stuck for about 1 minute because its trying to open the thread with the new post, until their web browser just shows a timeout message. The new post (or new thread) however gets posted fine. But anyone trying to access it simply gets stuck and their browser times out. To me (the admin), the vBulletin then sends the following email every time someone tries to access those threads:
Database error in vBulletin 3.6.4:
Invalid SQL:
UPDATE vbsession
SET lastactivity = 1173694527, location = '/showthread.php?p=2048', incalendar = 0, badlocation = 0, useragent = 'Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 6.0; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.0.04506)'
WHERE sessionhash = 'c49796a3afa908442d40da90485c1fac';
MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
The option define('automatic_search', false); in the config_itemstats.php is set to false.
Now what I do when someone post long item banks and the thread gets stuck is, I disable the mod, divide their post in half (copy and cut off the ending half of the itens), save and load the thread to make sure it loads fine without getting stuck, then I post again with the ending half of the itens and load the thread once more. Once it loads, it's there forever.
|