2. Please go on my sites and click on login at the top right. The link "Did not receive confirmation email?" goes to http://www.domain.com/user/lost/ . Could you please let me know how to fix this?
3. I still have this bug, I sent you an email. I'm not sure, but i think this bug happen to users who created account when 1) wasn't fixed.
]]>$this->query('SET SQL_MODE=""');
after:
$this->query('SET CHARACTER SET utf8');
2. Hmm...this should go to domain.com/user/confirm/ for email confirmation and domain.com/user/lost/ for password recovery. I will test this.
3. Hmm...it works for me. Just tested!
]]>A lot of users contact me because of those bugs:
1) When a user registers, after filling form and click on create account, he is redirected to this error:
Query: INSERT INTO user_profile SET user_id = 1626
Error Message: Field 'about' doesn't have a default value
Error Number: 1364
The account is still created but he doesn't receive confirmation email.
2) When clicking on login and Did not receive confirmation email? he is redirected to http://www.domain.com/user/lost/ and receive login and password informations but not link confirmation.
3) In admin - User - Edit a user: and click on edit at the bottom of the page i get this error:
Query: SELECT user_id FROM user WHERE user_id = LIMIT 1
Error Message: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1
Error Number: 1064
I sent you an email.
]]>