View Single Post
  #46  
Old 07-22-2008, 07:57 PM
Asgorath Asgorath is offline
 
Join Date: Feb 2007
Posts: 3
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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&nbsp;<small>(1.33\%&nbsp;@&nbsp;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/
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01732 seconds
  • Memory Usage 1,768KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_quote
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete