Log message #4267146

# At Username Text
# Jul 5th 2021, 20:23 slackebot2 'Roles.name' // or whatever the column field is for the name of the role ] ] ); }```
# Jul 5th 2021, 20:23 kevin.pfeifer looking at https://book.cakephp.org/4/en/orm/retrieving-data-and-resultsets.html#eager-loading-associations-via-contain I would guess something like ```public function findForAuthentication(\Cake\ORM\Query $query, array $options): \Cake\ORM\Query { return $query->contain( [ 'Staffs', 'Students', 'StudentParents', 'UserRoles.Roles' => [
# Jul 5th 2021, 19:59 alamnaryab How can I get plain array of role-names in above Finder
# Jul 5th 2021, 19:58 slackebot2 `UserRoles` objects while I want simple array or roles as `['admin','super-admin']` because in my project I have used `in_array('admin',$this->Auth->roles() ){ ... }` and ``array_intersect(['admin','role2'],$this->Auth->roles() ){ ... }`
# Jul 5th 2021, 19:58 alamnaryab hi I am using custom Finder to get contained model on Authentication.login ```public function findForAuthentication(\Cake\ORM\Query $query, array $options): \Cake\ORM\Query { return $query->contain( [ 'Staffs', 'Students', 'StudentParents', 'UserRoles.Roles' ] ); }``` `UserRoles.Roles` is giving `Roles` inside
# Jul 5th 2021, 19:20 kevin.pfeifer But I guess setting those variables in my Plugin.php is recommended for the future?
# Jul 5th 2021, 19:19 kevin.pfeifer Okay i just looked at the constructor of the BasePlugin class and it basically sets those variables
# Jul 5th 2021, 19:15 kevin.pfeifer or is this something different?
# Jul 5th 2021, 19:15 kevin.pfeifer I noticed protected variables in in the BasePlugin class like `$bootstrapEnabled` or `$routesEnabled` which are all true. So are those the “new” recommended way to enable/disable plugin parts like routes instead of ```$this->addPlugin( 'MyPlugin', [ 'routes' => true ] ); ```
# Jul 5th 2021, 16:45 dereuromark Also improvements/PRs are welcome
# Jul 5th 2021, 16:44 dereuromark Anyone using the Queue plugin and wants to test the new v6 before I tag a stable release on it ( https://github.com/dereuromark/cakephp-queue/releases )?
# Jul 5th 2021, 14:54 jotpe Okay, got it. For some reasons one of my Plugins contained a vendor folder with an earlier cake version. This caused the confusion. Sorry guys.
# Jul 5th 2021, 14:49 kevin.pfeifer I just enabled php 8.0 language level in my app and I have no issues whatsoever
# Jul 5th 2021, 14:40 dereuromark since that can be an issue for PHP8 named param usage, this is probably why it is visible here for u
# Jul 5th 2021, 14:39 dereuromark the error message suggests that somewhere in your code at least 1 of those is using "middleware" instead of "middlewareQueue" as var name.
# Jul 5th 2021, 14:39 dereuromark I both am, and for me this is not an issue. all good.
# Jul 5th 2021, 14:39 dereuromark also latest phpstorm?
# Jul 5th 2021, 14:36 jotpe 4.2
# Jul 5th 2021, 14:36 dereuromark are you on latest cake core?
# Jul 5th 2021, 14:36 jotpe Didn't solve the problem, I guess i'll just leave it.
# Jul 5th 2021, 14:34 jotpe Tried it, I guess I opened pandora's box...indexing :)
# Jul 5th 2021, 14:29 kevin.pfeifer sometimes phpstorm gets stuck on something and then the autocomplete/error messages are weid for me too
# Jul 5th 2021, 14:29 kevin.pfeifer have you tried `File` => `Invalidate Caches`?
# Jul 5th 2021, 14:27 jotpe Weird
# Jul 5th 2021, 14:26 jotpe it is @kevin.pfeifer
# Jul 5th 2021, 14:26 jotpe They're identical to the params in BaseApplication and HttpApplicationInterface
# Jul 5th 2021, 14:26 kevin.pfeifer I guess your `use X/Y/Z/MiddlewareQueue` is not `Cake\Http\MiddlewareQueue`
# Jul 5th 2021, 14:25 dereuromark but no big deal IMO
# Jul 5th 2021, 14:25 dereuromark most likely var name
# Jul 5th 2021, 14:23 jotpe
# Jul 5th 2021, 14:23 jotpe Anybody knows why PHPStorm is complaining about this?
# Jul 5th 2021, 13:58 jotpe Worked perfectly, ty
# Jul 5th 2021, 13:29 jotpe thanks @info315
# Jul 5th 2021, 13:28 jotpe @dereuromark you mean DbMaintenanceShell?
# Jul 5th 2021, 13:27 info315 @jotpe I convert my tables like so: https://github.com/it-novum/openITCOCKPIT/blob/development/UPDATE.sh#L123-L132
# Jul 5th 2021, 13:23 dereuromark I have custom scripts for that in Setup plugin that can help u
# Jul 5th 2021, 13:22 ndm IIRC that's not supported... you'll probably have to run custom raw `ALTER TABLE` SQL.
# Jul 5th 2021, 13:14 jotpe ```$authors = $this->table('authors', ['collation' => 'utf8mb4_unicode_ci']); $authors->update();```
# Jul 5th 2021, 13:14 jotpe Hey guys. I want to migrate some of my tables to use utf8mb4. This doesn't work. Any suggestions?
# Jul 5th 2021, 12:58 paolo.bragagni humm ok
# Jul 5th 2021, 12:48 kevin.pfeifer how about using the search? https://select2.org/data-sources/ajax