| # |
Dec 17th 2019, 14:40 |
slackebot |
<jotpe> |
| # |
Dec 17th 2019, 14:40 |
 jotpe |
The query looks like: |
| # |
Dec 17th 2019, 14:39 |
jotpe |
Mhm doesn't work @luke |
| # |
Dec 17th 2019, 14:36 |
luke |
```->contain('Matriculations', function (Query $q) { return $q ->select(['id', 'date_revocation', 'student_id]) ->where(['OR' => ['Matriculations.id IS' => null, 'Matriculations.date_revocation <' => new DateTime()]]); });``` |
| # |
Dec 17th 2019, 14:35 |
davalb |
Had to google it, for a detailed explanations and some options see for instance: https://stackoverflow.com/questions/34115174/error-related-to-only-full-group-by-when-executing-a-query-in-mysql |
| # |
Dec 17th 2019, 14:33 |
luke |
@jotpe Try returning the contain from a function, as in the documentation. Are your groups from the contain table? |
| # |
Dec 17th 2019, 14:32 |
jotpe |
I added Users.id to group, but didn't solved it. |
| # |
Dec 17th 2019, 14:32 |
dereuromark |
my favorite :) |
| # |
Dec 17th 2019, 14:31 |
jotpe |
*Error:* SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #13 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'XXX.Names.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by |
| # |
Dec 17th 2019, 14:30 |
luke |
```// In a controller or table method. // Prior to 3.5.0 you would use contain(['Comments' => function () { ... }]) $query = $articles->find()->contain('Comments', function (Query $q) { return $q ->select(['body', 'author_id']) ->where(['Comments.approved' => true]); });``` |
| # |
Dec 17th 2019, 14:29 |
luke |
I think you need to pass conditions to contain differently https://book.cakephp.org/3/en/orm/query-builder.html#passing-conditions-to-contain |
| # |
Dec 17th 2019, 14:29 |
davalb |
can you post the sql error? |
| # |
Dec 17th 2019, 14:26 |
jotpe |
Anyone has a hint? |
| # |
Dec 17th 2019, 14:26 |
jotpe |
This contain breaks the query: `->contain(['Users' => *['Names']*, 'Terminations'])` |
| # |
Dec 17th 2019, 14:25 |
slackebot |
<jotpe> |
| # |
Dec 17th 2019, 14:25 |
jotpe |
Hey, I try this again. I have a query with some left joins. When I add a contain with nested Models, the Model breaks: |
| # |
Dec 17th 2019, 14:23 |
gianmarxgagliardi |
I have three tables with this structure: https://pastebin.com/e2PwW5bs when I go to work on the dogscats table by adding an ennuple using the special "add" function developed in DogsCatsController it shows me only ID of "cat" or "dog", but I would like to show the name .... |
| # |
Dec 17th 2019, 14:22 |
dereuromark |
see https://documentation.spryker.com/tutorials/howtos/ht-case-sensitive-file-system-mac.htm |
| # |
Dec 17th 2019, 14:21 |
davalb |
I see, thanks |
| # |
Dec 17th 2019, 14:21 |
dereuromark |
most macs use an inproper filesystem by default. |
| # |
Dec 17th 2019, 14:21 |
dereuromark |
a proper system (linux, or a properly configured mac) would make this easier to work with |
| # |
Dec 17th 2019, 14:20 |
dereuromark |
jep locale vs Locale |
| # |
Dec 17th 2019, 14:20 |
davalb |
or what do you mean by case sensitivity issue |
| # |
Dec 17th 2019, 14:20 |
davalb |
Not sure I understand, is the case of `Locale` wrong? Should it be `locale` ? |
| # |
Dec 17th 2019, 14:15 |
dereuromark |
hm, the case sensitivity issue there will most likely require you to use the upgrade command (and git double rename trick), you cant easily use then https://github.com/dereuromark/upgrade/wiki/4.x-upgrade-snippets#src etc |
| # |
Dec 17th 2019, 14:15 |
davalb |
no, I am on a mac |
| # |
Dec 17th 2019, 14:13 |
dereuromark |
are you on linux? I use some basic low level commands to upgrade those files, works fast and also quite reliable |
| # |
Dec 17th 2019, 14:09 |
davalb |
I am not sure what it is trying to tell me. My app is in a different repository than the upgrade tool, sure. |
| # |
Dec 17th 2019, 14:08 |
davalb |
trying to run teh cakephp 4 upgrade tool and getting this error: `fatal: ../src/Locale: '../src/Locale' is outside repository` |
| # |
Dec 17th 2019, 13:57 |
maymeow |
cakephp 4 has `Identity\Factories\RoleFactory` ? |
| # |
Dec 17th 2019, 13:54 |
dereuromark |
bottom line: the platform lock down makes sense IMO if you want to stay compatible to php7.2 as min |
| # |
Dec 17th 2019, 13:27 |
dereuromark |
or you use --ignore-platform-reqs, which also would pull 7.3 one then always |
| # |
Dec 17th 2019, 13:27 |
dereuromark |
this will write the 7.2 one into the lock file :) |
| # |
Dec 17th 2019, 13:26 |
dereuromark |
the alternative is this trick in config: "platform": { "php": "7.2.15" }, you can remove this if you are >7.2, otherwise keep it. |
| # |
Dec 17th 2019, 13:25 |
dereuromark |
maybe we should remove that for this project. |
| # |
Dec 17th 2019, 13:24 |
dereuromark |
ah, that might be it..^^ |
| # |
Dec 17th 2019, 13:24 |
dereuromark |
maybe he had a previous lock file or sth |
| # |
Dec 17th 2019, 13:24 |
admad |
wonder why it tries to pull 1.5 for him/her on php 7.2 |
| # |
Dec 17th 2019, 13:24 |
admad |
proper constraint has been used here https://github.com/rectorphp/rector/blob/master/composer.json#L37 |
| # |
Dec 17th 2019, 13:21 |
dereuromark |
it is super annoying if projects for no good reason up their min versions. at least this one is not too important. |
| # |
Dec 17th 2019, 13:21 |
dereuromark |
@maymeow That is not true. Only the latest version of that tool needs it. If you use composer it will auto install usually the compatible one (php7.2 compatible). You can also hardcode it on project level: ` ```"ocramius/package-versions": "~1.4.0"``` ` |