View Single Post
  #1  
Old 08-21-2013, 02:53 AM
GerstnerUSA's Avatar
GerstnerUSA GerstnerUSA is offline
 
Join Date: Mar 2013
Posts: 8
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How to remove blog post from a deleted user

I found 2 blog posts today on my forum that appear to be from deleted users. I found the blog posts when i did a search on my forum.

After trying to view the blog posts, i received the following e-mails.

First Database Error e-mail:


Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE blog_user SET
tagcloud = 'a:3:{s:4:\"tags\";a:0:{}s:5:\"count\";i:0;s:8:\"d ateline\";i:1377031170;}'
WHERE bloguserid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number : 1064
Request Date : Tuesday, August 20th 2013 @ 04:39:30 PM
Error Date : Tuesday, August 20th 2013 @ 04:39:30 PM
Script : http://forum.gerstnerusa.com/entry.p...-Forex-Trading
Referrer : http://forum.gerstnerusa.com/search.php?searchid=4593
IP Address : 69.48.57.42
Username : Scott Campbell
Classname : vB_Database_MySQLi
MySQL Version : 5.1.68-cll


Second Database Error is:


Database error in vBulletin 4.2.0:

Invalid SQL:
UPDATE blog_user SET
tagcloud = 'a:3:{s:4:\"tags\";a:0:{}s:5:\"count\";i:0;s:8:\"d ateline\";i:1377032146;}'
WHERE bloguserid =;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
Error Number : 1064
Request Date : Tuesday, August 20th 2013 @ 04:55:46 PM
Error Date : Tuesday, August 20th 2013 @ 04:55:46 PM
Script : http://forum.gerstnerusa.com/entry.p...ng-Hemmorhoids
Referrer : http://forum.gerstnerusa.com/search.php?searchid=4597
IP Address : 69.48.57.42
Username : Scott Campbell
Classname : vB_Database_MySQLi
MySQL Version : 5.1.68-cll


I had someone else from the vbulletin forum that helped setup some mods to eliminate spammers, and they went through and cleaned up my forum, but they might have missed the blog entries.

My question is how do i remove the blog entries since the users have been deleted?

Thank you for your time.
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01188 seconds
  • Memory Usage 1,767KB
  • 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