#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

  • johanbug

    johanbug September 6th, 2024 @ 11:33 PM

    Thank you for your kind words! I'm glad you enjoyed the content and found it insightful. If you're interested in more engaging topics, consider checking out Monkey Mart for additional exciting updates. Your appreciation motivates me to keep sharing valuable information.

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