Please open phpMyAdmin of your WordPress database and execute this SQL:
UPDATE wp_comments SET comment_author = 'admin', user_id = 1 WHERE user_id = 0
Important:
1. Make sure your WordPress database table prefix is ‘wp_’
2. Make sure admin username is ‘admin’
3. Make sure admin user id is 1
Thread Starter
EDV11
(@edv11)
Thanks for your fast answer
1. The database table prefix is ‘wp_’
2. Admin username is ‘EDV11’
3. Admin user id is 3
I run this command
UPDATE wp_comments SET comment_author = ‘EDV11’, user_id = 3 WHERE user_id = 0
But it gives me an SQL syntax error
Thread Starter
EDV11
(@edv11)
Are those changes made correct?
Thread Starter
EDV11
(@edv11)
I just checked the table manually, and all the comments are marked as user_id = 0, no matter if the comments are made by the admin, a user or a guest.
How about comment_author field? What do you see there?
Thread Starter
EDV11
(@edv11)
Ok, here is how I did it
UPDATE wp_comments SET comment_author = 'EDV11', user_id = 3 WHERE comment_author_email = '[email protected]'
After that query all my comments are marked as Admin.
Thanks again
