| # |
Dec 9th 2019, 19:46 |
 japerlman |
I tried using \" to force the quotes in but that just creates a different error |
| # |
Dec 9th 2019, 19:45 |
japerlman |
It's building the query as SELECT (SUM(ClientLogs.hours)) instead of SELECT (SUM("ClientLogs"."hours")) |
| # |
Dec 9th 2019, 19:19 |
japerlman |
]: Undefined table: 7 ERROR: missing FROM-clause entry for table "clientlogs" LINE 1: SELECT (SUM(ClientLogs.hours)) AS "hours", "ClientLogs"."cli... ^ |
| # |
Dec 9th 2019, 19:19 |
japerlman |
Works, but if I switch the comment for the send line, trying to SUM that same field |
| # |
Dec 9th 2019, 19:19 |
japerlman |
``` $logReport ->select([ //'hours' => $logReport->func()->sum('ClientLogs.hours'), 'ClientLogs.hours', 'ClientLogs.client_id'``` |
| # |
Dec 9th 2019, 19:19 |
japerlman |
Sorry, wasn't done formatting. |
| # |
Dec 9th 2019, 19:18 |
japerlman |
Can someone help with SUM() on a query? I have this and it works, but if I try to SUM that same field with $logReport ->select([ 'hours' => $logReport->func()->sum('ClientLogs.hours'), //'ClientLogs.hours', 'ClientLogs.client_id' |
| # |
Dec 9th 2019, 18:24 |
jotpe |
This works with the sql from the cms tutorial |
| # |
Dec 9th 2019, 18:24 |
gianmarxgagliardi |
I think it's a problem related to the sessions |
| # |
Dec 9th 2019, 18:23 |
jotpe |
@gianmarxgagliardi https://github.com/julianpollmann/cakephp-auth |
| # |
Dec 9th 2019, 18:20 |
gianmarxgagliardi |
in the meantime, someone can help me with my problem --> https://stackoverflow.com/questions/59253645/login-does-not-work-does-not-log-in-even-if-the-credentials-are-correct |
| # |
Dec 9th 2019, 18:19 |
gianmarxgagliardi |
@jotpe thanks |
| # |
Dec 9th 2019, 17:30 |
jotpe |
@gianmarxgagliardi I guess there is no sample project, I'll create one ;) |
| # |
Dec 9th 2019, 17:16 |
gianmarxgagliardi |
the problem is that with the new guide I wouldn't know exactly where you start. Is there not an example of a project? |
| # |
Dec 9th 2019, 16:33 |
slackebot2 |
test case to demonstrate this but _clients_ |
| # |
Dec 9th 2019, 16:33 |
sdevore |
If you are using DebugKit as well I have seen this happen with nested entities when building the Variables tab. usually due to the ->getErrors() call in vendors/cakephp/cakephp/src/Datasource/EntityTrait.php around line 1462 (in version 3.7.x which I am currently working in. If I pass in false in ` ```'[hasErrors]' => $this->hasErrors(false),``` ` in `public function __debugInfo()` I seem to be ok. II’m planning on trying to figure out |
| # |
Dec 9th 2019, 16:17 |
jotpe |
You can use the same db setup like described here: https://book.cakephp.org/3/en/tutorials-and-examples/cms/database.html#cms-tutorial-creating-the-database |
| # |
Dec 9th 2019, 16:17 |
jotpe |
I would do it. Or simply test it in another app. |
| # |
Dec 9th 2019, 16:14 |
gianmarxgagliardi |
should I redo the project from scratch this way? |
| # |
Dec 9th 2019, 16:04 |
jotpe |
@gianmarxgagliardi yes, it's different and uses a Middleware. See https://book.cakephp.org/authentication/1/en/migration-from-the-authcomponent.html |
| # |
Dec 9th 2019, 16:02 |
Ecorce |
The only solution I can see is to create another database, just for this CakePHP app... |
| # |
Dec 9th 2019, 15:54 |
gianmarxgagliardi |
@jotpe it is completely different as compared to the previous guide. For example in the section "Configuring Authentication Handlers" talk about how to change the loadComponent in AppController.php ? |
| # |
Dec 9th 2019, 15:41 |
Ecorce |
I wanted to use this other workaround, but I don't understand how to implement it : https://gist.github.com/burzum/06a0037c7ad8bcaf3333 |
| # |
Dec 9th 2019, 15:41 |
Ecorce |
I'm sad... I really need the prefix. This is for a big project using the same database as other linked apps... |
| # |
Dec 9th 2019, 15:40 |
Ecorce |
And when writing the correct joinTable, then it looks for bad foreignKeys... *prefix_table1_table2.prefix_foreign_key* |
| # |
Dec 9th 2019, 15:38 |
Ecorce |
Cake looks for a join table called : **prefix_table1_prefix_table2**... which should be just prefix_table1_table2 |
| # |
Dec 9th 2019, 15:37 |
Ecorce |
But it seems there are issues with associations. At least, belongsToMany. |
| # |
Dec 9th 2019, 15:37 |
Ecorce |
My first try was to add in every Table initialize method a $this->table() with the tablename and its prefix. |
| # |
Dec 9th 2019, 15:36 |
Ecorce |
I'm in CakePHP 3.3.16 |
| # |
Dec 9th 2019, 15:36 |
Ecorce |
In trouble implementing prefixe in database config... trying to use the workarounds. |
| # |
Dec 9th 2019, 15:35 |
Ecorce |
Hello everyone |
| # |
Dec 9th 2019, 15:32 |
jotpe |
You're welcome :slightly_smiling_face: |
| # |
Dec 9th 2019, 15:28 |
koeller |
@jotpe: Thank you so much. I did a `bin/cake plugin assets symlink` and recieved an error, that `/webroot/debug_kit` already exists. I deleted it and now everything just works fine. Funny thing is that in my other projects I don’t have a symlink in `/webroot`. |
| # |
Dec 9th 2019, 15:23 |
jotpe |
The Plugin also works in 3.8 |
| # |
Dec 9th 2019, 15:23 |
gianmarxgagliardi |
I'm developing with version 3.8 |
| # |
Dec 9th 2019, 15:22 |
jotpe |
@gianmarxgagliardi for a new App I would start with AuthencationPlugin, since Cake4x will not wait for too long. |
| # |
Dec 9th 2019, 15:21 |
gianmarxgagliardi |
@jotpe should I redo everything from scratch? |
| # |
Dec 9th 2019, 15:18 |
jotpe |
https://book.cakephp.org/3/en/controllers/components/authentication.html |
| # |
Dec 9th 2019, 15:17 |
jotpe |
@gianmarxgagliardi better try to get Authentication working with the Authentication Plugin, since AuthComponent is deprecated: https://book.cakephp.org/authentication/1/en/index.html |
| # |
Dec 9th 2019, 15:15 |
jotpe |
did you also do `bin/cake plugin assets symlink` |
| # |
Dec 9th 2019, 15:14 |
koeller |
@jotpe: Yep, tried both :( |