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

I did a dry run of installing VBStopforumspam on a test install of vbulletin v 3.8.4. The test install worked fine, no problems.

Then I followed the same steps on the live system. A database error was reported by vb.
Specifically
Database error in vBulletin 3.8.4:

Invalid SQL:

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

This was followed by all the replace values.

Now when I go into vb options and try to shut down the forum.. I get the same db error. I then uninstalled the VBStopForumSpam mod . The system threw another db error (same as above) however looking at the installed products list, the mod is not listed any more. So part of the uninstall worked.

The log files were never listed on the production server. They were listed on the test server after the install.

It looks like the original install only partially completed.

At the bottom of the log entry it reads:

MySQL Error : Got a packet bigger than 'max_allowed_packet' bytes
Error Number : 1153
Request Date : Sunday, November 1st 2009 @ 10:24:32 PM
Error Date : Sunday, November 1st 2009 @ 10:24:34 PM
Script : http://myforum.com/eZ563/plugin.php?do=productimport
Referrer : http://myforum.com/eZ563/plugin.php?do=productadd


Any suggestions how might back out of this gracefully? Also, any idea as to why this may have happened?

Thank you
CM
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01121 seconds
  • Memory Usage 1,764KB
  • 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