Log message #4020693

# At Username Text
# Apr 27th 2017, 15:51 joris_ for apache: `sudo a2enmod mod_rewrite andand sudo services apache2 restart
# Apr 27th 2017, 15:49 joris_ have you enable mod_rewrite ?
# Apr 27th 2017, 15:45 greenmanspirit hey all, I am on 2.x and when I set the document root to app/webroot, all of my routes seem to not work anymore. It is giving me a 404 for all of my routes.
# Apr 27th 2017, 15:30 dereuromark What you mean? Is that an issue? Worked for me so far.
# Apr 27th 2017, 15:29 inoas dereuromark did you notice that your parseLanguageList allows duplicates?
# Apr 27th 2017, 15:14 joris_ since where giving the timezone of the database (in app.php) and the timezone of our user (in bootstrap.php)
# Apr 27th 2017, 15:13 joris_ too bad it isn't build in
# Apr 27th 2017, 15:13 joris_ i was about to go build something like that
# Apr 27th 2017, 15:12 ndm @_joris https://gist.github.com/ndm2/13ea098bef56f0ddd63ed68514eceb3e might give you a hint. I wouldn't advise using it like that though, it's just old unfinished stuff :slightly_smiling_face:
# Apr 27th 2017, 15:12 joris_ doesn't look like there is automagic in that area
# 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