Changing User ID Breaks Gravatar

Any updates on this?

johnwebsites,

I’m guessing here, but are you using a plugin to display your Gravatar image? If so, have you tried to re-installed it? Or maybe the Better WP Security didn’t change the user ID ‘1’ to other number for that plugin in MySQL database?

I know the following, but maybe there are some other places WP / plugins input User ID…

UPDATE wp-prefix_users SET id = ‘9999’ WHERE id = ‘1’;
UPDATE wp-prefix_usermeta SET user_id = ‘9999’ WHERE user_id = ‘1’;
UPDATE wp-prefix_posts SET post_author = ‘9999’ WHERE post_author = ‘1’;
UPDATE wp-prefix_comments SET user_id = ‘9999’ WHERE user_id = ‘1’;

Sorry, I’m just guessing here.

I just found it, it might helps:

https://www.ads-software.com/support/topic/plugin-better-wp-security-user-id-1-changed-my-gravatar-no-longer-shows-on-my-own-blog?replies=18