Old admin comments shown as guest

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

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

Are those changes made correct?

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?

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