| # |
Dec 17th 2019, 14:42 |
 luke |
yeah, you need to include all the columns in the group by statement. |
| # |
Dec 17th 2019, 14:41 |
jotpe |
:confounded: |
| # |
Dec 17th 2019, 14:41 |
jotpe |
`*Error:* SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'xxx.Matriculations.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:41 |
jotpe |
This gives me |
| # |
Dec 17th 2019, 14:40 |
luke |
? |
| # |
Dec 17th 2019, 14:40 |
luke |
should it be membership_id |
| # |
Dec 17th 2019, 14:40 |
jotpe |
*Error:* SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Memberships.id' in 'group statement' |
| # |
Dec 17th 2019, 14:40 |
luke |
I guessed at the select columns you needed. |
| # |
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 :) |