Log message #4217958

# At Username Text
# Dec 9th 2019, 21:36 slackebot2 are more things. So I ask, so that my collaboration is not in vain and ends up in a maze that no one else understands anything: how to proceed? I've worked with documentation and text editing, and it was not easy for me to understand cakephp with the documentation that now said one thing then exemplified another .... [13h15] hummmm .... until the message above didn't get that big ... I thought it would get worse ...:,)
# Dec 9th 2019, 21:36 slackebot2 "PeopleController and LatestArticlesController" and "/ articles / view maps to ArticlesController view () method", which is different: 'People' and 'Users', for Brazilian programmers refer to different things. See another example on the same link, now under the topic "URL Considerations for Controller Names". The first sentence ends with "file name UsersController.php) is accessed from http://example.com/users." in the 3.x and 4.x documentation.
# 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