Log message #3977757

# At Username Text
# Jan 23rd 2017, 01:11 BackEndCoder some pages will work.. some 504, when i get one 504, everything 504's
# Jan 23rd 2017, 01:11 BackEndCoder i haven't checked one by one. but i copyed my vagrant install (which works) to get all the bits
# Jan 23rd 2017, 01:11 savant turn on verbose logging in php?
# Jan 23rd 2017, 01:10 savant are you sure you have all extensions enabled
# Jan 23rd 2017, 01:10 BackEndCoder so i bumpped up mysql and php memories... but it still 504's
# Jan 23rd 2017, 01:10 savant 504 service unavailable
# 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