| # |
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? |
| # |
Jun 26th 2018, 07:37 |
egalles |
File uploaded https://cakesf.slack.com/files/UBF2Q239V/FBDAAUB6C/-.txt / https://slack-files.com/T053DPNCM-FBDAAUB6C-61e1c1211b |
| # |
Jun 26th 2018, 07:36 |
egalles |
Hi, I'm trying to install cakephp3 in plesk and all it works when i'm trying to visit the frontend part of cakephp3 (demo index page working ok, database working ok etc...) but I cannot make any bake ? This is my error, but I think that i've got all extensions dependencies ok, Can anyone help me please ? |
| # |
Jun 26th 2018, 06:51 |
LubosR |
$this->layout in error400 works, but still better to solve my helper load problem though |
| # |
Jun 26th 2018, 06:37 |
LubosR |
Still no luck with html helper error when ExceptionRenderer is used. How do I set layout for error (exception renderer)? |
| # |
Jun 26th 2018, 06:31 |
LubosR |
OK, thanks, giving it a try :) |
| # |
Jun 26th 2018, 06:29 |
saeideng |
$this->viewBuilder()->helpers(['MyHelper']); |