| # |
Jun 10th 2021, 13:42 |
 kevin.pfeifer |
well I would guess you want to do something like that, right? ```'Users.myfield LIKE' => '%test%'``` where Users.myfield is a decimal but your search input is a string |
| # |
Jun 10th 2021, 13:40 |
paolo.bragagni |
PS. we are only 3 that use this slack?? :( |
| # |
Jun 10th 2021, 13:39 |
paolo.bragagni |
in friendsofcake search plugin which is the best way to manage errors (I mean Cannot convert value of type `string` to a decimal) |
| # |
Jun 10th 2021, 13:11 |
kevin.pfeifer |
thanks for that explanation :) |
| # |
Jun 10th 2021, 13:10 |
kevin.pfeifer |
i see |
| # |
Jun 10th 2021, 13:04 |
admad |
@kevin.pfeifer @thomas078 There problem isn't with env variables but with the `.env` files. Env variables as per their belong in the environment not files. The `.env` files should only be used locally to emulate env vars. In production only **actual** env vars should be used. |
| # |
Jun 10th 2021, 11:30 |
slackebot |
<jpramirez> |
| # |
Jun 10th 2021, 09:34 |
thomas078 |
confusing |
| # |
Jun 10th 2021, 09:34 |
thomas078 |
@kevin.pfeifer how i understand is that it is atleast a performance issue. .env variables should be set to local environment, not using that file |
| # |
Jun 10th 2021, 09:30 |
kevin.pfeifer |
@thomas078 I am also curious about that `.env` topic because there is no warning about that in the cakephp 4 book https://book.cakephp.org/4/en/development/configuration.html#environment-variables |
| # |
Jun 10th 2021, 09:09 |
kevin.pfeifer |
or whatever webserver you are using |
| # |
Jun 10th 2021, 09:08 |
kevin.pfeifer |
See https://apache.tutorials24x7.com/blog/how-to-enable-tls-1-2-and-tls-1-3-in-apache-web-server for Apache or https://www.howtoforge.com/how-to-enable-tls-13-in-nginx/ for NGINX |
| # |
Jun 10th 2021, 09:07 |
kevin.pfeifer |
CakePHP doesn’t care if you call it via HTTP or HTTPS and therefore it doesn’t care if its SSL3, TLS 1.1 or TLS 1.3 The encrypted HTTP traffic is handled by your webserver |
| # |
Jun 10th 2021, 09:06 |
mocelle |
Cakephp 3.9 support allready tls1.3? |
| # |
Jun 10th 2021, 09:04 |
kevin.pfeifer |
@mocelle that is decided by the settings of your webserver, not cakephp |
| # |
Jun 10th 2021, 08:56 |
mocelle |
How to force Client to use tls1.3? |
| # |
Jun 10th 2021, 08:50 |
thomas078 |
Enabling .env on cake 3.9. Now i read documentation and is says "It is HIGHLY discouraged to use a .env file in production, due to security risks * and decreased performance on each request..." I though that .env is the way to go? |
| # |
Jun 10th 2021, 08:34 |
paolo.bragagni |
in friendsofcake search plugin which is the best way to manage errors (I mean Cannot convert value of type `string` to a decimal) |
| # |
Jun 10th 2021, 03:51 |
admad |
There are other webservices for the same. |
| # |
Jun 10th 2021, 03:50 |
admad |
For e.g. for local/intranet use there's Mailhog |
| # |
Jun 10th 2021, 03:49 |
admad |
@kevin.pfeifer a better way would be to use a different transport config based on environment/debug mode and send them all to a "mail catcher". |
| # |
Jun 9th 2021, 21:26 |
kevin.pfeifer |
Is it possible to “globally overwrite” all recipients of mails sent via a Mailer? I would like to add a config for a sort of “Email debug mode” where all mails are being sent to a defined mail. Or do I have to add that logic to all my “reusable mailer functions”? |
| # |
Jun 9th 2021, 13:56 |
paolo.bragagni |
found sorry |
| # |
Jun 9th 2021, 13:50 |
paolo.bragagni |
I get '*Cannot convert value of type `string` to integer'* |
| # |
Jun 9th 2021, 13:49 |
paolo.bragagni |
cake4/libri/?lingua_id=2 |
| # |
Jun 9th 2021, 13:49 |
paolo.bragagni |
in fiendofsearch plugin I got an error searching in related |
| # |
Jun 9th 2021, 11:04 |
y.teruyacookie |
Thank you very much!! I have solved this problem! |
| # |
Jun 9th 2021, 10:56 |
ndm |
`['column_name' => "''"]` |
| # |
Jun 9th 2021, 10:49 |
y.teruyacookie |
Thanks, but I don't get the passed code. The followings are an error log. ```Hogemodel.'' as column_name AS `Hogemodels__'' as column_name` FROM higemodels Hogemodels``` |
| # |
Jun 9th 2021, 10:32 |
steinkel |
try `->select(["'' as column_name"])` |
| # |
Jun 9th 2021, 10:23 |
slackebot |
->find('FinderMethod') ->select([. 'column_name' => '', ]);``` Is there any way to output a blank column? |
| # |
Jun 9th 2021, 10:23 |
y.teruyacookie |
Hi, I would like to ask my question. I would like to intentionally output blank columns in the CakePHP3 query builder. In the case of MySQL, you can write the following ```SELECT '' AS 'column_name' FROM hogeModel;``` It will return a column with column_name and a blank value. I would like to do the same thing with CakePHP3's query builder. If I write the following, I get a DataBase error. ```return $query |
| # |
Jun 9th 2021, 10:01 |
ndm |
https://explainextended.com/2009/09/24/adjacency-list-vs-nested-sets-postgresql/ |
| # |
Jun 9th 2021, 09:57 |
eax |
Oh thanks @ndm I’ll look into that! :relaxed: |
| # |
Jun 9th 2021, 09:56 |
ndm |
If you just have an adjacency list with `parent_id`, then you'd need something recursive, which could for example be achieved using common table expressions. |
| # |
Jun 9th 2021, 09:50 |
eax |
@ndm: Ok, then I don’t think it’s an option here, but thanks :$ |
| # |
Jun 9th 2021, 09:48 |
ndm |
Yes, that's the fields for a nested set. |
| # |
Jun 9th 2021, 09:48 |
eax |
Thanks @ndm! But doesn’t that require me to have the lft and rght fields in my table? |
| # |
Jun 9th 2021, 09:46 |
ndm |
@eax If you have a nested set, then you can use the `path` finder: `find('path', ['for' => $childId])` https://book.cakephp.org/3/en/orm/behaviors/tree.html |
| # |
Jun 9th 2021, 09:30 |
eax |
Hey folks! Cake3 question: Is it possible to do a “reverse” threaded find? I have the “bottom” child, and would like to get the parents all the way “up” in the same Query :$ |
| # |
Jun 9th 2021, 07:46 |
philo.hamel |
that's what we use to continue to use the property access |