Log message #4217956

# At Username Text
# Dec 9th 2019, 21:36 luizcmarin Hi. I'm working on the portuguese translation. But the current Portuguese translation is somewhat confusing. It is different from the original in English. For example, https://book.cakephp.org/3/en/intro/conventions.html uses "UsersController and ArticleCategoriesController" and "/ users / view maps to view () method of the UsersController" in controller conventions. In documentation 4.x follows the same. Already in Portuguese appears
# Dec 9th 2019, 21:36 luizcmarin I would like to get a broader feedback from the other project participants on the subject below because the Portuguese translation is so outdated. It's very discouraging ... a pity after so much effort from those who have devoted themselves to this work. "
# Dec 9th 2019, 20:21 slackebot2 idea ....
# Dec 9th 2019, 20:21 luizcmarin @ndm "Yeah, maybe you're taking it a tiny step to do it @luizcmarin, CakePHP licenses don't cost 1000+ dollars, so CakeSF could afford employing a dedicated documentation team. Surely there's quite some room for improvement, but you got to keep your expectations real " You're right. If I had 1000 dollars I would do all the documentation since I have some free time due to the severe fibromyalgia that attacks me. And until you gave a good
# 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?