Log message #4170481

# At Username Text
# Oct 5th 2018, 21:03 GloriousYellow_ ohh nice, let me try
# Oct 5th 2018, 20:40 dereuromark darn, 0.10 of phinx might solve the "Specified key was too long; max key length is ..." constraint unique issue.. but migrations plugin is still stuck on 0.8
# Oct 5th 2018, 19:50 itmpls user_groups._ids is the fieldname, ->save($entity, ['associated' => 'SiteUsers.UserGroups']); and $this->belongsToMany('UserGroups', ['className' => 'SiteUsers.UserGroups', 'joinTable' => 'user_groups_users', 'foreignKey' => 'user_id', 'className' => 'SiteUsers.UserGroups']);
# Oct 5th 2018, 19:48 itmpls updated associations and field name too
# Oct 5th 2018, 19:48 itmpls well, renamed the classes to have no prefix and same thing. hmm
# Oct 5th 2018, 19:42 itmpls yeah i suppose i just wanted to differentiate it but i'll try messing around with it
# Oct 5th 2018, 19:41 btx you’re in a plugin, right? so everything is already prefixed with the plugin name
# Oct 5th 2018, 19:41 itmpls it's within the SiteUser plugin, which overrides the Users plugin from cake/dc
# Oct 5th 2018, 19:41 btx is there a reason you’re prefixing everything?
# Oct 5th 2018, 19:40 btx Cake is gonna be looking for `site_user_group_id` so you’ll have to correct your primary/foreign keys on your Join and Tables
# Oct 5th 2018, 19:39 itmpls class name is SiteUserGroupsTable, SiteUsersTable, SiteUserGroupsUsersTable
# Oct 5th 2018, 19:38 itmpls user_id and user_group_id, sorry
# Oct 5th 2018, 19:27 btx what are the columns in the join table? `user_id` and `site_user_group_id` or `user_group_id`
# Oct 5th 2018, 19:25 btx Cake doesn’t care what the db is named, as long as the class names work it can automagic the files/classes to load
# Oct 5th 2018, 19:24 btx is that on `UsersTable`?
# Oct 5th 2018, 19:23 itmpls hah
# Oct 5th 2018, 19:23 itmpls but the className again is SiteUserGroupsUsers not UserGroupsUsers
# Oct 5th 2018, 19:23 itmpls for example
# Oct 5th 2018, 19:23 itmpls currently i have $this->belongsToMany('SiteUserGroups', ['className' => 'SiteUsers.SiteUserGroups', 'foreignKey' => 'user_id', 'joinTable' => 'user_groups_users']);
# Oct 5th 2018, 19:22 itmpls I do a setTable override
# Oct 5th 2018, 19:22 itmpls no
# Oct 5th 2018, 19:22 btx is it prefixed in the database?
# Oct 5th 2018, 19:22 itmpls prefixed by Site
# Oct 5th 2018, 19:22 itmpls if the table is 'user_groups_user' but the class name is say, 'SiteUserGroupsUsers'
# Oct 5th 2018, 19:21 itmpls also, if the class name for my join table was prefixed, would I have to set that in the belongsToMany association?
# Oct 5th 2018, 19:14 btx (plural on second `user`)
# Oct 5th 2018, 19:14 itmpls yeah that makes sense
# Oct 5th 2018, 19:14 btx the join table should be `user_groups_users` I think tho
# Oct 5th 2018, 19:14 btx should be UserGroups first because G < S
# Oct 5th 2018, 19:12 itmpls end goal is to save my entity which belongsToMany('UserGroupsUser', ['joinTable' => 'user_groups_user']);
# Oct 5th 2018, 19:12 itmpls with how cake expects things to be alphabetical, if i have a 'UserGroupsUser' table does it expect 'User' to be plural and in front, or UserGroups since they start with the same word?
# Oct 5th 2018, 18:16 quinquo mescalito: pdksh+openbsd
# Oct 5th 2018, 18:16 quinquo fixes lots of crashes. I have to admit, i don't think I've ever had it crash on me
# Oct 5th 2018, 17:40 flashios09 so the **post entity** will have **my_fake_table entity** `$post->my_fake_table`
# Oct 5th 2018, 17:37 slackebot <flashios09>
# Oct 5th 2018, 17:36 flashios09 and it will generate this query:
# Oct 5th 2018, 17:35 slackebot <flashios09>
# Oct 5th 2018, 17:35 flashios09 then we can do:
# Oct 5th 2018, 17:28 slackebot <flashios09>
# Oct 5th 2018, 17:26 slackebot // .. ]); } } ```
# Oct 5th 2018, 17:26 flashios09 ```php <?php namespace App\Model\Table; use App\ORM\Table; class MyFakeTable extends Table { public function initialize(array $config){ // don't use a hard table $this->table(false); // create a fake schema // i don't know, maybe something like this $this->schema([ 'id' => 'MYSQL_CUSTOM_FUNCTION()', 'another_fake_field' => 'ANOTHER_MYSQL_CUSTOM_FUNCTION()',