Originally Posted by Devanand (Post 2054480) I have some problems. First when I run cron it skip lot of posts with links. It check maybe every 7 or 8 posts even I have links in every posts in that forum. Another thing is mysql error I am geting after some time of checking: PHP Code: Database error in vBulletin 3.8.5: Invalid SQL:                         UPDATE post SET                             phpkd_vblvb = 'a:2:{s:4:"move";a:2:{s:6:"orifid";i:153;s:7:"destfid";i:28;}s:8:"dateline";i:1276693397;}'                         WHERE postid = 199424                             AND userid = 38916; MySQL Error   : Unknown column 'phpkd_vblvb' in 'field list' Error Number  : 1054 Request Date  : Wednesday, June 16th 2010 @ 08:03:17 AM Error Date    : Wednesday, June 16th 2010 @ 08:07:03 AM Script        : .../admincp/cronadmin.php?do=runcron&cronid=75 Referrer      : .../admincp/cronadmin.php?do=modify IP Address    : ... Username      : ... Classname     : vB_Database_MySQLi MySQL Version : 5.1.46-log  Of course, I have latest version of product.

Originally Posted by tirol07 (Post 2080305) thanks for update ;)

Sneak peeks of the upcoming featured release -4.0.200-


Other screen shots can't be posted here due to their big size, but it's posted in our website.

Sneak peeks of the upcoming featured release -4.0.200- Pack #2

Well, today's screen shots will be one of the most important developments done for our product "vB Link Verifier Bot" version 4.0.200. It's 'Host Manager', with this managing area you've the ability to fully control all supported hosts, enable, disable, edit, delete and even add new ones. Not to mention how much hosts is currently supported by default! I'll not describe it in more details now, just give it a look yourself. It's one of the most great things in the upcoming featured release -if not the greatest- and I'm sure you'll like it.

Attachment 123595

Attachment 123596 Attachment 123597

Attachment 123598 Attachment 123599

Attachment 123600 Attachment 123601

Cool enough!? It's not all the new staff we've for our new release ;), there's still many more things!! Keep tuned!!

Other screen shots can't be posted here due to their big size, but it's posted in our website.

---

Database error in vBulletin 3.8.6:

Invalid SQL:

                SELECT user.username, post.userid, post.postid, post.threadid, post.title, post.pagetext, thread.forumid, thread.title AS threadtitle
                FROM post AS post
                LEFT JOIN user AS user ON (post.userid = user.userid)
                LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
                Where thread.open = 1
                        AND thread.visible = 1
                        AND post.visible = 1
                        AND thread.forumid NOT IN (30,131)
                        AND post.dateline > 1290346866
                        AND thread.forumid NOT IN (6,8,10,18,21,24,25,28,30,40,46,49,53,57,61,65,67,68,73,76,82,85,86,89,90,91,99,100,109,116,130,131,157,159,162,167,168,169,)
                        AND post.postid = thread.firstpostid
                        AND post.phpkd_vblvb_lastcheck < 1289914866
                        LIMIT 50;

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 ')
                        AND post.postid = thread.firstpostid
                        AND post.phpkd_vblvb_lastcheck < 12' at line 10 Error Number  : 1064 Request Date  : Friday, November 26th 2010 @ 04:41:06 PM
Error Date    : Friday, November 26th 2010 @ 04:41:06 PM
Script        : http://forum.com/cron.php?rand=1290778865
Referrer      : http://forum.com/showthread.php?p=6854
IP Address    :
Username      : Unregistered
Classname    : vB_Database
MySQL Version :

---

Originally Posted by fxwoody (Post 2125963) WOW! I installed it 2 days ago and woke up with 126 of these this morning! Any idea why pls Not 100% comfy with this new plugin...as you will tell me i hope loll HTML Code: Database error in vBulletin 3.8.6: Invalid SQL:                 SELECT user.username, post.userid, post.postid, post.threadid, post.title, post.pagetext, thread.forumid, thread.title AS threadtitle                 FROM post AS post                 LEFT JOIN user AS user ON (post.userid = user.userid)                 LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)                 Where thread.open = 1                         AND thread.visible = 1                         AND post.visible = 1                         AND thread.forumid NOT IN (30,131)                         AND post.dateline > 1290346866                         AND thread.forumid NOT IN (6,8,10,18,21,24,25,28,30,40,46,49,53,57,61,65,67,68,73,76,82,85,86,89,90,91,99,100,109,116,130,131,157,159,162,167,168,169,)                         AND post.postid = thread.firstpostid                         AND post.phpkd_vblvb_lastcheck < 1289914866                         LIMIT 50; 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 ')                         AND post.postid = thread.firstpostid                         AND post.phpkd_vblvb_lastcheck < 12' at line 10 Error Number  : 1064 Request Date  : Friday, November 26th 2010 @ 04:41:06 PM Error Date    : Friday, November 26th 2010 @ 04:41:06 PM Script        : http://forum.com/cron.php?rand=1290778865 Referrer      : http://forum.com/showthread.php?p=6854 IP Address    : Username      : Unregistered Classname    : vB_Database MySQL Version : ***EDITED**** 1: I found a writing error in the XML file: TEMORARY DOWN >>>> "Temporary Down" should be wrote instead ;) 2: I removed the ',' at the end of my "excluded forum" and seem to have fix the problem of SQL error. but i did a "run" and it found a few post that the links are suppose to be dead and they're not? Why? I also didn't received any PM about it. I think i'm lost lolllll cheers