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.
eduardobarcello; automatic_search is set by the gItemStats vBulletin options, config.php and config_itemstats.php is not used at all.
The problem with adding 200 item's is that it has to open 200 thottbot/alla/etc pages one at a time at the time of posting (with auto search on) in order to retrieve the information about each item. This can be a lengthy process depending on how quickly your server can talk to the database site and how well it can process the resulting information.
Support for this addon is a little tricky as the code that actually does the retrieving of the item data is done by code not written by me and I am not quite prepared to support that, however I will attempt to, but it may not be in a timely manner. Basically what I am providing here is ease of installation of Itemstats by eliminating the need for editing config files.
Reeve of shinral; I am not quite sure why that is happening for you. It would appear that you might have two [item] modifications which declare that function?
would it be possible to add support for www.wowhead.com to this plugin for what i noticed that site is 9 out of 10 times way faster then the others
nvm saw the answer in another post now
I have an issue with my Socket's showing up as Red X's
Everything else works great.
Any ideas?
EDIT: Here is what i noticed. If i pull from Allakazham i get red X's in the sockets. If i pull from Thottbot i get everything to show up. The only problem is the Text that is supposed to be green is showing up as Orange on the item name.
gItemStats - World of Warcraft Itemstats Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
03-12-2007, 09:43 AM
