Log message #3943164

# At Username Text
# Oct 6th 2016, 10:17 ndm @dereuromark That most likely depends on what exactly the query is supposed to retrieve, further aggregates, subqueries, adding the column to the group, etc, there are many ways... Someone may correct me, as I'm noch that much of an SQL expert, but AFAIK such errors usually occur when it's not possible to tell from which row in the group a column should be selected, for example if you select `a` and `b`, and group by `b`, which matches 3 rows per
# Oct 6th 2016, 10:17 acosonic oh it needs utility class
# Oct 6th 2016, 10:17 acosonic so I need App::Import... ?
# Oct 6th 2016, 10:16 hmic to your question: is XML a controller? - i doubt it...
# Oct 6th 2016, 10:15 hmic acosonic, why dont you update that ancient cakephp version?
# Oct 6th 2016, 10:13 acosonic hi all, why do I get class XML not found... ? Cakephp 2.4 https://gist.github.com/acosonic/001beb5f5fcea0096034569afb122c66
# Oct 6th 2016, 10:12 Human_G33k dereuromark , with the last script cakephp (after a bake all users/groups ) can't find the user_id column when i try to add a user. https://paste.debian.net/857777/ it's a bug or it's just me doing ugly things ?
# Oct 6th 2016, 10:04 Human_G33k i have a error in name user_id instead of user_uuid the new one. https://paste.debian.net/857773/ (the uuid in groups_users is useless)
# Oct 6th 2016, 10:00 dereuromark I wouldnt use char for varchar fields :slightly_smiling_face: I also wouldnt use uuid :P
# Oct 6th 2016, 09:59 Human_G33k dereuromark or somebody else do you think this sql create script is good ? https://paste.debian.net/857769/
# Oct 6th 2016, 09:58 rudy1976s I would spent efforts to create a robust script for deployment instead: we have around 1k virtualhosts to deploy to
# Oct 6th 2016, 09:56 rudy1976s to be honest i hate that idea too
# Oct 6th 2016, 09:54 dereuromark just try me and dont do it, dont even think about sharing files like this over apps, ever. always keep them separate when deploying.
# Oct 6th 2016, 09:53 dereuromark this is like the worst idea ever, and it already came up a few times already
# Oct 6th 2016, 09:53 dereuromark rudy: not you too :slightly_smiling_face:
# Oct 6th 2016, 09:53 rudy1976s Hello , Is there a clean way to have core cakephp3 files in a shared folder? we have plenty of instances to run and we would like to centralize the cake core. I read something googling but I am not sure the best way to approach
# Oct 6th 2016, 09:52 birdy247 in a BelongsToMany relationship, if a parent record is deleted, in the data in the joinTable also deleted?
# Oct 6th 2016, 09:51 birdy247 by default
# Oct 6th 2016, 09:48 mesterjagel - Using angular 2
# Oct 6th 2016, 09:48 mesterjagel Hey guys, how would you go about serving an index file in an other directory via the router? Trying to host a one page app :slightly_smiling_face:?
# Oct 6th 2016, 09:47 Human_G33k dereuromark, you can confirm me, now we can have several field primary key ?
# Oct 6th 2016, 09:41 Human_G33k ok my bad, thx, i will check that.
# Oct 6th 2016, 09:37 dereuromark it is actually as easy as replacing 3.0 with master
# Oct 6th 2016, 09:37 dereuromark Human: Did you by any chance try to find that file in the master branch? ;)
# Oct 6th 2016, 09:36 dereuromark what is the recommended solution for sql error "must appear in the GROUP BY clause or be used in an aggregate function" (https://travis-ci.org/dereuromark/CakePHP-DatabaseLog/jobs/165390489)
# Oct 6th 2016, 09:36 Human_G33k the dead link is https://github.com/dereuromark/cakephp-shim/blob/3.0/docs/Features.md#uuid-as-binary36
# Oct 6th 2016, 09:33 Human_G33k dereuromark i found a link to your github but is dead, i need more information about uuid, bin/bake, many to many relations if you have good link or tutorial. i probably do something wrong because when i try to had users, i have sql error
# Oct 6th 2016, 09:32 hmic so its 3.x? why do you want/need to do this?
# Oct 6th 2016, 09:27 birdy247 $this->associations->remove('name');
# Oct 6th 2016, 09:27 birdy247 I got it
# Oct 6th 2016, 09:23 hmic birdy247: is it 2.x you are talking about? because of using recursive (still)?
# Oct 6th 2016, 09:22 birdy247 I cant recall how to do it
# Oct 6th 2016, 09:22 birdy247 I have asked this before, but removing an association on the fly
# Oct 6th 2016, 09:22 dereuromark I am
# Oct 6th 2016, 09:22 birdy247 Hi
# Oct 6th 2016, 09:18 Human_G33k dereuromark, are you here ?
# Oct 6th 2016, 09:00 rsadza thanks :slightly_smiling_face:
# Oct 6th 2016, 08:54 hmic it's a bit confusing, given. they could have called the events by that: buildValidatorEvent vs. buildValidator e.g.
# Oct 6th 2016, 08:54 rsadza I was still in CakePHP2 mode ;)
# Oct 6th 2016, 08:54 hmic even though they are sharing the same function names (in different classes) their definition differs
# Oct 6th 2016, 08:54 rsadza aaah