Announcement

Collapse
No announcement yet.

Need Help - Scheduled Tasks Logs and Hourly Cleanup #2 Error Questions

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Need Help - Scheduled Tasks Logs and Hourly Cleanup #2 Error Questions

    I'm checking my scheduled tasks log and it seems as if a few tasks are not showing. Should they be?
    121538 vBa Links Directory Random Homepage Links 18:00, 5th Jan 2014
    121537 Subscriptions 18:00, 5th Jan 2014 Paid Subscriptions Updated
    121536 vBa Links Directory Search Cleanup 17:39, 5th Jan 2014
    121535 vBa Links Directory Random Homepage Links 17:00, 5th Jan 2014
    121534 vBa Links Directory Search Cleanup 16:39, 5th Jan 2014
    121533 vBa Links Directory Random Homepage Links 16:14, 5th Jan 2014
    121532 vBa Links Directory Random Homepage Links 16:14, 5th Jan 2014
    121531 vBa Links Directory Search Cleanup 16:13, 5th Jan 2014
    121530 vBa Links Directory Random Homepage Links 05:00, 5th Jan 2014
    121529 vBa Links Directory Search Cleanup 04:39, 5th Jan 2014
    121528 vBa Links Directory Random Homepage Links 04:00, 5th Jan 2014
    121527 vBa Links Directory Search Cleanup 03:39, 5th Jan 2014
    121526 vBa Links Directory Random Homepage Links 03:00, 5th Jan 2014
    121525 vBa Links Directory Search Cleanup 02:39, 5th Jan 2014
    121524 vBa Links Directory Random Homepage Links 02:00, 5th Jan 2014
    121523 vBa Links Directory Search Cleanup 01:39, 5th Jan 2014
    121522 Activation Reminder Email 01:03, 5th Jan 2014 Activation Reminder Emails sent to: zaluexoinverts, Trickynick, Haroldpi
    121521 Daily Digest 01:02, 5th Jan 2014 Daily Digest Sent
    121520 Birthdays 01:01, 5th Jan 2014 Birthday Email Sent to: Pinktoes, Blue_Blood, CoffinDancer, peaceodarock, snaily, aambumann, teejay, Snuggles, electricman, shippetto, creepycrawl, davido6465, baltolizard, Jenthevet, rcarr, monksbugs, rooster & hen, tonya, katrina1977, RAQUEL5016, morningshadow, RugbyDave, Slater, argon1199, Berta, TheShel, TexasTreeViper, nslay, SxOne, bobbybushay, Christofear, rosco1585, Curious jay, JDub, Arachnofobik, citylynx, Huntard, ToBeFrank1313, zyzsgy, Faithie, Billy 5ek, Jazz, giovanni, BPlover, IzzyLoo, MakinMuffins, K3nnith, WolfChild, LizVicious, Marrow, BosleyBugg, laura519, Anavaea, Paleofish, Websessed17, Jelllo, Eveco, JaimeJeffery, Stanny98
    121519 vBa Links Directory Random Homepage Links 01:00, 5th Jan 2014
    121518 vBa Links Directory Search Cleanup 00:39, 5th Jan 2014
    121517 vBa Links Directory Random Homepage Links 00:00, 5th Jan 2014
    121516 vBa Links Directory Search Cleanup 23:39, 4th Jan 2014
    121515 vBa Links Directory Random Homepage Links 23:00, 4th Jan 2014
    121514 vBa Links Directory Search Cleanup 22:39, 4th Jan 2014
    121513 vBa Links Directory Random Homepage Links 22:00, 4th Jan 2014
    121512 vBa Links Directory Search Cleanup 21:39, 4th Jan 2014
    121511 vBa Links Directory Random Homepage Links 21:00, 4th Jan 2014
    121510 vBa Links Directory Search Cleanup 20:39, 4th Jan 2014
    121509 PhotoPost vBGallery Ecard Cleanup 20:00, 4th Jan 2014
    121508 PhotoPost vBGallery Search Cleanup 20:00, 4th Jan 2014 vBGallery Search Cleanup
    121507 PhotoPost vBGallery Subscriptions 20:00, 4th Jan 2014 vBGallery Subscriptions Cleanup
    121506 vBa Links Directory Random Homepage Links 20:00, 4th Jan 2014
    121505 vBa Links Directory Search Cleanup 19:39, 4th Jan 2014
    121504 PhotoPost vBGallery Daily Statistics 19:05, 4th Jan 2014 PhotoPost vBGallery Stats Updated
    121503 vBa Links Directory Random Homepage Links 19:05, 4th Jan 2014
    121502 vBa Links Directory Subscriptions 19:04, 4th Jan 2014
    121501 vBa Links Directory Search Cleanup 18:54, 4th Jan 2014
    121500 vBa Links Directory Random Homepage Links 18:40, 4th Jan 2014
    121499 Subscriptions 18:38, 4th Jan 2014 Paid Subscriptions Updated
    121498 vBa Links Directory Search Cleanup 18:37, 4th Jan 2014
    121497 PhotoPost vBGallery Ecard Cleanup 17:48, 4th Jan 2014
    121496 PhotoPost vBGallery Search Cleanup 17:48, 4th Jan 2014 vBGallery Search Cleanup
    121495 PhotoPost vBGallery Subscriptions 17:48, 4th Jan 2014 vBGallery Subscriptions Cleanup
    121494 PhotoPost vBGallery Daily Statistics 17:47, 4th Jan 2014 PhotoPost vBGallery Stats Updated
    121493 vBa Links Directory Subscriptions 17:46, 4th Jan 2014
    121492 vBa Links Directory Random Homepage Links 17:34, 4th Jan 2014
    121491 vBa Links Directory Search Cleanup 17:33, 4th Jan 2014
    121490 Subscriptions 17:33, 4th Jan 2014 Paid Subscriptions Updated
    121489 Activation Reminder Email 15:42, 4th Jan 2014 Activation Reminder Emails sent to: ThedaMVWD, gabe2068, jehnzpttay5431, Haroldpi, JosephJam
    The reason I'm asking this is that I'm worried that the other standard tasks are not running, particularly the hourly cleanup tasks 1 & 2.

    If I run "hourly cleanup" it says done, but does not appear in the log

    If I run "hourly cleanup #2" I get the following DB error:

    Database error in vBulletin 4.1.5:

    Invalid SQL:
    (
    SELECT
    a.attachmentid, a.contenttypeid, a.displayorder
    FROM attachment AS a
    INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
    LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
    LEFT JOIN post AS post ON (post.postid = a.contentid)
    LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
    LEFT JOIN user AS user ON (a.userid = user.userid)
    WHERE
    a.contenttypeid = 1 AND
    (
    (
    a.contentid = 0
    AND
    a.userid = 1
    )
    OR
    (
    thread.forumid IN (0, 87, 42, 53, 28, 43, 61, 34, 35, 23, 20, 46, 54, 47, 29, 71, 63, 21, 79, 38, 39, 77, 78, 48, 64, 65, 66, 67, 50, 49, 72, 73, 2, 51, 1, 3, 4, 76, 12, 18, 31, 80, 81, 82, 74, 68, 75, 83, 84, 85, 30, 36, 6, 5, 88, 24, 27, 41, 62, 14, 40, 16, 17, 7, 8, 9, 45, 10, 11, 86, 37, 52, 22, 26, 59) AND (
    thread.forumid IN (0, 87, 42, 53, 28, 43, 61, 34, 35, 23, 20, 46, 54, 47, 29, 71, 63, 21, 79, 38, 39, 77, 78, 48, 64, 65, 66, 67, 50, 49, 72, 73, 2, 51, 1, 3, 4, 76, 12, 18, 31, 80, 81, 82, 74, 68, 75, 83, 84, 85, 30, 36, 6, 5, 88, 24, 27, 41, 62, 14, 40, 16, 17, 7, 8, 9, 45, 10, 11, 86, 37, 52, 22, 26, 59)
    OR
    thread.postuserid = 1
    ) AND (
    a.state <> 'moderation'
    OR
    a.userid = 1
    OR
    thread.forumid IN (0, 87, 42, 53, 28, 43, 61, 34, 35, 23, 20, 46, 54, 47, 29, 71, 63, 21, 79, 38, 39, 77, 78, 48, 64, 65, 66, 67, 50, 49, 72, 73, 2, 51, 1, 3, 4, 76, 12, 18, 31, 80, 81, 82, 74, 68, 75, 83, 84, 85, 30, 36, 6, 5, 88, 24, 27, 41, 62, 14, 40, 16, 17, 7, 8, 9, 45, 10, 11, 86, 37, 52, 22, 26, 59)
    ) AND (
    (
    post.visible = 1
    AND
    thread.visible = 1
    )
    OR
    (
    thread.forumid IN (0, 87, 42, 53, 28, 43, 61, 34, 35, 23, 20, 46, 54, 47, 29, 71, 63, 21, 79, 38, 39, 77, 78, 48, 64, 65, 66, 67, 50, 49, 72, 73, 2, 51, 1, 3, 4, 76, 12, 18, 31, 80, 81, 82, 74, 68, 75, 83, 84, 85, 30, 36, 6, 5, 88, 24, 27, 41, 62, 14, 40, 16, 17, 7, 8, 9, 45, 10, 11, 86, 37, 52, 22, 26, 59)
    )
    OR
    (
    thread.forumid IN (0, 87, 42, 53, 28, 43, 61, 34, 35, 23, 20, 46, 54, 47, 29, 71, 63, 21, 79, 38, 39, 77, 78, 48, 64, 65, 66, 67, 50, 49, 72, 73, 2, 51, 1, 3, 4, 76, 12, 18, 31, 80, 81, 82, 74, 68, 75, 83, 84, 85, 30, 36, 6, 5, 88, 24, 27, 41, 62, 14, 40, 16, 17, 7, 8, 9, 45, 10, 11, 86, 37, 52, 22, 26, 59)
    AND
    post.visible = 2
    AND
    thread.visible = 2
    )
    )
    )
    )
    AND a.attachmentid IN (edited- was a huge list of what I think is all the userid's on my forums)
    ) UNION ALL (
    SELECT
    a.attachmentid, a.contenttypeid, a.displayorder
    FROM attachment AS a
    INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
    LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
    INNER JOIN socialgroupmember AS sgm ON (sgm.userid = a.userid AND sgm.groupid = a.contentid AND sgm.type = 'member')
    INNER JOIN socialgroup AS sg ON (sg.groupid = a.contentid)
    LEFT JOIN user AS user ON (a.userid = user.userid)
    WHERE
    a.contenttypeid = 7 AND
    (
    (
    a.contentid = 0
    AND
    a.userid = 1
    )
    OR
    (
    sg.options & 8
    )
    )
    AND a.attachmentid IN (edited- was a huge list of what I think is all the userid's on my forums)
    ) UNION ALL (
    SELECT
    a.attachmentid, a.contenttypeid, a.displayorder
    FROM attachment AS a
    INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
    LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
    LEFT JOIN blog AS blog ON (a.contentid = blog.blogid)
    LEFT JOIN blog_user AS bu ON (bu.bloguserid = blog.userid)
    LEFT JOIN user AS user ON (user.userid = blog.userid)
    LEFT JOIN blog_groupmembership AS gm ON (blog.userid = gm.bloguserid AND gm.userid = 1)
    WHERE
    a.contenttypeid = 19 AND
    (
    (
    a.contentid = 0
    AND
    a.userid = 1
    )
    OR
    (
    a.contentid <> 0 AND
    (
    (
    blog.state <> 'draft'
    AND
    blog.pending = 0
    )
    OR
    blog.userid IN (1)
    )

    )
    )
    AND a.attachmentid IN (edited- was a huge list of what I think is all the userid's on my forums)
    ) UNION ALL (
    SELECT
    a.attachmentid, a.contenttypeid, a.displayorder
    FROM attachment AS a
    INNER JOIN filedata AS fd ON (a.filedataid = fd.filedataid)
    LEFT JOIN attachmenttype AS at ON (at.extension = fd.extension)
    LEFT JOIN cms_node AS node ON (a.contentid = node.nodeid)
    LEFT JOIN user AS user ON (user.userid = node.userid)
    WHERE
    a.contenttypeid = 24 AND
    (
    (
    a.contentid = 0
    AND
    a.userid = 1
    )
    OR
    (
    a.contentid <> 0
    )
    )
    AND a.attachmentid IN (edited- was a huge list of what I think is all the userid's on my forums)
    )
    ORDER BY displayorder DESC
    LIMIT 0, 25;

    MySQL Error : MySQL server has gone away
    Error Number : 2006
    Request Date : Sunday, January 5th 2014 @ 11:15:00 PM
    Error Date : Sunday, January 5th 2014 @ 11:15:02 PM
    Script : http://********/cronadmin.php?do=runcron&cronid=9
    Referrer : http://********/cronadmin.php?do=modify
    IP Address : 67.86.221.156
    Username : MrDeranged
    Classname : vB_Database
    MySQL Version :

    Any ideas on how I can fix this so that it can run?

    Regards


    Last edited by mrderanged; Sun 5 Jan '14, 2:38pm.

  • #2
    Only the tasks that have "Log Entries" set to Yes will show in the Scheduled Task Log. And, if the task errors out, then it won't be logged either (as you noted about Hourly Cleanup #2).

    "MySQL Server has gone away" is a server issue. See this: https://www.vbulletin.com/docs/html/...mysql_goneaway and this: https://www.vbulletin.com/forum/show...265#post310265 You will need to talk to your host about this in order to get it resolved.

    Please don't PM or VM me for support - I only help out in the threads.
    vBulletin Manual & vBulletin 4.0 Code Documentation (API)
    Want help modifying your vbulletin forum? Head on over to vbulletin.org
    If I post CSS and you don't know where it goes, throw it into the additional.css template.

    W3Schools &lt;- awesome site for html/css help

    Comment


    • #3
      Thanks Lynne. I'll speak to them

      Comment


      • #4
        Originally posted by mrderanged View Post
        Thanks Lynne. I'll speak to them
        Hmm I believe since you're running on 4.1.5 instead of a newer version that yes despite the MYSQL server gone away error it *could* possibly be timing out due to the sheer # of attachments it's parsing during the cron query, before the timeout occured it had already checked 192972 attachments per the logs, it was stopped short due to the timeout though so you're aware.

        References:
        http://www.vbulletin.com/forum/forum...=1388968851469
        http://tracker.vbulletin.com/browse/VBIV-6994

        I'm working with Basil on this to see if we can sort this, just a few minutes ago I uploaded but did not use an attachment, in roughly one hour I will check to see if the cron job ran and during said time was the unused attachment actually deleted - If it was then your forum is not suffering from the bug, if it was not deleted then it is in fact related to VBIV-6994 and upgrading to 4.1.10 or higher should alleviate the issue for you but we shall see!


        Former vBulletin Support Staff
        Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
        Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

        Comment


        • #5
          It has been almost 2 hours since attachment was uploaded but not used, the cron script hourly2 has ran per log and the attachment remains so therefor I'm going with it's a BUG, more specifically http://tracker.vbulletin.com/browse/VBIV-6994 since the attachment remains.


          Former vBulletin Support Staff
          Hacked recently? See my blog post "Recovering a Hacked vBulletin Site".
          Thinking outside the box? Need modification support? Visit www.vBulletin.org and have at it!

          Comment

          Related Topics

          Collapse

          Working...
          X