Log message #4203464

# At Username Text
# Sep 17th 2019, 08:59 johnwayne Morning to all, I have weird problem with Session timeout. Only one customer getting Error message from Auth `You are not authorized to access that location.` and I have increase Session timeout to 43200 and session.cookie_lifetime is to 86400. What can be the problem or how can I prevent this?
# Sep 17th 2019, 08:39 challgren Haha, half the crap it doesn’t I dont even know what voodoo is behind the scenes
# Sep 17th 2019, 08:38 dereuromark Make one :slightly_smiling_face:
# Sep 17th 2019, 08:34 challgren I wish Cake had a tableau plugin
# Sep 17th 2019, 07:50 neon1024 Hey everyone :sunrise:
# Sep 17th 2019, 07:20 alexdd55976 morning
# Sep 17th 2019, 06:53 javier.villanueva morning all
# Sep 17th 2019, 05:25 maymeow thank you ill look at it
# Sep 16th 2019, 22:23 rightscoreanalysis when I specify a custom url in my form I get the CSFR alert, how can I use a custom url and CSFR together?
# Sep 16th 2019, 21:49 rightscoreanalysis can i patch the entity before the rendering the form back to Admin?
# Sep 16th 2019, 21:48 rightscoreanalysis after the file is read I copy the contents into an array which I then want to render in a form, alllowing the admin to make an alterations before saving
# Sep 16th 2019, 21:47 rightscoreanalysis I have a form with file upload field. This allows admin to import a text file which contains data to be saved to my Model
# Sep 16th 2019, 20:32 dereuromark @felipe.marinho You gather the necessary data, and let it do the rest in the background. for this usually just the id of the db row is needed, the entity etc.
# Sep 16th 2019, 20:31 challgren Or straight up `fgetcsv()`
# Sep 16th 2019, 20:29 challgren @felipe.marinho you can use https://github.com/ProLoser/CakePHP-CSV
# Sep 16th 2019, 20:29 felipe.marinho @dereuromark I'll definitely try it... just don't know how to relate the columns but, it's OK :slightly_smiling_face: thank you guys.
# Sep 16th 2019, 20:28 challgren Plugin makes a good plugin!
# Sep 16th 2019, 20:19 dereuromark https://github.com/dereuromark/cakephp-queue is the most simple one and what we use for this
# Sep 16th 2019, 20:15 felipe.marinho I never created any code in PHP to run as a background task, just some exec commands... I'll try to restructure it.
# Sep 16th 2019, 20:12 felipe.marinho I need to relate, CSV columns with table columns, and that was the only way for me to solve this...
# Sep 16th 2019, 20:09 ndm Why would you even try to get that working? Processing 500k records is clearly a job for a background task.
# Sep 16th 2019, 20:06 jotpe Not sure about this :man-shrugging:
# Sep 16th 2019, 20:04 felipe.marinho But the problem is that PHP is blocking I/O when is processing data (monothread) the way we normally work, right?
# Sep 16th 2019, 19:59 jotpe To decouple the view a bit.
# Sep 16th 2019, 19:58 jotpe Maybe you could try something like build a view+json and after the file handling is finished, update the json to update the view?
# Sep 16th 2019, 19:53 felipe.marinho But there's no error, or fail, the browser go "empty_response" but in the backend the action still executing, until the end (and complete with success)
# Sep 16th 2019, 19:52 jotpe Maybe try catch and resolve the exception?
# Sep 16th 2019, 19:51 ricksaccous anyway i have a meeting, good luck
# Sep 16th 2019, 19:51 ricksaccous @felipe.marinho you're probably timing out, you want to chunk it out into jobs
# Sep 16th 2019, 19:51 jotpe :D
# Sep 16th 2019, 19:49 felipe.marinho It's an action that read a CSV with 500k lines and insert into the database lol
# Sep 16th 2019, 19:48 felipe.marinho This is my code: https://pastebin.com/ueqYpSG3
# Sep 16th 2019, 19:47 ricksaccous this might be more of a jquery/js question btw
# Sep 16th 2019, 19:47 ricksaccous where is the code you are using to execute the action?
# Sep 16th 2019, 19:47 ricksaccous how often are you executing the action?
# Sep 16th 2019, 19:46 ricksaccous how are you executing the action?
# Sep 16th 2019, 19:46 felipe.marinho Has anyone had a problem like this?
# Sep 16th 2019, 19:43 ricksaccous I've got enough juice for another hour and a half actually which is pretty much what I have to do
# Sep 16th 2019, 19:41 jotpe Oh damn :(
# Sep 16th 2019, 19:40 ricksaccous I'm feeling tired but unfortunately I have to chug a lug on for a while
# Sep 16th 2019, 19:40 ricksaccous it's not good working when you're tired