GerstnerUSA
08-21-2013, 02:53 AM
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:\"dateline\";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.php?14-Work-With-All-The-Large-Pet-dogs-Strategies-Of-Professional-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:\"dateline\";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.php?12-How-To-Deal-With-Bleeding-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.
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:\"dateline\";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.php?14-Work-With-All-The-Large-Pet-dogs-Strategies-Of-Professional-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:\"dateline\";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.php?12-How-To-Deal-With-Bleeding-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.