Log message #4186996

# At Username Text
# May 21st 2019, 07:40 k4t hello
# May 21st 2019, 07:38 neon1024 Morning all :wave:
# May 21st 2019, 07:08 admad @waspinator patching requires entity for the associations to be already present in entity you are patching
# May 21st 2019, 02:38 waspinator it has a belongsToMany('Editors') and belongsToMany('Writers'), both of which are of `->setClassName('Users')`
# May 21st 2019, 02:37 waspinator ``` object(App\Model\Entity\Group) { 'name' => 'test group', '[new]' => true, '[accessible]' => [ 'name' => true, 'editors_groups' => true, 'groups_writers' => true ], '[dirty]' => [ 'name' => true ], '[original]' => [], '[virtual]' => [], '[hasErrors]' => false, '[errors]' => [], '[invalid]' => [], '[repository]' => 'Groups' } ```
# May 21st 2019, 02:15 turkles What does group look like if you dd() or log() ?
# May 20th 2019, 22:31 waspinator that should work right?
# May 20th 2019, 22:30 slackebot $this->Groups->save($group); ```
# May 20th 2019, 22:30 waspinator I'm trying to `patchEntity` with `belongsToMany` associated data, but it doesn't get added. ``` $group = $this->Groups->newEntity(); $data = [ 'name' => 'test group', 'editors' => [ '_ids' => [ (int) 0 => '1' ] ], 'writers' => [ '_ids' => [ (int) 0 => '2' ] ] ]; $group = $this->Groups->patchEntity($group, $data, [ 'associated' => ['Editors', 'Writers'] ]);
# May 20th 2019, 21:59 dereuromark there are tools that are supposed to find them as well out there
# May 20th 2019, 21:59 dereuromark rightclick => usage can sometimes work in your IDE, otherwise code coverage or just delete and see what breaks
# May 20th 2019, 21:56 swimboy Is there an easy way to identify classes that are no longer being used? I have a project that has had some significant restructuring and I think that there are a lot of classes that were only included for code that’s since been removed.
# May 20th 2019, 19:46 slackebot SQL error is displayed: Unknown column 'Profiles.tour_guide_id' in 'on clause' This is because CakePHP tries to join a tour guide's profile using the column profiles.tour_guide_id instead of profiles.user_id This combination worked fine in CakePHP 1.3 but I'm having trouble with CakePHP 3 (tried with 3.7.7). Is what I want to do even possible? What am I missing? Thanks for your help and advice in advance.
# May 20th 2019, 19:46 michaelze I have three tables: - tours - users - profiles These have the following associations: ToursTable: $this->belongsTo('TourGuides', [ 'className' => 'Users', ]); // the foreignKey column is called tours.tour_guide_id UsersTable: $this->hasOne('Profiles'); ProfilesTable: $this->belongsTo('Users'); When I perform the following query: $this->Tours->query()->contain(['TourGuides', 'TourGuides.Profiles']) the following
# May 20th 2019, 18:45 beakman Here's an example on an encrypted database type: https://github.com/bcrowe/cakephp-encrypted-type/blob/master/src/Database/Type/EncryptedType.php Not sure if it'll help, maybe.
# May 20th 2019, 18:33 vinicius.big hello all! I need to create a JS file along with my index.ctp using bake command. Does anyone have an example of that?
# May 20th 2019, 18:30 admad @manthan.budheliya show your type class
# May 20th 2019, 17:58 manthan.budheliya cakephp version is 3.7
# May 20th 2019, 17:58 manthan.budheliya is there anybody who have some idea?
# May 20th 2019, 17:57 manthan.budheliya Hello friends, I have created a custom data type as I wanted to add 2 way encryption to some of my fields. The problem is toPHP function is working but toDatabase function is not calling from any of the possible way.
# May 20th 2019, 17:21 admad need to update to latest release of Search plugin for that
# May 20th 2019, 17:20 admad you can use callback for newly added "beforeProcess" option to unobfuscate the id in filter argument yourself
# May 20th 2019, 16:31 welo.lamacchia I have FooTable hasMany BarTable, I add ->value('foo_id') to SearchManager behavior and load list of BarTable records with HASHED ID
# May 20th 2019, 16:29 welo.lamacchia is there a way to use Muffin/Obfuscate plugin with Friends Of Cake Search Plugin ? I cant perform query when i search for foreign_key hashed id
# May 20th 2019, 15:36 inoas there is some array_values somewhere grml
# May 20th 2019, 15:36 inoas ah stupid indexes
# May 20th 2019, 15:15 inoas well min_runtime_length_in_month
# May 20th 2019, 15:15 inoas for <?= $this->Form->control(sprintf('codes.%s._joinData.max_runtime_length_in_month', $i)
# May 20th 2019, 15:15 inoas errors ['codes' => [0 => ['_joinData' => ['min_runtime_length_in_month' => ['greaterThanOrEqual' => ...
# May 20th 2019, 15:14 inoas '_joinData' => ['min_runtime_length_in_month' => ['greaterThanOrEqual' => ...
# May 20th 2019, 15:14 inoas admad now things do work however validation errors do not map into formhelper
# May 20th 2019, 15:04 dwms understood?
# May 20th 2019, 15:04 dwms is sum of the sum
# May 20th 2019, 15:03 dwms but when I do sum this subquery is returning me null
# May 20th 2019, 15:02 dwms returning null
# May 20th 2019, 15:02 dwms $query->select([ 'valor_baixa_normal' => $query->func()->sum('(' . $baixa_select1 . ')') ]);
# May 20th 2019, 15:01 neon1024 Well as it’s a calculated field it will not be marshalled into a float because the schema doesn’t define the data type
# May 20th 2019, 15:01 dwms because I actually do this
# May 20th 2019, 15:01 dwms should return in float
# May 20th 2019, 15:01 dwms eu preciso que o resultado venha em float
# May 20th 2019, 14:57 neon1024 `(float) $baixa_select1`