Thread: Moderators Functions - Force Users to Read a Thread
View Single Post
  #161  
Old 01-03-2012, 07:13 AM
Successfulsteps's Avatar
Successfulsteps Successfulsteps is offline
 
Join Date: Sep 2010
Posts: 143
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by AliMadkour View Post
thanks ...
but sometimes I got that errors

Code:
Invalid SQL:

SELECT *
FROM thread AS thread
LEFT JOIN force_read_users AS force_read_users ON (thread.threadid = force_read_users.force_read_threadid AND force_read_users.force_read_userid = '150409')
WHERE thread.force_read = '1' AND (thread.force_read_expire_date = '0' OR thread.force_read_expire_date > '1320959203') AND (force_read_usergroups = '' OR force_read_usergroups LIKE '%-2-%') AND (force_read_forums = '' OR force_read_forums LIKE '%-72-%' OR force_read_forums LIKE '%-70-%') AND force_read_users.force_read_userid IS NULL
ORDER BY force_read_order ASC;

MySQL Error   : MySQL server has gone away
Error Number  : 2006
Request Date  : Thursday, November 10th 2011 @ 11:06:43 PM
Error Date    : Thursday, November 10th 2011 @ 11:07:21 PM
??
I was getting same error after installing 4.1.9. It is on the host. I had my wait_timeout: set way too low. It's set at 120 now, but the default goes as high as 28800 on my host. I'd contact them. It caused me to have all kinds of db errors in a lot of mods. I don't know why with this upgrade there was such an issue, but after raising that, no more db errors at all, just like before 4.1.9. I hate upgrading due to all the problems it causes. Had I not installed vbseo and checked their specs, I would have never known. I had everything I needed except that one setting needing to be raised slightly. I don't know if I would have had ever figured it out with those specs though. It sure had me going nuts for awhile. I was not at all used to db errors. I am now db error free again and kept my mods too.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01087 seconds
  • Memory Usage 1,766KB
  • 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_code
  • (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