| # |
Apr 27th 2017, 15:04 |
 joris_ |
no problem, i'll debug the behavior of cake ;) |
| # |
Apr 27th 2017, 14:58 |
bravo-kernel |
:thumbsup: wish I could spoonfeed the solution but since things are a bit quiet right now the logs might help |
| # |
Apr 27th 2017, 14:57 |
joris_ |
thanks @bravo-kernel , will have a look, if i find out how it's working, i'll make a blog post about it ;) |
| # |
Apr 27th 2017, 14:55 |
bravo-kernel |
I don't remember the specifics but have seen that question (many times) before. You might find it here https://irc.cakephp.org/?q=timezone |
| # |
Apr 27th 2017, 14:55 |
bravo-kernel |
@joris_ |
| # |
Apr 27th 2017, 14:52 |
joris_ |
i change the date_default_timezone_set in bootstrap.php according to the user, but all times who get saved to the database are in locale timezones and not UTC |
| # |
Apr 27th 2017, 14:51 |
joris_ |
I've set the timezone in MySQL to UTC and also set the timezone in app.php database config to UTC |
| # |
Apr 27th 2017, 14:46 |
joris_ |
Anyone has experience with users in multiple timezones in cake3 ? |
| # |
Apr 27th 2017, 14:39 |
bravo-kernel |
should not be too hard looking at the API specs https://github.com/gothinkster/realworld/tree/master/api |
| # |
Apr 27th 2017, 14:38 |
inoas |
nopes |
| # |
Apr 27th 2017, 14:38 |
inoas |
strategy select? |
| # |
Apr 27th 2017, 14:38 |
bravo-kernel |
calling on all bakers, how about adding a CakePHP (Crud) API backend here. This seems to be the next go-to comparison, we could be in. https://github.com/gothinkster/realworld |
| # |
Apr 27th 2017, 14:38 |
inoas |
hm |
| # |
Apr 27th 2017, 14:37 |
inoas |
https://gist.github.com/inoas/96f13acb90ec173d7d2b534211a008e1#file-sql-sql-L4-L5 |
| # |
Apr 27th 2017, 14:37 |
inoas |
instead of creating a virtual table |
| # |
Apr 27th 2017, 14:37 |
inoas |
thats what I am building, and everything is / was correct aside the inner JOIN ... there it just puts all the where conditions as ON conditions |
| # |
Apr 27th 2017, 14:36 |
inoas |
okay so innerJoin it should be eh |
| # |
Apr 27th 2017, 14:36 |
inoas |
I was trying like this https://gist.github.com/inoas/e55bfdc5f7ba0eb4a4b4e17ba79e9428 |
| # |
Apr 27th 2017, 14:35 |
dakota |
That normally works better by using innerJoin directly |
| # |
Apr 27th 2017, 14:34 |
inoas |
e.g. like a group - finding siblings |
| # |
Apr 27th 2017, 14:34 |
inoas |
I want to do a self join on a sub part of the primary key |
| # |
Apr 27th 2017, 14:34 |
dakota |
innerJoinWith is for associations, so it would probably work if you declared an association for the virtual table |
| # |
Apr 27th 2017, 14:33 |
inoas |
only possible via innerJoin()? |
| # |
Apr 27th 2017, 14:33 |
inoas |
anyone knows how to innerJoinWith a virtual table? |
| # |
Apr 27th 2017, 14:18 |
megan |
Lurdekan, everyone is here voluntarily :slightly_smiling_face: Be kind to those around us <3 |
| # |
Apr 27th 2017, 14:18 |
Lurdekan |
megan: such an awesome member that can't even take a hint |
| # |
Apr 27th 2017, 14:18 |
Lurdekan |
megan: My question wasn't stupid, pointless or obnoxious |
| # |
Apr 27th 2017, 14:17 |
Lurdekan |
megan: He was just patronizing, didn't properly read the question, nor did understand it. He should have at least asked for more info before tolding me to repeat pointless steps |
| # |
Apr 27th 2017, 14:15 |
megan |
lurdekan, Neon1024 was just trying to be helpful and he is a super awesome community member! :slightly_smiling_face: Never hurts to check the docs again or to try google/SO again or wait to see if there is anyone else who may have a different answer |
| # |
Apr 27th 2017, 14:14 |
Lurdekan |
megan: It's the typical kind of kid that doesn't even properly reads the question before answering |
| # |
Apr 27th 2017, 14:13 |
Lurdekan |
megan: he told me to check docs. that isn't helpful, I clearly said I checked all the docs |
| # |
Apr 27th 2017, 14:11 |
megan |
Lurdekan - maybe also post a question on discourse and if someone else maybe has a better answer for you they can post it there (that may not be online atm) |
| # |
Apr 27th 2017, 14:11 |
Lurdekan |
Neon1024: I had done that already |
| # |
Apr 27th 2017, 14:11 |
Lurdekan |
Neon1024: Telling someone to check the docs again, looking at the debugkit, or the source code is also being a dickhead |
| # |
Apr 27th 2017, 14:11 |
megan |
Thanks for helping Neon1024 |
| # |
Apr 27th 2017, 14:10 |
Neon1024 |
!askhole |
| # |
Apr 27th 2017, 14:10 |
Neon1024 |
Geez. |
| # |
Apr 27th 2017, 14:10 |
Neon1024 |
I’m trying. |
| # |
Apr 27th 2017, 14:10 |
Neon1024 |
Jut because you don’t like the answer dont’ throw it in my face |
| # |
Apr 27th 2017, 14:10 |
Neon1024 |
I tried to help |
| # |
Apr 27th 2017, 14:10 |
Neon1024 |
Don’t be a dickhead. |