# Error in Bookmarker tut

**URL:** <https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202>\
**Category:** Uncategorized\
**Created:** [September 20, 2016, 8:30pm UTC](https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202 "2016-09-20T20:30:55Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![p3aul](https://avatars.discourse-cdn.com/v4/letter/p/e274bd/32.png) [@p3aul](https://discourse.cakephp.org/u/p3aul)\
**Post date:** [September 20, 2016, 8:30pm UTC](https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202/1 "2016-09-20T20:30:55Z")

</div>

Trying to work thru the beginner bookmarker tut. In the Sql script to create tables and fields the script uses a reserved name for a field name. that field is “password” apparently a reserved word in MySql because PHPmyAdmin flagged it. It ran okay when I substituted “password1” for the field name. My question is, 'Will that screw up the rest of the tutorial?  
Thanks,  
Paul

---

<div class="post-metadata">

**Author:** ![ali](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/ali/32/123_2.png) [@ali](https://discourse.cakephp.org/u/ali)\
**Post date:** [September 20, 2016, 8:45pm UTC](https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202/2 "2016-09-20T20:45:38Z")

</div>

No way, “password” isn’t a reserved keyword, everyone is using it all the time, even outside CakePHP 😃

Are you sure it wasn’t simply your browser that found it grammatically incorrect?

What happens if you simply rename it again?

And to answer your question: Yes, there’s a good chance that this will screw up things for you with the Auth component (you could configurate it manually, but that goes against convention over configuration)

---

<div class="post-metadata">

**Author:** ![p3aul](https://avatars.discourse-cdn.com/v4/letter/p/e274bd/32.png) [@p3aul](https://discourse.cakephp.org/u/p3aul)\
**Post date:** [September 20, 2016, 9:46pm UTC](https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202/3 "2016-09-20T21:46:27Z")

</div>

OK I guess that answered my question. Yes I’m sure it wasn’t flagged by my browser. It was flagged by MySql or maybe phpMyAdmin. When I altered the "password by placing a 1 in front of it it was accepted. Maybe my MySql installation is a newer version that does have it as a reserved word. "Bookmarker is an old tutorial that probably hasn’t been updated. What group of idiots would use a fielname like “password” anyway? That’s just asking for trouble when future versions of Msql would break it.

---

<div class="post-metadata">

**Author:** ![ali](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/ali/32/123_2.png) [@ali](https://discourse.cakephp.org/u/ali)\
**Post date:** [September 20, 2016, 10:09pm UTC](https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202/4 "2016-09-20T22:09:45Z")

</div>

Huh, so in the new version of MySQL “password” is a reserved keyword? Well, that’s annoying 😃

That means you will need to adapt the authentification handler accordingly: [http://book.cakephp.org/3.0/en/controllers/components/authentication.html#configuring-authentication-handlers](http://book.cakephp.org/3.0/en/controllers/components/authentication.html#configuring-authentication-handlers)

Btw, I use MariaDB, where that’s not a problem (yet D: )

---

<div class="post-metadata">

**Author:** ![p3aul](https://avatars.discourse-cdn.com/v4/letter/p/e274bd/32.png) [@p3aul](https://discourse.cakephp.org/u/p3aul)\
**Post date:** [September 20, 2016, 10:45pm UTC](https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202/5 "2016-09-20T22:45:49Z")

</div>

Yeah Maria is used in XAMPP, but I chose to use WAMP which was used by the cake tutorial on [Lynda.com](http://Lynda.com). which I am having my troubles with Lynda also. She just doesn’t seem good for me. I ve tried several of her tutorials and have had problems and can’t get answers.

---

<div class="post-metadata">

**Author:** ![ali](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.cakephp.org/ali/32/123_2.png) [@ali](https://discourse.cakephp.org/u/ali)\
**Post date:** [September 21, 2016, 1:04am UTC](https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202/6 "2016-09-21T01:04:10Z")

</div>

Well, all learning resources will probably have their flaws, especially if they’re not up to date…

Imho, it’s helpful to have a working example app installed like [https://github.com/Xety/Xeta](https://github.com/Xety/Xeta) that you can use as a reference when you’re not sure how to accomplish something.

---

<div class="post-metadata">

**Author:** ![p3aul](https://avatars.discourse-cdn.com/v4/letter/p/e274bd/32.png) [@p3aul](https://discourse.cakephp.org/u/p3aul)\
**Post date:** [September 21, 2016, 9:28am UTC](https://discourse.cakephp.org/t/error-in-bookmarker-tut/1202/7 "2016-09-21T09:28:14Z")

</div>

I guess I’ll have to eat my words. Using phpMyAdmin I went back in to that CakePHP database I created and changed password1 back to “password” with no problems. Go figure!