| # |
Jan 23rd 2017, 01:10 |
BackEndCoder |
turning off mysql makes it error out about mysql not being there.. that was a lot better than a 504 |
| # |
Jan 23rd 2017, 01:10 |
BackEndCoder |
tried that.. (its empty on a fresh clone) |
| # |
Jan 23rd 2017, 01:09 |
savant |
try clearing your app cache |
| # |
Jan 23rd 2017, 01:09 |
savant |
ummm |
| # |
Jan 23rd 2017, 01:09 |
savant |
lol |
| # |
Jan 23rd 2017, 01:09 |
BackEndCoder |
i'm trying to keep it as default as possible. but i have no error logs and a sadface |
| # |
Jan 23rd 2017, 01:08 |
BackEndCoder |
i just haven't talked in a while outloud |
| # |
Jan 23rd 2017, 01:08 |
BackEndCoder |
nope :( |
| # |
Jan 23rd 2017, 01:08 |
savant |
lol |
| # |
Jan 23rd 2017, 01:08 |
savant |
uh are you drunk, BackEndCoder? |
| # |
Jan 23rd 2017, 01:07 |
BackEndCoder |
any helpful hints for cake persivic issues on moving, or lemp set up causing lots of 504's |
| # |
Jan 23rd 2017, 01:06 |
BackEndCoder |
all over the place.. makes the box looks like i just dropped my money in the bin |
| # |
Jan 23rd 2017, 01:06 |
BackEndCoder |
i'm getting 504's in unpredicted places |
| # |
Jan 23rd 2017, 01:06 |
BackEndCoder |
move everything over... looks like a normal vargrant install |
| # |
Jan 23rd 2017, 01:06 |
BackEndCoder |
was using a production box for a long time.. just upgraded to something a bit bigger |
| # |
Jan 23rd 2017, 01:05 |
BackEndCoder |
i erm... i have been using vagrant a lot... always cloneing and moving things about in git |
| # |
Jan 23rd 2017, 01:05 |
BackEndCoder |
*guys |
| # |
Jan 23rd 2017, 01:05 |
BackEndCoder |
sup giys |
| # |
Jan 23rd 2017, 00:56 |
 mdotobie |
You’re a genius. That’s exactly what it was. Now to figure out why the discrepancy in the timestamps. |
| # |
Jan 23rd 2017, 00:49 |
mdotobie |
that might be exactly what it is |
| # |
Jan 23rd 2017, 00:49 |
mdotobie |
let me try that. thanks for pointing me in the right direction |
| # |
Jan 23rd 2017, 00:49 |
mdotobie |
that’s a good idea |
| # |
Jan 23rd 2017, 00:49 |
dereuromark |
anyway, gotto go to bed, good luck |
| # |
Jan 23rd 2017, 00:49 |
dereuromark |
you could try passing an actual datetime value instead to test |
| # |
Jan 23rd 2017, 00:48 |
dereuromark |
could it be the NOW() and timezone issues? |
| # |
Jan 23rd 2017, 00:48 |
dereuromark |
as it just askes SQL to give data back |
| # |
Jan 23rd 2017, 00:47 |
dereuromark |
that doesnt make much sense to me |
| # |
Jan 23rd 2017, 00:47 |
mdotobie |
just doesn’t behave correctly in Cake |
| # |
Jan 23rd 2017, 00:47 |
mdotobie |
it does |
| # |
Jan 23rd 2017, 00:47 |
dereuromark |
does it behave the same as your desired query? |
| # |
Jan 23rd 2017, 00:47 |
mdotobie |
yep |
| # |
Jan 23rd 2017, 00:47 |
dereuromark |
did you run the generated query in your sql tool? |
| # |
Jan 23rd 2017, 00:46 |
mdotobie |
but CakePHP pulls it in even before the interval has elapsed |
| # |
Jan 23rd 2017, 00:46 |
mdotobie |
interval_seconds is set to 300 (5min) and in Querious this line is excluded from the results as expected |
| # |
Jan 23rd 2017, 00:45 |
mdotobie |
thats probably the most vital line. right now I have a test task that has a completed datetime stamp less than the time that needs to elapse in the interval_seconds field |
| # |
Jan 23rd 2017, 00:44 |
mdotobie |
`'interval_seconds =' => $tasks->func()->TIMESTAMPDIFF([ 'SECOND' => 'literal' , 'completed' => 'identifier' , 'NOW()' = 'literal' ])` |
| # |
Jan 23rd 2017, 00:44 |
mdotobie |
and when I run it against the DB (I use Querious) it works as expected |
| # |
Jan 23rd 2017, 00:44 |
mdotobie |
yes. and the generated SQL is correct |
| # |
Jan 23rd 2017, 00:44 |
dereuromark |
most likely there is an isue with your AND/OR |
| # |
Jan 23rd 2017, 00:43 |
dereuromark |
I see. as to your query, did you compare the generated and the desired sql query? |
| # |
Jan 23rd 2017, 00:43 |
mdotobie |
at this point I should probably continue down the path I’m on because its tightly integrated to the task. but I definitely like your plugin for some other projects I’ve got going |