Log message #3940477

# At Username Text
# Sep 29th 2016, 19:27 harry1 */30 * * * * cd /mnt/cake2/app/ andand Console/cake my_job
# Sep 29th 2016, 19:26 harry1 Leonardo_0112: yes so in your cron tab you have something like
# Sep 29th 2016, 19:09 Leonardo_0112 harry1: probably yes. Am I in the right way? http://book.cakephp.org/2.0/en/console-and-shells.html
# Sep 29th 2016, 19:08 harry1 http://book.cakephp.org/2.0/en/console-and-shells.html
# Sep 29th 2016, 19:08 harry1 Leonardo_0112: probably a cron job?
# Sep 29th 2016, 18:50 Leonardo_0112 Hi guys! I'm working in a cakephp2 project and i need to automatically generate a .csv file based on database records. The csv file is already been generated by controller/model when I access a URL. What is the best way to make it run automaticaaly every day, for instance.
# Sep 29th 2016, 17:37 admad ;)
# Sep 29th 2016, 17:36 noibilism @admad: i got itâ?¦.thanksâ?¦.some validation rules were violated
# Sep 29th 2016, 17:32 slackebot ~tell noibilism about gist
# Sep 29th 2016, 17:32 slackebot Command sent from Slack by admad:
# Sep 29th 2016, 17:32 admad show the output of `debug($entities) before passing to saveMany()
# Sep 29th 2016, 17:31 noibilism @admad itâ??s not saving the data
# Sep 29th 2016, 17:31 noibilism itâ??s not saving the data
# Sep 29th 2016, 17:30 admad @noibilism Why do you think you are doing something wrong?
# Sep 29th 2016, 17:29 hmic additionally you can use a queue to process the data more easily *and* run multiple processes at once, which is a huge gain as your machine likely has more than one core
# Sep 29th 2016, 17:28 hmic still: split the qery up. your data will grow and memory will be exhausted at some point
# Sep 29th 2016, 17:27 hmic because theres no memory limit on the command line in the default configuration of php on debian or ubuntu
# Sep 29th 2016, 17:27 rudy1976s so I was thinking of a memory issue
# Sep 29th 2016, 17:27 rudy1976s but the same query on command line has no problem
# Sep 29th 2016, 17:26 rudy1976s I know I solved that way
# Sep 29th 2016, 17:25 hmic rudy1976s: the answer is simple: too much! process the query in smaller chunks
# Sep 29th 2016, 17:24 rudy1976s Hello , what is the memory needed to run a query which will process around 100k of records with 150k of records related with hasMany? I am facing problems with memory exhaust error, although I have already set ->bufferResults(false)
# Sep 29th 2016, 17:16 noibilism hello guysâ?¦i am having issues using the saveMany cakephp function
# Sep 29th 2016, 17:15 hmic Neon1024, he's just joking with me
# Sep 29th 2016, 17:15 admad cya, have a good night's sleep :slightly_smiling_face:
# Sep 29th 2016, 17:15 hmic admad: he's from the country that invented the bse disease :p
# Sep 29th 2016, 17:15 Neon1024 Later
# Sep 29th 2016, 17:15 Neon1024 But your sarcasm is enough to send me home
# Sep 29th 2016, 17:15 admad then what's your excuse for asking stupid question? :P
# Sep 29th 2016, 17:15 Neon1024 My excuse is that itâ??s 18:13, and Iâ??ve been at my desk for 10 hours
# Sep 29th 2016, 17:14 Neon1024 No, I haven't
# Sep 29th 2016, 17:14 Neon1024 Why?
# Sep 29th 2016, 17:14 admad Neon1024: have you also been working with js lately?
# Sep 29th 2016, 17:14 Neon1024 Or perhaps not as itâ??s not an entity yet
# Sep 29th 2016, 17:13 Neon1024 ->select(â??first_nameâ??, â??last_nameâ??, â??mutatorFullNameâ??)
# Sep 29th 2016, 17:13 Neon1024 You can select a mutator in a query right?
# Sep 29th 2016, 17:09 admad do it! now!
# Sep 29th 2016, 17:07 hmic admad: you mean decreasing numbers from memory? - same happens to my money all the time. i should stop that js shit immediately!
# Sep 29th 2016, 17:05 hmic prepender, http://book.cakephp.org/3.0/en/core-libraries/collections.html#Cake\Collection\Collection::groupBy
# Sep 29th 2016, 17:04 admad yup too much js can do that to you, the symptoms fit
# Sep 29th 2016, 17:04 prepender hmic: im not following