UNIQUE key doesn't work as it is supposed ? How to check and confirm if it is UNIQUE

Figure 6. Register Failure
<b>If you are using a database that supports the UNIQUE field
restraint, the registration will fail. During the creation of the
users table, the username and e-mail fields were defined as UNIQUE,
meaning values for those fields cannot be duplicated. CakePHP
recognizes the error when the database throws it and displays an
error.</b>

Hi guys can you help explain why the unique key for mine doesn't
work ? I set username and email as UNIQUE but I tried entering another
registration with a different username, but same email it went through
the registration and added on MySQL database table.... that means my
UNIQUE key not working properly huh ?....

Some advice please, I need to get this working it's a project I need
to work on after learning from all these tutorials. The tutorial above
is the Build a quick web by IBM tutorial registration page.....web
link provided by phpcake official website.

More info, I have checked on phpmyadmin that both the username and
email are in the UNIQUE column.

Pls help... Thank you.

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en