Link Checker Bot for vBulletin
- Thread starter Rated_R
- Start date
i get this error
Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT forumid,firstpostid,threadid FROM thread WHERE forumid =4 OR forumid = 5 OR forumid = 6 OR forumid = 7 OR forumid = 8 OR forumid = 9 OR forumid = 10 OR forumid = 11 OR forumid =;
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 1
Error Number : 1064
Request Date : Monday, November 10th 2008 @ 07:18:22 PM
Error Date : Monday, November 10th 2008 @ 07:18:22 PM
Script : http://d34dlywar3z.com/admincp/cronadmin.php?do=runcron&cronid=19
Referrer : http://d34dlywar3z.com/admincp/cronadmin.php?do=modify
IP Address : 78.147.32.52
Username : saif1311
Classname : vB_Database
MySQL Version : 5.0.51a-communityHej I get an error email of vb when im enable the schedule task;
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT forumid,firstpostid,threadid FROM vbthread WHERE forumid =;
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 1
Error Number : 1064
Request Date : Saturday, November 15th 2008 @ 05:36:04 AM
Error Date : Saturday, November 15th 2008 @ 05:36:04 AM
Script : http://soulsuite.us/cron.php?rand=1226748961
Referrer : Ame 2.0 - vBTEAM Underground
IP Address : 77.21.251.189
Username : Unregistered
Classname : vB_Database
MySQL Version :
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT forumid,firstpostid,threadid FROM vbthread WHERE forumid =;
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 1
Error Number : 1064
Request Date : Saturday, November 15th 2008 @ 05:36:04 AM
Error Date : Saturday, November 15th 2008 @ 05:36:04 AM
Script : http://soulsuite.us/cron.php?rand=1226748961
Referrer : Ame 2.0 - vBTEAM Underground
IP Address : 77.21.251.189
Username : Unregistered
Classname : vB_Database
MySQL Version :
SCARFACE_vbulletin3_import6818
New Member
lol guys you might wanna remove your IP Address from the post. btw im using this bot vBulletin 3.7.4 works great no trouble at all thank you!
great thanks got it running but its not removing dead links or anything i get no errors it runs gives successfully ran message yet dead link posts are still there 
EDIT nm its working its just being a picky SOB it worked in one forum not another... maybe because it has subforums..
EDIT nm its working its just being a picky SOB it worked in one forum not another... maybe because it has subforums..
SCARFACE_vbulletin3_import6818
New Member
Vhero said:great thanks got it running but its not removing dead links or anything i get no errors it runs gives successfully ran message yet dead link posts are still there
EDIT nm its working its just being a picky SOB it worked in one forum not another... maybe because it has subforums..
You have to set which categories it checks you can change the settings by going to
Admincp --> vBulletin options --> Link Checker Bot (down the bottom)
set which forums you want i to check under "ID's of forums to check". to get the id of a forum put your mouse cursor over a category and at the end it will have a 2 digit number example 48 or 72 etc... that's your forum ID. after you have finished setting that, if you haven't already it should check all the forums you permit it to
its working great on my forum no trouble (vBulletin 3.7.4).This is the worst mod i've seen for vBulletin. I installed it, had no errors, and when i launched it, it started binning the "LIVE LINKS" to trash... even if i disabled it or deleted profile, its still was binning the live topics. So to get rid of it i had to launch some SQL queries... Mad chit..
the_shadow
New Member
it's possible make this work in subforuns????
xblade_2k9
New Member
rundll32 said:
yeah this mod have bugs