# |
Oct 8th 2018, 18:28 |
edgaras.jan |
or if you wish first form ``` 'OR' => [ ['DATE(specific_date)' => '2018-10-24'], ['DATE(specific_date)' => '2018-10-24'], ['DATE(specific_date)' => '2018-10-24'], 'week_day IN' => [1,4,3,6], ] ``` |
# |
Oct 8th 2018, 18:25 |
edgaras.jan |
`SELECT * from `seminars` where (DATE(specific_date) IN ('2018-10-24', '2018-10-25', '2018-10-29')) OR week_day IN (1,4,3,6)` |
# |
Oct 8th 2018, 18:25 |
nk-sonu |
in dated we can use IN ? @edgaras.jan |
# |
Oct 8th 2018, 18:25 |
nk-sonu |
i am confused in "OR" |
# |
Oct 8th 2018, 18:24 |
edgaras.jan |
use `IN` |
# |
Oct 8th 2018, 18:24 |
slackebot |
<nk-sonu> |
# |
Oct 8th 2018, 18:21 |
nk-sonu |
hi. what to do if i want to search multiple dates compare in OR in mysql with same 1 field ? |
# |
Oct 8th 2018, 18:14 |
developer |
Hi Guys. Hope all doing well. I was stuck in cakephp or condition. I want to use multiple OR condition with 3 different dates from same field. |
# |
Oct 8th 2018, 16:46 |
ricksaccous |
actually i figured out the replace strat thing |
# |
Oct 8th 2018, 16:42 |
rrd564 |
and I want to sort after the grouping |
# |
Oct 8th 2018, 16:42 |
rrd564 |
The collection is after a groupBy |
# |
Oct 8th 2018, 16:41 |
rrd564 |
Is there a way to sort a collection by the index of its items? Something lige ksort for arrays? |
# |
Oct 8th 2018, 15:07 |
ricksaccous |
some of them require looking at matching data on other models |
# |
Oct 8th 2018, 15:07 |
ricksaccous |
because i only want deletions in the replace based on certain conditions |
# |
Oct 8th 2018, 15:07 |
ricksaccous |
because while i do want some replace-like behavior sometimes on this project there always seems to be some quirk to it |
# |
Oct 8th 2018, 15:06 |
ricksaccous |
I'd love for a more robust replace strategy |
# |
Oct 8th 2018, 14:56 |
ricksaccous |
in saveStrategy replace, would it be possible to set replace conditions or something? |
# |
Oct 8th 2018, 14:54 |
ricksaccous |
ok |
# |
Oct 8th 2018, 14:54 |
martin |
no, only in before :( |
# |
Oct 8th 2018, 14:53 |
ricksaccous |
but not in aftersave huh |
# |
Oct 8th 2018, 14:53 |
martin |
and the fields are dirty that are changed |
# |
Oct 8th 2018, 14:53 |
martin |
In the beforesave you have the orignal data |
# |
Oct 8th 2018, 14:52 |
ricksaccous |
actually i want to compare old data with new data |
# |
Oct 8th 2018, 14:52 |
ricksaccous |
is it possible to compare request data with data actually saved? |
# |
Oct 8th 2018, 14:51 |
ricksaccous |
in cakephp3 aftersave |
# |
Oct 8th 2018, 14:45 |
martin |
I know, walking tru the code now slowly checking where it stops :S |
# |
Oct 8th 2018, 14:44 |
ricksaccous |
good luck |
# |
Oct 8th 2018, 14:44 |
ricksaccous |
that's horrible |
# |
Oct 8th 2018, 14:44 |
ricksaccous |
oh |
# |
Oct 8th 2018, 14:44 |
martin |
did work till a few hours ago, thats why I don’t understand it :S |
# |
Oct 8th 2018, 14:44 |
martin |
yes |
# |
Oct 8th 2018, 14:42 |
ricksaccous |
have you read the server configuration set up instructions for cakephp3? |
# |
Oct 8th 2018, 14:42 |
ricksaccous |
apache or nginx? |
# |
Oct 8th 2018, 14:42 |
ricksaccous |
what are you using |
# |
Oct 8th 2018, 14:41 |
martin |
nothing in logs already tried to enable debug and logging to be sure, but nothing, keeps loading |
# |
Oct 8th 2018, 14:40 |
ricksaccous |
@martin have you checked the server logs, apache, and/or nginx? |
# |
Oct 8th 2018, 14:17 |
martin |
and I don’t see any errors, only that my php-fpm is full with handling the requests |
# |
Oct 8th 2018, 14:16 |
martin |
other project works fine. but this projects fail, even the old releases what did run before without any problems |
# |
Oct 8th 2018, 14:16 |
martin |
and I’m clueless now what can be the reason, |
# |
Oct 8th 2018, 14:15 |
martin |
I’ve on production server that it does not handle requests anymore with cakephp 3.6. when I call a script in webroot directory it works fine, but index.php no response |
# |
Oct 8th 2018, 13:57 |
ricksaccous |
no problem ;) |