Log message #4217851

# At Username Text
# Dec 9th 2019, 11:09 gianmarxgagliardi I uploaded the DB of the old tutorial that you told me not to use
# Dec 9th 2019, 11:07 ndm I'm getting mixed signals here. If you have a `username` column, then you didn't follow the guide from the beginning, as the example schema doesn't contain a `username` column.
# Dec 9th 2019, 11:05 gianmarxgagliardi @ndm exactly thanks
# Dec 9th 2019, 11:04 slackebot2 ```<h1>Login</h1> <?= $this->Form->create() ?> <?= $this->Form->control('username') ?> <?= $this->Form->control('password') ?> <?= $this->Form->button('Login') ?> <?= $this->Form->end() ?>```
# Dec 9th 2019, 11:04 gianmarxgagliardi in the guide says to do the template like this: ```<h1>Login</h1> <?= $this->Form->create() ?> <?= $this->Form->control('email') ?> <?= $this->Form->control('password') ?> <?= $this->Form->button('Login') ?> <?= $this->Form->end() ?>``` so it gives me this error: ```Database Error PDOException Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Users.email' in 'where clause'``` to make it work I changed as follows:
# Dec 9th 2019, 11:03 ndm @gianmarxgagliardi The error message is pretty clear, the `email` column is missing. Check your database schema and compare it against what the tutorial shows: https://book.cakephp.org/3/en/tutorials-and-examples/cms/database.html
# Dec 9th 2019, 10:58 ndm @challgren Sounds like you want to migrate to a hybrid capacitor cross-platorm web component based ionic app powered by vuejs... I heard that stuff makes your life soo much easier :)
# Dec 9th 2019, 10:57 gianmarxgagliardi I follow this guide to login --> https://book.cakephp.org/3/en/tutorials-and-examples/cms/authentication.html after I entered the user and try to log in it gives me the following error ```Database Error PDOException Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'Users.email' in 'where clause'```
# Dec 9th 2019, 10:57 val By the way, using `'rule' => [$this, 'checkMyRule'],` instead of the closure validation rule also works fine.
# Dec 9th 2019, 10:52 val @ndm I found it :slightly_smiling_face: https://book.cakephp.org/3/en/orm/validation.html#creating-custom-rule-objects
# Dec 9th 2019, 10:45 slackebot2 <challgren>
# Dec 9th 2019, 10:34 ndm @val The ORM is quite a large API, I don't remember reading anything like that. Events, Middlewares, yes, but in the ORM, no idea.
# Dec 9th 2019, 10:31 challgren Yeah true, zxing processing wore me out last week
# Dec 9th 2019, 10:31 jotpe Finishing feels always better than starting something new , imo.
# Dec 9th 2019, 10:30 challgren Should I finish an Android app or starting implementing a complex feature in my cake app
# Dec 9th 2019, 10:21 val @ndm Yes, I know. I saw the instructions somewhere in the cookbook, not in the API docs. Somewhere in the pages related to ORM and queries.
# Dec 9th 2019, 10:19 ndm @val Any class that implements `__invoke()` is callable, you may want to be a little more specific as to what CakePHP API you're referring to.
# Dec 9th 2019, 10:19 dereuromark go for it. I still enjoy my morning coffee here
# Dec 9th 2019, 10:18 challgren What about a biscuit?
# Dec 9th 2019, 10:18 dereuromark enjoy with a cookie and a cup of tea
# Dec 9th 2019, 10:18 challgren Haha yep!
# Dec 9th 2019, 10:18 dereuromark haha, need your daily morning advice?
# Dec 9th 2019, 10:16 slackebot2 !dereuromark-advice
# Dec 9th 2019, 10:16 slackebot2 Command sent from Slack by challgren:
# Dec 9th 2019, 10:16 slackebot2 ! dereuromark-advice
# Dec 9th 2019, 10:16 slackebot2 Command sent from Slack by challgren:
# Dec 9th 2019, 10:12 val Hi, I remember I saw the description of how to use classes instead closures in the 3.x cookbook but I can't find it now. Can anyone point to the right place to look?
# Dec 9th 2019, 09:59 ndm @ynherag Use the operators function equivalent, `jsonb_exists_any()`, or upgrade to PHP 7.4 which introduced support for escaping parameter placeholders, so that you can do `??|` (the first question mark is the escape character). https://stackoverflow.com/questions/36173440/how-to-ignore-question-mark-as-placeholder-when-using-pdo-with-postgresql https://wiki.php.net/rfc/pdo_escape_placeholders
# Dec 9th 2019, 09:03 jotpe *Line:* 573
# Dec 9th 2019, 09:03 jotpe *File* /usr/www/users/xxx/xxx-dev/vendor/cakephp/cakephp/src/Error/Debugger.php
# Dec 9th 2019, 09:02 jotpe *Error:* Nesting level too deep - recursive dependency?
# Dec 9th 2019, 09:02 jotpe Anyone has a clue why this occurs on my dev server?
# Dec 9th 2019, 08:49 neon1024 Hey everyone
# Dec 9th 2019, 08:47 conehead Good morning
# Dec 9th 2019, 08:44 slackebot2 transformation from `?` to `$1` ?
# Dec 9th 2019, 08:44 ynherag Hi here, how do i use the symbol _question mark_ in a query for which it's not a parameter. I'm using the postgresql jsonb `?|` operator. ```$query->sql(); SELECT Flags.id AS "id" FROM flags Flags WHERE (colors ?| string_to_array('red,blue',',')``` ```$query->toArray(); Error: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "$1" LINE 1: ....FROM flags Flags WHERE (colors $1| string... ^``` Is there a trick to prevent the
# Dec 9th 2019, 08:32 gianmarxgagliardi Morning
# Dec 9th 2019, 08:32 javier.villanueva morning
# Dec 9th 2019, 08:20 jotpe Morning
# Dec 9th 2019, 02:46 latenal Hi, is there a way to pass an option to an associated table using `contain`? The reason is that I am using a soft-delete plugin. I need to pass a `withDeleted` option in order to disable it for certain tables.
# Dec 9th 2019, 01:22 ndm Yeah, maybe you're taking it a tiny step to far there @luizcmarin, CakePHP licenses don't cost 1000+ dollars, so that CakeSF could afford employing a dedicated documentation team. Surely there's quite some room for improvement, but you've got to keep your expectations real ;)