| # |
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 |
| # |
Jun 26th 2018, 08:48 |
LubosR |
saeideng not sure what you meant, but in case anyone interested, this is going to work for me https://pastebin.com/t14AM6Bc |
| # |
Jun 26th 2018, 08:43 |
steinkel |
debugkit will need php-sqlite extension too |
| # |
Jun 26th 2018, 08:42 |
steinkel |
@egalles looks like your server is missing the php-mysql extension |
| # |
Jun 26th 2018, 08:40 |
saeideng |
hi |
| # |
Jun 26th 2018, 08:40 |
neon1024 |
Morning all |
| # |
Jun 26th 2018, 08:39 |
saeideng |
SecurityException |
| # |
Jun 26th 2018, 08:39 |
saeideng |
‍‍``` } catch (SecurityException $se) { $this->blackHole($controller, $se->getType(), $se); } ``` |
| # |
Jun 26th 2018, 08:38 |
LubosR |
This is fine https://book.cakephp.org/3.0/en/controllers/components/security.html#handling-blackhole-callbacks but can I say in blackhole method what exception has been raised? |
| # |
Jun 26th 2018, 08:24 |
LubosR |
Where to catch exceptions raised by SecurityComponent |
| # |
Jun 26th 2018, 08:22 |
LubosR |
Might be stupid question, but what is the best way to catch AuthSecurityException? I mean in what part of app code |
| # |
Jun 26th 2018, 07:38 |
egalles |
I come from cakephp2 |
| # |
Jun 26th 2018, 07:38 |
egalles |
Also, I installed DebugKit pluggin and the toolbar does not show ? (No error reported in logs) Any idea about that? |