I'm having some pretty bad performance problems since upgrading to the 3.7 version of this plugin. From looking at the SQL error messages as pages time out, it appears as if the caching isn't working or something.
This is a common error, for example:
Quote:
Database error in vBulletin 3.7.2:
Invalid SQL:
INSERT INTO itemstat_cache
( `id` ,`name` ,`quality` ,`icon` ,`lang` ,`htmlTooltip` )
VALUES (
'32837',
'Warglaive of Azzinoth',
'5',
'INV\_Weapon\_Glave\_01',
'www',
'<table><tr><td><b class=\"q5\">Warglaive of Azzinoth</b><br />Binds when picked up<br />Unique<table width=\"100\%\"><tr><td>Main Hand</td><th>Sword</th></tr></table><table width=\"100\%\"><tr><td>214 - 398 Damage</td><th>Speed 2.80</th></tr></table>(109.3 damage per second)<br />+22 Agility<br />+29 Stamina<!--e--><br />Durability 125 / 125<br />Classes: Warrior, Rogue<br />Requires Level 70</td></tr></table><table><tr><td><span class=\"q2\">Equip: Improves hit rating by 21 <small>(1.33\% @ L70)</small>.</span><br /><span class=\"q2\">Equip: Increases attack power by 44.</span><br /><br /><span class=\"q\">The Twin Blades of Azzinoth (0/2)</span><div class=\"q0 indent\"><span><!--si32838-->Warglaive of Azzinoth</span><br /><span><!--si32837-->Warglaive of Azzinoth</span></div><br /><span class=\"q0\"><span>(2) Set: Your melee attacks have a chance to increase your haste rating by 450 for 10 sec.</span><br /><span>(2) Set: Increases attack power by 200 when fighting Demons.</span></span></td></tr></table>' );;
MySQL Error : MySQL server has gone away
|
The thing is, that particular item is definitely in the database (there's a link on the front page, and I've manually inspected the table to confirm), so I'm not sure why the plugin is trying to insert the data again.
Has anyone else experienced this? I've uninstalled and re-downloaded/reinstalled the plugin several times now, to no avail. Our website is here, for reference:
http://www.wastedepicsguild.com/