Timeline for Clients with empty username are not receiving request new password email
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 9, 2018 at 9:44 | history | edited | Jeanne Kidaw | CC BY-SA 4.0 |
deleted 1 character in body
|
| Aug 9, 2018 at 9:43 | vote | accept | Leandro Andrade | ||
| Aug 9, 2018 at 9:43 | comment | added | Leandro Andrade | I had to remove the comma before WHERE and it works. Thank you | |
| Aug 8, 2018 at 16:15 | comment | added | Leandro Andrade |
Thank you for replaying, I am not good using phpmyadmin, I went to the wp_users table, click on SQL tab and paste the code you informed. But I got this error: SQL query: UPDATE wp_users SET user_login = CONCAT("user", ID), WHERE user_login = "" MySQL said: Documentation #1064 - 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 'WHERE user_login = ""' at line 1
|
|
| Aug 8, 2018 at 15:47 | history | answered | Jeanne Kidaw | CC BY-SA 4.0 |