Log message #4213010

# At Username Text
# Nov 10th 2019, 18:35 ndm You'd have to override the type. Use the second argument of `where()` to supply a type accordingly: `where(['field LIKE' => '%value%'], ['field' => 'string'])`
# Nov 10th 2019, 18:29 wYm hi all, how can I add where clause for Json type column ? I tried 'field LIKE' => '%value%' but I didn't work
# Nov 10th 2019, 16:46 graziel no need for base64 encode
# Nov 10th 2019, 16:45 graziel you can access file with usual cake way `$this->request->getData('cv_file');`
# Nov 10th 2019, 16:45 graziel ```a = new FormData() a.append('cv_file', document.getElementById('main_page').files[0]) a.append('additional_files[]', document.getElementById('id0').files[0]) a.append('additional_files[]', document.getElementById('id1').files[0]) a.append('query', 'mutation { apply(offer_id: "1", cv_file: "cv_file", additional_files: "additional_files") }') axios.post('http://example.com/api', a)```
# Nov 10th 2019, 16:45 graziel @mrfeedback im using combo of vue+axios as front and graphql+jose/upload to handle file upload but same principle
# Nov 10th 2019, 14:52 mrfeedback but im wondering if there is already any plugin which addresses base64 encoded streams yet
# Nov 10th 2019, 14:52 mrfeedback im using it in combination with angular. so at the moment I guet a base64 file stream when the file gets uploaded
# Nov 10th 2019, 14:46 luizcmarin @mrfeedback https://www.startutorial.com/articles/view/how-to-build-a-file-upload-form-using-dropzonejs-and-php maybe...
# Nov 10th 2019, 14:39 mrfeedback or is therer any recommended upload plugin for such a case?
# Nov 10th 2019, 14:35 mrfeedback the upload could be an image, video or pdf
# Nov 10th 2019, 14:34 mrfeedback has anyone a tip/source for me on how to handle fileuploads to an api with cakephp under the hood? I would get a base64 stream via dropzone. But I am not sure how to handle that in a "correct" way
# Nov 10th 2019, 13:38 luizcmarin help please
# Nov 10th 2019, 13:38 luizcmarin good morning everyone I am trying to configure cakephp4 on IIS, windows 10. I have the same issues described here https://stackoverflow.com/questions/30676952/cakephp-3-0-iis-web-config, ie "The content of the pages is rendering fine, just not the images and css. "
# Nov 10th 2019, 09:05 kevin.pfeifer @voycey thx, i just thought there is an "easy" way to adjust the outputed paginator to be in a specific "scope" but doing it per AJAX is definitely better for the UX.
# Nov 10th 2019, 03:21 voycey Especially if you have a lot of different models on the page that need sorting / filtering individually
# Nov 10th 2019, 03:21 voycey Multiple pagination is supported in cake3 but I generally find it better to do this via Ajax
# Nov 9th 2019, 22:51 kevin.pfeifer especially when i have multiple related tables, therefore multiple paginators
# Nov 9th 2019, 22:50 kevin.pfeifer Another Question: Is it possible to use the paginator on related entries inside the view template? Per default CakePHP just puts out all the entries it has found and doesn't allow for sorting or pagination.
# Nov 9th 2019, 21:21 kevin.pfeifer FYI: I created a stackoverflow question with more information about my problem mentioned above https://stackoverflow.com/questions/58783591/cakephp4-concatenated-where-on-connected-table-not-working-as-expected
# Nov 9th 2019, 20:36 mrfeedback ok forget it. I had the same fixture two times but one with a typo....
# Nov 9th 2019, 20:26 mrfeedback contain would give back a result of projects even if there is no connection to projectclosings. And I want to make sure that three isn´t any connection
# Nov 9th 2019, 20:24 hollistergraham123 Why use matching? Why not use contain?
# Nov 9th 2019, 20:21 hollistergraham123 This seems like a real bug
# Nov 9th 2019, 20:21 hollistergraham123 I renamed the association to ProfileImages and it works prefect
# Nov 9th 2019, 20:15 hollistergraham123 Same reult
# Nov 9th 2019, 20:12 mrfeedback Have you tried "Authors.Posts.FeaturedImages" and "Authors.Images" ?
# Nov 9th 2019, 20:11 slackebot1 back results with Projects which are not related. In fixture there is no link between these two entries, but I get back a result which is mega weired
# Nov 9th 2019, 20:11 mrfeedback I have a HABTM relation. And I try to get only results IF there is a link between projcets and projectclosings. like this: ``` $has_projectclosing = $this->find('all') ->matching( 'Projects' , function(Query $q) use($project_id) { return $q->where(['Projects.id' => $project_id]); } ) ->toArray(); debug($has_projectclosing); ``` for some reason I get
# Nov 9th 2019, 20:10 hollistergraham123 Anyone experience something like this>
# Nov 9th 2019, 20:10 hollistergraham123 Hey i’m having an issue where if I include Images in the contain statement for Post it won’t include the Images association on Authors
# Nov 9th 2019, 19:26 mrfeedback if I want to use `matching` with a HABTM relationship, do I need to enter the joinTable for the matching assoc?
# Nov 9th 2019, 18:28 kevin.pfeifer or should i create a simple example and explain everything inside a github issue?
# Nov 9th 2019, 18:27 kevin.pfeifer and in the Table Model for Table 2 ``` $this->belongsTo( 'Table1', [ 'foreignKey' => 'table1_id', ] ); ```
# Nov 9th 2019, 18:11 kevin.pfeifer so therfore my question is: how do i search inside a connnected hasMany connection
# Nov 9th 2019, 18:10 kevin.pfeifer this is inside the Table Model of Table 1 ``` $this->hasMany( 'Table2', [ 'foreignKey' => 'Table2_id' ] ); ```
# Nov 9th 2019, 15:18 ndm @kevin.pfeifer That would only work when `Table2` is associated via `belongsTo` or `hasOne`, using the `join` strategy.
# Nov 9th 2019, 14:27 kevin.pfeifer The Connection in the Model between Table 1 and Table 2 is correct, that is not the problem
# Nov 9th 2019, 14:26 slackebot1 ->like( $conc1, "%$search%" ) ->like( $conc2, "%$search%" ) ->like( $conc3, "%$search%" ) ->like( $conc4, "%$search%" ); } ); ``` But when i search something i get the error: ``` Column not found: 1054 Unknown column 'Table2.first_name' in 'where clause' ``` Therefore CakePHP doesnt seem to perform the join between Table1 and Table2. Do i do something wrong?
# Nov 9th 2019, 14:26 slackebot1 'Table1.company LIKE' => "%$search%", 'Table1.first_name LIKE' => "%$search%", 'Table1.last_name LIKE' => "%$search%", 'Table1.city LIKE' => "%$search%", 'Table2.first_name LIKE' => "%$search%", 'Table2.last_name LIKE' => "%$search%" ] )
# Nov 9th 2019, 14:26 slackebot1 'Table2.last_name' => 'literal' ] ); $conc4 = $q->func() ->concat( [ 'Table2.last_name' => 'literal', ' ', 'Table2.first_name' => 'literal' ] ); return $exp->or( [