Log message #4209298

# At Username Text
# Oct 17th 2019, 16:02 neon1024 This is
# Oct 17th 2019, 16:02 felipe.marinho I have so many fields to do that :,(
# Oct 17th 2019, 16:02 neon1024 Or `ltrim()` `rtrim()`
# Oct 17th 2019, 16:02 neon1024 Or `preg_replace()`
# Oct 17th 2019, 16:02 neon1024 Or `str_replace()`
# Oct 17th 2019, 16:01 neon1024 Do.. do you mean.. the php function `trim()~
# Oct 17th 2019, 16:01 felipe.marinho Hello, there's any plugin to trim spaces in strings? :thinking_face:
# Oct 17th 2019, 15:59 neon1024 I thought Collection::firstMatch
# Oct 17th 2019, 15:59 neon1024 I want to see if my Companies have ‘websites’ set, which will be an array of WebsiteEntities
# Oct 17th 2019, 15:58 neon1024 Can I check if a result set’s entities have non-empty properties?
# Oct 17th 2019, 15:29 ndm It certainly won't make them faster, but it also doesn't necessarily have to overly slow them down, it really depends on the query and how you can rewrite it to conform to the strict mode. Not a fan, but if applicable there's `ANY_VALUE()`, which will give you the same behavior as with ONLY_FULL_GROUP_BY disabled.
# Oct 17th 2019, 15:21 ricksaccous yeah but it slows down queries though :(
# Oct 17th 2019, 14:58 ndm @mrfeedback There's a good reason the strict mode exists. In the lax mode MySQL will usually pick non-aggregated rows from the groups in a nondeterministic manner, unless you can force MySQL to pick a specific one. So be careful and make sure that you really receive the correct data with ONLY_FULL_GROUP_BY disabled.
# Oct 17th 2019, 14:52 mrfeedback is there a way to access the main query when using matching? I need to adapt the where statements according to the type of product. And so far i dont see any other option to achieve that
# Oct 17th 2019, 14:50 mrfeedback yes I am absolutely with you
# Oct 17th 2019, 14:46 hippo might not matter but it's good to be careful
# Oct 17th 2019, 14:45 francis.nadal @admad I figured it out thanks hehe
# Oct 17th 2019, 14:44 mrfeedback hmm thanks for the hint!
# Oct 17th 2019, 14:44 mrfeedback true story
# Oct 17th 2019, 14:44 hippo yeah until someone upgrades mysql
# Oct 17th 2019, 14:44 hippo or thats what id' do at least
# Oct 17th 2019, 14:44 mrfeedback i just tested it. its turned off on the server
# Oct 17th 2019, 14:44 hippo like adding in a check to see if it's disabled in bootstrap
# Oct 17th 2019, 14:43 hippo if you turn it off you need to be sure that whoever is managing servers for this knows that it needs to be turned off
# Oct 17th 2019, 14:42 mrfeedback lets say i want to select all proejcts with `producttype_id=1` and `producttype_id=2`. But if it is `producttype_id=1` I need to have in projectfilestable fullfilled two conditions `projectfile.marketingthumb>0` and `projectfile.videothumb>0` but if it is `producttype_id=2` it is only need for `projectfile.marketingthumb > 0`. any ideas how i could create such a query with cake?
# Oct 17th 2019, 14:37 mrfeedback i have to admit db is just an untouched mysql 5.7 docker container
# Oct 17th 2019, 14:37 mrfeedback hmm so you think i should turn it off?
# Oct 17th 2019, 14:31 francis.nadal @admad sorry, where should I put the dd(func_get_args())?
# Oct 17th 2019, 14:28 ricksaccous geez
# Oct 17th 2019, 14:28 ricksaccous that thing slows down queries a lot
# Oct 17th 2019, 14:28 ricksaccous lmao
# Oct 17th 2019, 14:27 neon1024 Guess we’re sticking with MySQL 5.7 then :,)
# Oct 17th 2019, 14:26 graziel iirc they said they will disable that switch as some point so it will come back
# Oct 17th 2019, 14:25 neon1024 I must admit, I tend to turn it off myself
# Oct 17th 2019, 14:24 neon1024 I think it’s because this is incompatible with sql_mode=only_full_group_by
# Oct 17th 2019, 14:14 slackebot1 tables like `marketinginfos`
# Oct 17th 2019, 14:14 mrfeedback any idea why `$query->distinct(['Projects.id']);` `$query->group('Projects.id');` does not work? I get `PDOException: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #33 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'vvv_test.Marketinginfos.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by` as I am also joining other
# Oct 17th 2019, 14:12 ricksaccous i did something similar in a subquery join
# Oct 17th 2019, 14:11 ckjksl but would that take a while?
# Oct 17th 2019, 14:11 ckjksl I could get unique ids from all the items first and then foreach id, search for their latest entry
# Oct 17th 2019, 14:11 ckjksl Yes, that would work if i was looking for a particular item. But I'm trying to get all the latest entry of all the items (from a certain date)