Thread: Administrative and Maintenance Tools - Miserable Users
View Single Post
  #91  
Old 08-30-2009, 04:20 PM
mdawg's Avatar
mdawg mdawg is offline
 
Join Date: Mar 2009
Location: United States
Posts: 363
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Adding on to the SQL database errors noted by others above, ones in which the punch line is "MySQL Error : MySQL server has gone away," I do believe that most of these have to do with the MU hack. But, isn't this what the MU modification is supposed to do? Delay response?

I have this one particular spammer I MU'ed who is particularly determined to get back on my forums. Or maybe he doesn't even realize he has been MU'ed and just thinks this is the way it is!

Anyway, the errors typically read like this:

Database error in vBulletin 3.8.4:

Invalid SQL:

SELECT forumid, moderatorid, permissions, permissions2
FROM moderator
WHERE userid = 313 AND forumid != -1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Tuesday, August 25th 2009 @ 05:38:44 PM
Error Date : Tuesday, August 25th 2009 @ 05:39:15 PM
Script : http://www.XXXYYYXXX.com/forums/
Referrer : http://www.XXXYYYXXX.com/index.php
IP Address : 95.XXX.X.XX
Username : _________
Classname : vB_Database
MySQL Version :


Where the username: ____________ is the user I MU'ed.

(By the way...just FYI, through these database errors I have noticed that the culprit logs on with different (but very similar) IP addresses. So, banning an IP address is not an effective means to keep away a determined spammer.)

But the odd thing is...I am also occasionally getting these database errors for unregistered users:

Invalid SQL:

INSERT INTO cronlog
(varname, dateline, description, type)
VALUES
('vbseo_sitemap_task',
1251271198,
'Google Sitemap Created',
0);

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Wednesday, August 26th 2009 @ 02:19:58 AM
Error Date : Wednesday, August 26th 2009 @ 02:22:24 AM
Script : http://www.XXXYYYXXX.com/forums/cron...and=1251271196
Referrer : http://www.XXXYYYXXX.com/forums/XX-d...ns/___________
IP Address : 97.XX.XXX.XX
Username : Unregistered
Classname : vB_Database
MySQL Version :


And wonder if these cron errors also have to do with this MU add on.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01043 seconds
  • Memory Usage 1,769KB
  • 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