| # |
Jun 26th 2018, 12:14 |
 saeideng |
@ghasem ^^ |
| # |
Jun 26th 2018, 12:13 |
saeideng |
{ id , f2_id,f1_id } |
| # |
Jun 26th 2018, 12:13 |
saeideng |
you can have 1 field as primary key , and 2 others as unique key |
| # |
Jun 26th 2018, 12:12 |
saeideng |
I think composite primary no needed in cake 3 |
| # |
Jun 26th 2018, 11:58 |
adriencs |
File uploaded https://cakesf.slack.com/files/U5WD6SWR2/FBDEC2H6U/image.png / https://slack-files.com/T053DPNCM-FBDEC2H6U-0d2141c27c |
| # |
Jun 26th 2018, 11:11 |
neon1024 |
Especially as there are significant changes in the ORM between the two releases! :slightly_smiling_face: |
| # |
Jun 26th 2018, 11:11 |
neon1024 |
Can you be any more specific? Ideally a specific use-case and a certain major release of the framework? |
| # |
Jun 26th 2018, 10:54 |
ghasem |
Hello my friends. How to use composite primary key on model in Cakekphp3 or Cakephp2? |
| # |
Jun 26th 2018, 10:50 |
neon1024 |
I guess you’d just end up with `$minutes / 60` for your setting ;) |
| # |
Jun 26th 2018, 10:49 |
neon1024 |
Perhaps 15 minutes though? Can you tell me 15 minutes in seconds off-hand? |
| # |
Jun 26th 2018, 10:49 |
neon1024 |
I can’t imagine that my session would time out in say 120 seconds |
| # |
Jun 26th 2018, 10:49 |
neon1024 |
Plus, I find it easier to think in minutes than seconds |
| # |
Jun 26th 2018, 10:48 |
neon1024 |
Translating between the two isn’t really hard |
| # |
Jun 26th 2018, 10:44 |
LubosR |
it also says it should not be more than php.ini session.gc_maxlifetime, which is set in seconds. isnt that wrong we deal with same thing in minutes / seconds? |
| # |
Jun 26th 2018, 10:43 |
LubosR |
app.php says session timeout is in minutes, is that correct? |
| # |
Jun 26th 2018, 10:11 |
rudy1976s |
I fixed by getting out from the select whose fields which can’t be grouped |
| # |
Jun 26th 2018, 10:05 |
rudy1976s |
is the query “formally” correct ? |
| # |
Jun 26th 2018, 10:04 |
rudy1976s |
I think this is not the correct way of using association because grouping won’t work |
| # |
Jun 26th 2018, 10:03 |
rudy1976s |
https://gist.github.com/rudy1976s/6f36b3b09f57cef3082db586a664a4cd |
| # |
Jun 26th 2018, 10:03 |
rudy1976s |
I have a query like the following |
| # |
Jun 26th 2018, 10:02 |
rudy1976s |
Since you need to group by all the “non aggregated” fields in the select |
| # |
Jun 26th 2018, 10:01 |
rudy1976s |
between mysql and mssql |
| # |
Jun 26th 2018, 10:01 |
rudy1976s |
but I have different results using ORM |
| # |
Jun 26th 2018, 10:01 |
neon1024 |
Setting the mode should work I think :slightly_smiling_face: |
| # |
Jun 26th 2018, 10:01 |
rudy1976s |
now it works in correct way |
| # |
Jun 26th 2018, 10:00 |
rudy1976s |
yes |
| # |
Jun 26th 2018, 10:00 |
neon1024 |
Which version? 10.x ? |
| # |
Jun 26th 2018, 10:00 |
rudy1976s |
that’s true |
| # |
Jun 26th 2018, 10:00 |
rudy1976s |
I am using MariaDB to be more precise |
| # |
Jun 26th 2018, 10:00 |
neon1024 |
Technically the way that MySQL allowed GROUP BY wasn’t correct SQL |
| # |
Jun 26th 2018, 10:00 |
neon1024 |
MySQL 5.7 I think, fixed it’s broken Grouping. |
| # |
Jun 26th 2018, 10:00 |
neon1024 |
Well that’s not technically correct |
| # |
Jun 26th 2018, 09:59 |
rudy1976s |
I have some issue I am not able to solve related to associations: I had to set my mysql in ONLY_FULL_GROUP_BY to be compatible with MsSql mode of grouping |
| # |
Jun 26th 2018, 09:58 |
rudy1976s |
good morning to anyone! |
| # |
Jun 26th 2018, 09:45 |
egalles |
i'll try to enable them |
| # |
Jun 26th 2018, 08:58 |
steinkel |
you could configure your datasource https://github.com/cakephp/debug_kit/blob/master/config/bootstrap.php#L47 |
| # |
Jun 26th 2018, 08:57 |
neon1024 |
I could go look that up I guess ;) |
| # |
Jun 26th 2018, 08:57 |
steinkel |
wait, you mean if it could be configured to use mysql? |
| # |
Jun 26th 2018, 08:56 |
steinkel |
no, it uses sqlite |
| # |
Jun 26th 2018, 08:54 |
neon1024 |
@steinkel Is debug kit configurable to use MySQL? Just a random question :slightly_smiling_face: |
| # |
Jun 26th 2018, 08:49 |
LubosR |
had to follow above cake doc first to allow custom blackhole method of course |
