| # |
Mar 16th 2019, 11:46 |
 martonmiklosqdev_cake |
I am trying to modernize the cakephp-utils plugins from cakemanager |
| # |
Mar 16th 2019, 11:45 |
martonmiklosqdev_cake |
Hi all! |
| # |
Mar 16th 2019, 09:40 |
birdy247 |
Is anyone using jenkins here? |
| # |
Mar 16th 2019, 00:32 |
challgren |
What version of cake? |
| # |
Mar 15th 2019, 19:10 |
chrisshick |
yet it still logs all queries |
| # |
Mar 15th 2019, 19:09 |
chrisshick |
I have query logs flag disabled |
| # |
Mar 15th 2019, 19:09 |
chrisshick |
Any clues how to turn off query logs? |
| # |
Mar 15th 2019, 16:31 |
lorro |
If only I had copy pasted that one rule ^^ |
| # |
Mar 15th 2019, 16:30 |
lorro |
Holy shit, that fixed the whole damn thing. Thanks a lot, have really been looking for hours now ... :+1: |
| # |
Mar 15th 2019, 16:24 |
berarma |
`->where(['CashRegisters.id = SubLatestClosedReports.cash_register_id'])` |
| # |
Mar 15th 2019, 16:06 |
slackebot |
'SubLatestClosedReports.cash_register_id', 'type' => null, 'placeholder' => 'c0' ] ], ` If I manually replace the c0 by an ID and run it in phpmyadmin i have the wanted results. Anybody got a clue what I'm missing here? |
| # |
Mar 15th 2019, 16:06 |
slackebot |
->where(['SubLatestClosedReports.closed IS NOT' => null]) ->where(['CashRegisters.id' => 'SubLatestClosedReports.cash_register_id']) ->order(['SubLatestClosedReports.closed' => 'DESC']) ->limit(1); return $exp->add([ 'LatestClosedReports.uuid' => $subquery, ]); } ]); ``` As soon as I add the condition |
| # |
Mar 15th 2019, 16:06 |
slackebot |
`CashRegisters.id' => 'SubLatestClosedReports.cash_register_id` the subquery doesn't return a thing. It produces this query: ` 'sql' => 'SELECT `SubLatestClosedReports`.`uuid` FROM `cash_register_reports` `SubLatestClosedReports`, `cash_registers` `CashRegisters` WHERE ((`SubLatestClosedReports`.`closed`) IS NOT NULL AND `CashRegisters`.`id` = :c0) ORDER BY `SubLatestClosedReports`.`closed` DESC LIMIT 1', 'params' => [ ':c0' => [ 'value' => |
| # |
Mar 15th 2019, 16:06 |
slackebot |
'className' => 'CashRegisterReports', 'foreignKey' => false, 'conditions' => function (QueryExpression $exp, Query $query) { $subquery = $query ->connection() ->newQuery() ->select(['SubLatestClosedReports.uuid']) ->from(['SubLatestClosedReports' => 'cash_register_reports', 'CashRegisters' => 'cash_registers']) |
| # |
Mar 15th 2019, 16:06 |
lorro |
Hi, I'm trying to setup a custom association that converts a hasMany association into a hasOne association. I would like to have a custom association that fetches the last created record of an associated model. I was following this subquery suggestion as mentioned on stackoverflow: https://stackoverflow.com/questions/30241975/how-to-limit-contained-associations-per-record-group but to no avail. ```php $this->hasOne('LatestClosedReports', [ |
| # |
Mar 15th 2019, 16:02 |
gareth.ellis |
php 7.2 |
| # |
Mar 15th 2019, 16:02 |
gareth.ellis |
php 7.1 |
| # |
Mar 15th 2019, 15:39 |
neon1024 |
No idea then, all i can think is that the problem is not where you think it is, but that it’s a result which has bubbled up from elsewhere |
| # |
Mar 15th 2019, 15:38 |
gareth.ellis |
operation operation is one of the following: LOCK_SH to acquire a shared lock (reader). LOCK_EX to acquire an exclusive lock (writer). LOCK_UN to release a lock (shared or exclusive). LOCK_NB to not block while locking. |
| # |
Mar 15th 2019, 15:38 |
gareth.ellis |
LOCK_EX is the arg passed to SplFileObject::flock() |
| # |
Mar 15th 2019, 15:38 |
gareth.ellis |
_File is an SplFileObject |
| # |
Mar 15th 2019, 15:37 |
gareth.ellis |
no LOCK_EX is an int |
| # |
Mar 15th 2019, 15:34 |
neon1024 |
I presume that’s not a stream resource then? |
| # |
Mar 15th 2019, 15:34 |
neon1024 |
So LOCK_EX is an instance of SplFileObject |
| # |
Mar 15th 2019, 15:30 |
gareth.ellis |
both are using `SplFileObject` under the hood |
| # |
Mar 15th 2019, 15:30 |
gareth.ellis |
the implementation of `FileEngine` looks very similar between 3.x and 2.x tbh |
| # |
Mar 15th 2019, 15:27 |
admad |
Sorry I now see you are using 2.x, my response was in reference to 3.x |
| # |
Mar 15th 2019, 15:26 |
gareth.ellis |
:) |
| # |
Mar 15th 2019, 15:26 |
gareth.ellis |
so |
| # |
Mar 15th 2019, 15:26 |
gareth.ellis |
but it has been for about 3 years |
| # |
Mar 15th 2019, 15:26 |
gareth.ellis |
migrating to linux is on our roadmap |
| # |
Mar 15th 2019, 15:26 |
gareth.ellis |
our prod servers run on windows too at the moment |
| # |
Mar 15th 2019, 15:26 |
gareth.ellis |
that would be nice |
| # |
Mar 15th 2019, 15:26 |
admad |
Start using a better dev environment :slightly_smiling_face: |
| # |
Mar 15th 2019, 15:26 |
gareth.ellis |
:) |
| # |
Mar 15th 2019, 15:26 |
gareth.ellis |
the venn diagram overlap of people who might be experiencing this is getting smaller |
| # |
Mar 15th 2019, 15:25 |
admad |
@gareth.ellis might be a windows specific issue. I haven't encountered issue with file cache on 7.2 on linux |
| # |
Mar 15th 2019, 15:20 |
gareth.ellis |
just wondered if anyone else had seen the same thing with cake |
| # |
Mar 15th 2019, 15:20 |
gareth.ellis |
i've read through the php bug list |
| # |
Mar 15th 2019, 15:20 |
gareth.ellis |
I can't see any changes in php 7.2 to do with streams/file system |
| # |
Mar 15th 2019, 15:20 |
gareth.ellis |
doesn't happen in php 7.1 |