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 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?
-
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 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.
-
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 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 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 :)
-
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 April 15th, 2010 @ 08:50 AM
- Assigned user changed from Guillermo Rauch to Ricardo Rauch
-
mariah9x October 14th, 2022 @ 05:53 AM
I've checked the setup and found no issues, but it wordle still doesn't work.
-
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 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 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 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.
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.