Log message #4179968

# At Username Text
# Mar 16th 2019, 14:43 martonmiklosqdev_cake thank you both
# Mar 16th 2019, 12:33 challgren @martonmiklosqdev_cake might want to change satooshi/php-coveralls to php-coveralls/php-coveralls too
# Mar 16th 2019, 12:26 martonmiklosqdev_cake @admad thanks you are awesome!
# Mar 16th 2019, 12:21 admad currently it's using the phpunit preinstall in travis VM instead of the specific version cake wants
# Mar 16th 2019, 12:20 admad @martonmiklosqdev_cake change from `phpunit --stderr` to `vendor/bin/phpunit` https://github.com/martonmiklos/cakephp-utils/blob/dc19703268f59da568acb1f5fbaf687757640c76/.travis.yml#L42
# Mar 16th 2019, 12:07 grossolive4 thanks so much !, It seems difficult to integrate with router plugin and app router
# Mar 16th 2019, 11:48 martonmiklosqdev_cake I am new to the phpunit testing so any help would be appericiated
# Mar 16th 2019, 11:48 martonmiklosqdev_cake I got a bunch of Cannot redeclare class PHPUnit\Framework\Test in ... warnings
# Mar 16th 2019, 11:47 martonmiklosqdev_cake https://travis-ci.com/martonmiklos/cakephp-utils/jobs/185399841
# Mar 16th 2019, 11:47 martonmiklosqdev_cake my tests failing on Travis
# Mar 16th 2019, 11:47 martonmiklosqdev_cake however
# Mar 16th 2019, 11:47 martonmiklosqdev_cake I have managed to fix the most of the warnings/errors so the phpunit tests passes on my dev box
# Mar 16th 2019, 11:46 martonmiklosqdev_cake https://github.com/martonmiklos/cakephp-utils/tree/fix_mfr_pr
# Mar 16th 2019, 11:46 martonmiklosqdev_cake to work with cake 3.7
# 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