# |
Apr 27th 2017, 16:42 |
pedroseco |
Hi guys. |
# |
Apr 27th 2017, 16:35 |
dariolap |
records on applications that have the same agent_id and company_id |
# |
Apr 27th 2017, 16:35 |
dariolap |
Hi all, I have a model Applications that belongs to Agents and Companies.... when i save on Applications i also add Agent and Company entities (if they exists)....now, the problem at buildRules level... i have added $rules->isUnique(['agent_id', 'company_id'] on ApplicationsTable the problem is that cake is not "mapping" agent_id by looking ad the Agent entity i have passed (same thing for company entity) in this case i am able to save multiple |
# |
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 |