Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 General Discussions
  #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
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:01 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03276 seconds
  • Memory Usage 2,155KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)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
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • 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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete