#68 new
roc3n

cron job problem

Reported by roc3n | July 23rd, 2008 @ 01:23 PM

hi there, i'm with the new rc 4-6 version but stil have problems with the campaign fetch. my server tme is ok but still have the "next campaigns to process: next!" message. pls help me! i want this plugin and im ready to pay for support. roc3n [at] freeinfo [dot] es

Comments and changes to this ticket

  • Guillermo Rauch

    Guillermo Rauch July 23rd, 2008 @ 01:30 PM

    You don't need to pay, it shouldn't be that hard to figure out.First of all,

    take the cron URL and put it in your browser. Does it work ? Do the

    campaigns get processed?

  • Rising Suns

    Rising Suns July 23rd, 2008 @ 09:38 PM

    What should the output of the cron URL be?

  • Guillermo Rauch

    Guillermo Rauch July 23rd, 2008 @ 10:05 PM

    A blank screen, and the campaigns should show the time you ran it as 'last

    active'.

  • roc3n

    roc3n July 24th, 2008 @ 01:19 PM

    "First of all,

    take the cron URL and put it in your browser. Does it work ? Do the

    campaigns get processed? "

    Yes it works. Here is the sapshot of my cron. For the minute tab i've used both 20 and */20 value.

  • Guillermo Rauch

    Guillermo Rauch July 24th, 2008 @ 01:30 PM

    Then check out your cron setup.

  • blacknet

    blacknet July 24th, 2008 @ 04:48 PM

    • Tag set to cron, mysql, sql, wp-o-matic

    had the same problem; here's the solution:

    PROBLEM

    =========================

    LINE: 960

    IN FUNCTION: getCampaigns()

    PROBLEM: INCORRECT SQL

    FIX:

    ============================

    REPLACE:

    $where .= " AND active = 1 AND (frequency + lastactive) < ". current_time('timestamp', true) . " ";

    WITH:

    $where .= " AND active = 1 AND DATE_ADD(lastactive, INTERVAL frequency SECOND) < NOW() ";

    That'll fix everybody right up :)

  • roc3n

    roc3n July 25th, 2008 @ 04:12 AM

    blacknet tnx, but my 970 line is a littke bit different

    $where .= " AND active = 1 AND (frequency + UNIX_TIMESTAMP(lastactive)) < ". (current_time('timestamp', true) - get_option('gmt_offset') * 3600) . " ";

    so i don't know if i have to change everything or leave

    get_option('gmt_offset') * 3600) . " ";

    tnx once again

  • blacknet

    blacknet July 25th, 2008 @ 09:40 AM

    you can still replace with:

    $where .= " AND active = 1 AND DATE_ADD(lastactive, INTERVAL frequency SECOND) < NOW() ";

    to get it working :)

  • blacknet

    blacknet July 25th, 2008 @ 09:40 AM

    +apologies i was on 3-7

  • roc3n

    roc3n July 26th, 2008 @ 01:28 AM

    ok, i have to apologise, the fault is mine. i solved it putting GET folowed by the cron url in the command line. i'm sorry Guillermo.

  • Ricardo Rauch

    Ricardo Rauch April 15th, 2010 @ 08:50 AM

    • Assigned user changed from “Guillermo Rauch” to “Ricardo Rauch”
  • mariah9x

    mariah9x October 14th, 2022 @ 05:53 AM

    I've checked the setup and found no issues, but it wordle still doesn't work.

  • celinedion

    celinedion October 19th, 2022 @ 11:53 PM

    Datafeedr hangs after each process and frequently skips cron without resuming. Still not mapquest driving directions working after cron reset.

  • lorde123

    lorde123 December 17th, 2022 @ 05:48 AM

    This guide will slope game walk you through locating cron jobs on your server, validating their schedules, and debugging common problems.

  • theodoreevans

    theodoreevans December 26th, 2022 @ 05:08 AM

    This is very interesting information! I've really enjoyed reading your points, and I think you're right about a lot of them. You are amazing. I should thank you for all the work you put into making this post fnaf

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

WP-o-Matic project.

Attachments

Pages