Thread: Administrative and Maintenance Tools - vbStopForumSpam - known spammer lookup for new registrations
View Single Post
  #721  
Old 11-02-2009, 07:48 AM
pedigree pedigree is offline
 
Join Date: Jul 2005
Posts: 370
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

REPLACE INTO datastore
(title, data, unserialize)
VALUES
('options',

This isnt SQL that my Mod uses.

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes

This is a mySQL database error. mysql is given more data that it can handle. Try installing/uninstalling it. The mod doesnt really make that much in the way of database changes.

This is the database uninstall

DROP TABLE IF EXISTS`".TABLE_PREFIX."vbstopforumspam`
DROP TABLE IF EXISTS`".TABLE_PREFIX."vbstopforumspam_log`
DROP TABLE IF EXISTS`".TABLE_PREFIX."vbstopforumspam_remotecache `
ALTER TABLE " . TABLE_PREFIX . "usergroup DROP vbstopforumspamviewpermissions
ALTER TABLE " . TABLE_PREFIX . "usergroup DROP vbstopforumspamsubmitpermissions

And delete the vbstopforumspam hooks for register_addmember_process and register_addmember_complete

And why it happened, no idea im afraid. There looks like there is underlying mysql database issues on your server. If you really really need, and you have phpymadmin, PM me and Ill see if I can uninstall it for you, althought Im not convinced my mod killed your forum. It looks like vbulletin has stopped with an error of its own, when trying to uninstall something

in vb_databstore, there are two rows that my mod appears in. This IS a vbulletin table, not one of mine -products & plugins. I would reinstall/unnistalling/reinstalling/uninstalling as vbulletin has choked here.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01039 seconds
  • Memory Usage 1,762KB
  • 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