MySQL wp_users, wp_usermeta

  • Resolved soosdani

    (@soosdani)


    6 years, 6 months ago

    Hello,

    I’m sorry, but I speak a little English.

    Manually added my old users in MySQL (phpMyAdmin):

    INSERT INTO wp_users ( ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name )
VALUES ( '', '', '', '', '[email protected]', '', '2018-09-25 11:50:48', '', 0, '' );
INSERT INTO wp_users ( ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name )
VALUES ( '', '', '', '', '[email protected]', '', '2018-09-25 15:27:38', '', 0, '' );

    The 2 user ID is 8 and 9 and I added more info (with WooCommerce):

    INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 8, 'first_name', 'John' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 8, 'last_name', 'Smith' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 8, 'description', 'OpenCart (#5)' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 8, 'billing_first_name', 'John' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 8, 'billing_last_name', 'Smith' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 8, 'billing_email', '[email protected]' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 8, 'billing_phone', '012345678' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 9, 'first_name', 'Joe' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 9, 'last_name', 'Smith' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 9, 'description', 'OpenCart (#6)' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 9, 'billing_first_name', 'Joe' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 9, 'billing_last_name', 'Smith' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 9, 'billing_email', '[email protected]' );
INSERT INTO wp_usermeta ( umeta_id, user_id, meta_key, meta_value ) VALUES ( '', 9, 'billing_phone', '876543210' );

    I would like try lost password remember request email in my site for [email protected], but no email. Why?

    Another users email remember is ok.

    The request email after I see the wp_users for this two old user user_activation_key is xxxxxxxx same. All other users this user_activation_key column is empty.

    I would like the old users (that I added manually) they can password change.

    Please help me! Thanks.

    • This topic was modified 6 years, 6 months ago by soosdani.
    • This topic was modified 6 years, 6 months ago by soosdani.
    • This topic was modified 6 years, 6 months ago by soosdani.
    • This topic was modified 6 years, 6 months ago by soosdani.
    • This topic was modified 6 years, 6 months ago by Steven Stern (sterndata).
Viewing 3 replies - 1 through 3 (of 3 total)
  • Moderator bcworkz

    (@bcworkz)

    6 years, 6 months ago

    Sadly, emails can fail for any number of reasons that are outside the control of WP. If one user’s email goes out successfully but another does not, the problem is external to WP. Did one old user check their spam folder? Email sent from servers often end up there. If the email is forwarded through a different address, there is a greater chance the email will not reach the intended recipient. Use a direct address if possible. Do they have an alternate address through a different domain? Some mail servers are better at delivering mail than others.

    WP will send email for a user record with no other data entered, but they will not be able to do anything in WP unless their user meta contains a “wp_capabilities” entry specifying their role as a serialized array. You could copy the value from another user’s record with the same role from within phpMyAdmin. You should give them a login name as well.

    If all else fails, set a temp password for their user so they can log in with it and set the password to their choosing.

    Thread Starter soosdani

    (@soosdani)

    6 years, 6 months ago

    The first seven users have a username and my two manually user is not username because the wp_users.user_login is empty. If I change this, the password reminder emails are sent. The problem is solved. Thank you very much!

    Moderator bcworkz

    (@bcworkz)

    6 years, 6 months ago

    That’s good news. You’re most welcome.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘MySQL wp_users, wp_usermeta’ is closed to new replies.