# |
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) |
# |
Oct 17th 2019, 14:10 |
ricksaccous |
order->(['destinations.validfrom' => 'desc']); |