Thread: Add-On Releases - gItemStats - World of Warcraft Itemstats
View Single Post
  #32  
Old 03-12-2007, 09:43 AM
eduardobarcello eduardobarcello is offline
 
Join Date: Mar 2007
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01099 seconds
  • Memory Usage 1,761KB
  • 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)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