Link Checker Bot for vBulletin

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-community
 
Hej 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 :
 
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..
 
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..
Click to expand...

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..
 
i got this when posting
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/class_postbit.php on line 1149

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/includes/class_postbit.php on line 308
Click to expand...
 
ya, ther are no good LCB's yet... dont be in a hurry to install 1.
i checked 4 LCB's on my offline board, and all 4 LCBs binned all live links...

So dont be in a hurry to get one =/
 
plz can anyone guide to execute a sql query . What to replace with PREFIX_. plz really need some help.

thankx
 
umm this thing wont stop, ive deleted everything that goes to it including the tables in the database and it still moving stuff to the trash. even deleted the user it was made into and its still going
 
You must log in or register to reply here.
Back
Top