The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
||||
|
||||
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. |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|