# |
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']); |
# |
Oct 17th 2019, 14:10 |
ricksaccous |
->limit(1); |
# |
Oct 17th 2019, 14:09 |
ckjksl |
I need the last entry from today, not all the entries from today |
# |
Oct 17th 2019, 14:09 |
ricksaccous |
what's the problem here |
# |
Oct 17th 2019, 14:09 |
ricksaccous |
so wouldn't that make sense |
# |
Oct 17th 2019, 14:09 |
ricksaccous |
you are getting anything less than today it seems |
# |
Oct 17th 2019, 14:08 |
ckjksl |
this is cool and all, but I think this experession actually gets me both the Feb 2019 entry and the May 2019 entry |
# |
Oct 17th 2019, 14:08 |
ckjksl |
right now I have: `->andWhere(function($exp) use($validdate) { $exp->lte('destinations.validfrom', $validdate);return $exp;})` |
# |
Oct 17th 2019, 14:07 |
ckjksl |
I have multiple entries for the same item, but each of the entries have a valid date. Example: if i search with a date of Feb 2019, I will only find things valid from Feb 2019. If there is a change in May 2019 and I search today, I should get the latest version, which is the May 2019. |
# |
Oct 17th 2019, 14:06 |
ricksaccous |
use date time objects in the ORM |
# |
Oct 17th 2019, 14:05 |
ckjksl |
I've got a question about ORM and searching with dates |
# |
Oct 17th 2019, 14:04 |
mehov |
Okay, `$this->request->getSession()->read('Auth.User')` - but won't `request` get deprecated and replaced with `getRequest()` in 4.x? |