estoespersonal

Hi Steven

Yes, In fact what I’ve did is move first my wp_users table with all the registers in it without dropping the table. The second thing was to copy all the registers from wp_usermeta. But when I’ve tried to change the role of the user (ex: userProcess1) I’ve got an error in the log like the one shown above:

WordPress database error Subquery returns more than 1 row for query UPDATE wp_usermeta SET meta_value = ‘a:1:{s:12:\”customrole1\”;b:1;}’ WHERE user_id = 763 AND meta_key = ‘wp_capabilities’ made by edit_user, wp_update_user, wp_insert_user, WP_User->set_role, update_user_meta, update_metadata

Do you think it has something to do with the indexes?

Hola Javier

Discúlpame por no responder, probé también con los slugs de los roles pero no había manera. Lo que hice fue dividir la carga de los usuarios, primero escogí el rol de CustomRole1 y cargué los 20 usuarios. Luego cargué los 50 usuarios del CustomRole2 poniendo por defecto de asignación ese rol (CustomRole2). Tenía un poco de prisa por hacerlo y manejar otras cosas así que no seguí investigando.

Hi people the code where I exit the page is the following:

<?php get_footer(); ?>
</body>

<?php
} else {
wp_redirect(wp_login_url());
exit;
}} ?>
What causes is the loss of information of my users in the table wp_usermeta, basically if I have information of the user with id 2 Uuser_test2) and the role of administrator or whatever role is identified it is automatically erased of the table. Do you know why is this happening?

Hi, Renu

Sadly my site is in a server that has no public internet access, so it’s in a private network for security reasons. What I’ve tried recently is changing the collate of the following tables:
ALTER TABLE wp_usermeta MODIFY meta_value VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE wp_usermeta MODIFY meta_value VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_usermeta MODIFY meta_key VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_usermeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_options CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_postmeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_aryo_activity_log CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_comments CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_commentmeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_posts CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_404 CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_groups CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_logs CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_snippets CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_redirection_items CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_termmeta CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_terms CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_term_relationships CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE wp_term_taxonomy CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

But it still doesn´t work. Do you know which fixes I’ve got to do in order to get my app running again? As I said it’s working in my preproduction server but when I migrated everything to the production server it crashes.

If you want I can show you the wp-config.php file but I’m pretty sure it has something to do with the database because if I try to login with the “newadmin” user and a mistaken password like “badpswd” it shows a message telling me that my password is incorrect.

What else can I do?