SQL : Some index are missing, and primary not assigned

  • Hello,

    When I try to create a new WP user, it doesn’t works : all is empty (name, mail, etc.).
    So I look in phpMyAdmin that there’s no auto-increment assigned on user_id, no primary .. and no INDEX on the users table.
    The same for meta_users, wysija (I think) etc. ..

    What can I do ?
    I thought that I can do it manually for each table … but maybe there’s is a script or something for “repair” it more easily ?

    Here my tables where there is no index or primary or AI (I do not know which should have or not) :

    wp_12345_links
    wp_12345_options
    wp_12345_postmeta
    wp_12345_posts
    wp_12345_termmeta
    wp_12345_terms
    wp_12345_term_relationships
    wp_12345_term_taxonomy
    wp_12345_usermeta
    wp_12345_users
    wp_12345_wysijya_campaign
    wp_12345_wysijya_custom_field
    wp_12345_wysijya_email
    wp_12345_wysijya_email_user_stat
    wp_12345_wysijya_email_user_url
    wp_12345_wysijya_form
    wp_12345_wysijya_list
    wp_12345_wysijya_queue
    wp_12345_wysijya_url
    wp_12345_wysijya_url_mail
    wp_12345_wysijya_user
    wp_12345_wysijya_user_field
    wp_12345_wysijya_user_history
    wp_12345_wysijya_user_list

    Hope someone can help me
    Thank you in advance

  • The topic ‘SQL : Some index are missing, and primary not assigned’ is closed to new replies.