Log message #4220267

# At Username Text
# Dec 27th 2019, 20:19 challgren Create a new mailer and use the MailgunTrait
# Dec 27th 2019, 20:19 ashesh.social Was trying for a whole day with lot many things
# Dec 27th 2019, 20:18 ashesh.social Any good documentation to integrate mailgun into cakephp 4
# Dec 27th 2019, 20:18 ashesh.social Hey all
# Dec 27th 2019, 20:04 admad `$staticUrl . '?' . http_build_query($queryArray)`
# Dec 27th 2019, 19:21 devito when using redirect, is there a way i can leverage the query array in the options while passing in a static external url? or do i need to build the whole url and just pass that in?
# Dec 27th 2019, 18:19 challgren @ashesh.social use dev-master for cake 4.x still ironing out stuff for the 5.x release
# Dec 27th 2019, 16:05 dereuromark or keyField, valueField config would also work
# Dec 27th 2019, 16:03 alexdd55976 thanks
# Dec 27th 2019, 16:03 alexdd55976 totally forgot abozuut extraaact
# Dec 27th 2019, 15:55 ndm `->extract('internal_username')->toArray()`
# Dec 27th 2019, 15:51 alexdd55976 i just want the usernames
# Dec 27th 2019, 15:51 alexdd55976 ```$usernames = $this->find('list') ->select(['internal_username']) ->disableHydration() ->toArray();```
# Dec 27th 2019, 15:51 alexdd55976 i get this with fnd list
# Dec 27th 2019, 15:50 alexdd55976 ```Array ( [0] => 1 [1] => 2 )```
# Dec 27th 2019, 15:47 dereuromark you didnt use find(list), thats why you have a deep array here
# Dec 27th 2019, 15:47 dereuromark but tbh, the given list of key=>value usually should suffice.
# Dec 27th 2019, 15:47 dereuromark sure, array_keys() on the find list^^
# Dec 27th 2019, 15:46 alexdd55976 i only get this ```Array ( [0] => Array ( [internal_username] => maa ) [1] => Array ( [internal_username] => mal ) )```
# Dec 27th 2019, 15:45 alexdd55976 nothing around it, just the array
# Dec 27th 2019, 15:45 alexdd55976 is it possible to get an array from a `->find()` which only has a list like `['a','b','c']`?
# Dec 27th 2019, 15:06 gianmarxgagliardi or to avoid that there is A vs B on day 2 and there is A vs B on day 3
# Dec 27th 2019, 15:05 gianmarxgagliardi to avoid that on day 3 there is A vs B and A vs C
# Dec 27th 2019, 15:04 gianmarxgagliardi sorry how can I build a rules that checks in the DB if that game has already been entered or if that team cannot be entered because it already has a match for that championship day
# Dec 27th 2019, 14:48 jotpe I would search somewhere over here: https://book.cakephp.org/3/en/orm/validation.html#applying-application-rules
# Dec 27th 2019, 14:45 gianmarxgagliardi sorry you know how consistency checks are done. For example, to prevent a certain value with a certain parameter from being entered multiple times? if there is anything in the documentation
# Dec 27th 2019, 14:29 slackebot   ]);         $this->belongsTo('Clubs', [             'foreignKey' => 'club_home_id',             'joinType' => 'INNER',         ]);         $this->belongsTo('Clubs', [             'foreignKey' => 'club_visitor_id',             'joinType' => 'INNER',         ]);```
# Dec 27th 2019, 14:29 gianmarxgagliardi ```$this->belongsTo('ClubsHome', [             'className' => 'Clubs',             'foreignKey' => 'club_home_id',             'joinType' => 'INNER',         ]);         $this->belongsTo('ClubsVisitor', [             'className' => 'Clubs',             'foreignKey' => 'club_visitor_id',             'joinType' => 'INNER',      
# Dec 27th 2019, 14:29 gianmarxgagliardi I solved it like this
# Dec 27th 2019, 14:28 peppejaripappalardo i check, thx ndm
# Dec 27th 2019, 14:05 ndm some sort of socket file issue, double check your config
# Dec 27th 2019, 13:57 peppejaripappalardo Hello to all, someone got this error? ```SQLSTATE[HY000] [2002] No such file or directory``` With native PDO and with workbench i am able to connect into db from remote, but cake generate the error above... Someone have an hint?
# Dec 27th 2019, 13:46 gianmarxgagliardi @jotpe
# Dec 27th 2019, 13:46 gianmarxgagliardi if I put clubs it overwrites club_home_id and I had the values available only for club_visitor_id
# Dec 27th 2019, 13:44 gianmarxgagliardi I need two arrays of values for club_home_id and club_visitor_id
# Dec 27th 2019, 13:43 gianmarxgagliardi yes i am aware of it
# Dec 27th 2019, 13:41 jotpe @gianmarxgagliardi your Models are named ClubsHome/ClubsVisitor not Clubs
# Dec 27th 2019, 13:30 gianmarxgagliardi ```$this->hasMany('Matchs', [             'foreignKey' => 'club_home_id',         ]);         $this->hasMany('Matchs', [             'foreignKey' => 'club_visitor_id',         ]);```
# Dec 27th 2019, 13:30 gianmarxgagliardi in ClubsTable
# Dec 27th 2019, 13:28 slackebot   ])```
# Dec 27th 2019, 13:28 gianmarxgagliardi ```$this->belongsTo('ClubsHome', [             'className' => 'Clubs',             'foreignKey' => 'club_home_id',             'joinType' => 'INNER',         ]);         $this->belongsTo('ClubsVisitor', [             'className' => 'Clubs',             'foreignKey' => 'club_visitor_id',             'joinType' => 'INNER',