I'm using Magento CE 1.9.2.3 and enable email confirmation for registration. Email is sent as normal, but when I click the link, it always fails. The link is like this
https://domain.com/customer/account/confirm/?id=10&key=1fdc9eb4eb591cfaef5878b907348587
Later on, I found out that under customer_entity_varchar table, Magento stores the plain text (from the password) instead of the hash string, under attribute_id 16 (confirmation). When I change this plain text to the hash string, it works.
My question is, why Magento stores the plain text whilst email the hash string?