Log message #4212845

# At Username Text
# Nov 8th, 09:25 spriz I would assume the performance of such query is not great :) :)
# Nov 8th, 09:25 roel Oh thanks :)
# Nov 8th, 09:24 roel @spriz the date columns can be `null`
# Nov 8th, 09:19 spriz @roel but one way could be this: https://gist.github.com/Spriz/3862a1bee5a8d67ef7b85434e61be9ad
# Nov 8th, 09:14 noel @martonmiklosqdev I suggest you use xdebug in that case. Not sure why the line numbers aren't showing up correctly for you. This happens to me in JavaScript quite often and it's very annoying. I've never seen it in PHP.
# Nov 8th, 09:13 spriz @roel does the date column really have `0` and not `null` in the DB?
# Nov 8th, 08:59 roel `SELECT * FROM `<table>` WHERE `<fk_id>` IN (1,2)` ` ORDER BY GREATEST(COALESCE(`<date_column_1>`, 0), COALESCE(`<date_column_2>`, 0)) DESC` ` LIMIT 10`
# Nov 8th, 08:59 roel The query is as follows:
# Nov 8th, 08:59 roel Hello everyone, I have a SQL query that I would like to convert to a cakephp (3.6) query, but I have no clue how to do it and if it is even possible.
# Nov 8th, 08:19 javier.villanueva I think that your models are different than the models im thinking
# Nov 8th, 08:18 javier.villanueva morning all
# Nov 8th, 06:36 conehead Morning!
# Nov 8th, 06:17 alexdd55976 Morning
# Nov 8th, 01:50 ndm Check `$context['newRecord']`
# Nov 8th, 01:47 francisdoydora thanks in advance for your help :slightly_smiling_face:
# Nov 8th, 01:47 francisdoydora if update, allowEmptyFile. Else if create, follow the validator rule I posted.
# Nov 8th, 01:37 slackebot1 (isset($context['data']['academic_level_id'])) { return $context['data']['academic_level_id'] === '1'; } return true; })```
# Nov 8th, 01:37 francisdoydora if anyone could help me figure out how to return 'update' as default. But needs to return true or false on create. Right now allowEmptyFile returns false if academic_level_id is not equal to 1. But I didn't take into account if I want to edit. In edit it should always allow empty files. ```$validator ->allowEmptyFile('gmrc', 'Please upload a GMRC', function ($context) { if
# Nov 7th, 23:24 mrfeedback is there a way to disable a virtual field when a query is returning entities? In my case I dont need that specific field as it generates s3links which I wouldn´t use in that case. I tried to not select the field. but for some reason it still triggers
# Nov 7th, 22:41 slackebot1 <martonmiklosqdev>
# Nov 7th, 22:40 martonmiklosqdev I can see the problematic line in the variables pane:
# Nov 7th, 22:40 martonmiklosqdev the view errors a bit better
# Nov 7th, 22:40 martonmiklosqdev where the problem is in the view
# Nov 7th, 22:40 slackebot1 <martonmiklosqdev>
# Nov 7th, 22:39 martonmiklosqdev here is an another example
# Nov 7th, 22:39 martonmiklosqdev the problematic ItemTypesAttributesController only has 183 lines
# Nov 7th, 22:39 martonmiklosqdev refers to the Core/Controller.php
# Nov 7th, 22:38 martonmiklosqdev the line 609
# Nov 7th, 22:22 noel @martonmiklosqdev As far as I can see there are line numbers... have you looked at line 609 of your Controller?
# Nov 7th, 22:05 martonmiklosqdev I will read back the messages tomorrow
# Nov 7th, 22:05 martonmiklosqdev if anyone has any idea please let me know
# Nov 7th, 21:40 martonmiklosqdev is it a configuration problem of the apache/PHP or is it a CakePHP config issue?
# Nov 7th, 21:40 martonmiklosqdev error_reporting = E_ALL
# Nov 7th, 21:39 martonmiklosqdev in the php.ini I set all error/debug flags
# Nov 7th, 21:38 martonmiklosqdev I think it is since I upgraded to PHP7
# Nov 7th, 21:38 martonmiklosqdev it does not shows the problematic line number
# Nov 7th, 21:38 martonmiklosqdev https://i.imgur.com/SCJ9sCW.png
# Nov 7th, 21:38 martonmiklosqdev I have some trouble with the error pages
# Nov 7th, 21:37 martonmiklosqdev Hello all,
# Nov 7th, 17:36 dev.cyrusjayson I get error like the gave_fruits does not exist
# Nov 7th, 17:36 dev.cyrusjayson not yet. I will try this tomorrow. looks much easier.