Log message #4017454

# At Username Text
# Apr 19th 2017, 09:37 theaxiom Anyone ever heard of http://slackarchive.io ?
# Apr 19th 2017, 09:36 Nick5 ie the cache is called short and name is new_offers. If I add an offer, can this be removed and then rebuilt without waiting for a pageload?
# Apr 19th 2017, 09:35 Nick5 Is there a way to automatically remove and rebuild a query cache when a new item is added?
# Apr 19th 2017, 09:06 Martin` https://gist.github.com/blieb/27e2f9c3b76e03c778eed4810942139b << why can I not use the "$idsChannels" as a subquery in an array? I can just run it on its own, but not as subquery, then it gives the error you see in the comment
# Apr 19th 2017, 08:52 hmic so this needs to read $roles->name instead
# Apr 19th 2017, 08:52 Neon1024 If you’d round a role, you’d get a RoleEntity, so it’d be like $role->get(‘name’)
# Apr 19th 2017, 08:52 hmic oh, i got it wrong, roles is *one* entity
# Apr 19th 2017, 08:52 Neon1024 So accessing data using arrays will not work
# Apr 19th 2017, 08:52 Neon1024 Collections of entity objects
# Apr 19th 2017, 08:51 Neon1024 Well, not in model keyed arrays, but rather in Collections
# Apr 19th 2017, 08:51 Neon1024 In Cake 3, data is not in arrays
# Apr 19th 2017, 08:51 joop this does not worked
# Apr 19th 2017, 08:51 hmic user will have multiple roles, so you need to filter for an admin role. i'd use the Collection to do so
# Apr 19th 2017, 08:50 joop okey and if i want to make an if Statement like if($roles['Roles']['name']=='admin')
# Apr 19th 2017, 08:46 Neon1024 If you go to roles and contain users, you’ll get all the users in that role instead
# Apr 19th 2017, 08:46 joop yes
# Apr 19th 2017, 08:46 Neon1024 So you can find the specific user, and then contain all their associated roles
# Apr 19th 2017, 08:46 Neon1024 $this->Users->find()->contain([‘Roles’])->where([‘Users.id’ => $userId])->first();
# Apr 19th 2017, 08:45 Neon1024 So you’ll need to find a user and contain roles
# Apr 19th 2017, 08:45 joop 'UsersRoles.user_id' is gives error
# Apr 19th 2017, 08:44 joop i checked but for the where(or condition) 'id' =>$this->Auth->user('id') //the id is wrong i need user_id because i would like to query the specific user's roles
# Apr 19th 2017, 08:42 Neon1024 Instead, we have McDonalds down the road :s
# Apr 19th 2017, 08:41 Neon1024 Times like this I wish I was in the Netherlands, so I could pop out for a proper coffee and a stroopwaffel
# Apr 19th 2017, 08:41 Neon1024 Yeah, I’ve had a coffee, but it’s horrible instant coffee
# Apr 19th 2017, 08:41 ankr neon1024 get that coffee maker running asap
# Apr 19th 2017, 08:39 Neon1024 That ^
# Apr 19th 2017, 08:39 inoas belongsToMany() ;)
# Apr 19th 2017, 08:39 Neon1024 As it’ll be included automagically
# Apr 19th 2017, 08:39 Neon1024 If it’s a hasAndBelongsToMany() then you don’t need to contain it
# Apr 19th 2017, 08:39 Neon1024 Yeah
# Apr 19th 2017, 08:39 inoas maybe you want a real model then ;)
# Apr 19th 2017, 08:39 inoas containing a pivot table sounds weirdo
# Apr 19th 2017, 08:38 inoas the example is still here https://book.cakephp.org/3.0/en/orm/retrieving-data-and-resultsets.html#using-finders-to-load-data
# Apr 19th 2017, 08:38 inoas urgh
# Apr 19th 2017, 08:38 Neon1024 https://pastebin.com/wkFB33ep
# Apr 19th 2017, 08:37 joop Neon would you show me the 3 way please
# Apr 19th 2017, 08:36 joop Guest71037 try the History tab
# Apr 19th 2017, 08:36 Neon1024 Well it’s very Cake 2
# Apr 19th 2017, 08:36 Neon1024 Your query is all wrong
# Apr 19th 2017, 08:35 joop https://pastebin.com/TNtPkvwK
# Apr 19th 2017, 08:35 Guest71037 in debugkit, the sql tab is empty, is there any way to fix this or debug it to see why