cron mail

[cheesegrits]

Do you use that function anywhere, like a prefilter?

Sent from my HTC One using Tapatalk

 

[coullet]

I have a pre filter on with date function, but not exactly the same...

SELECT id FROM eqds_planning_diffusion WHERE DATE_FORMAT(date_projection,'%Y-%m-%d')=DATE(NOW())

i don't find where the function is used...

 

[coullet]

But as you stay connected all night (?), i see that task now do the work...
I feel that the error is come when there is no record in list, and as list is based on a date filter, yesterday list is empty and today there is records.
(i say yesterday and today for me... )

 

[cheesegrits]

I'm at abit of a loss with that one. That's a PHP error message, happening because it's trying to use some SQL as a date. So obviously that DATE_FORMAT() is being generated as part of a query, and somehow getting spat out as a literal in the results data, which our code then tries to turn in to a PHP date.

But I can't find anywhere in our code where we do that DATE_FORMAT(NOW()...) construct. Do you have anywhere else you format a date as part of a query, maybe in a concat label, or calc result, or ...

-- hugh

 

[coullet]

I checked all calc/concat label on the list connected to the task...and no.
I've probably use this function somewhere, but without precision about list, it's difficult to find where...