Log message #4217853

# At Username Text
# Dec 9th 2019, 11:24 challgren Client originally had it written in DropWizard but the higher quality cameras mess with barcode reading. So device side with a webservice it is
# Dec 9th 2019, 11:22 challgren @ndm im really replacing a webservice that use to decode the images on the server side but now Im trying to read Code 128 and Datamatrix so doing it device side is our better option, provides the quickest feedback to the user and its not an endless loop of uploading an image, having it fail decoding and then the user has to try again.
# 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