Unknown column 'EMAIL' in 'field list'

Suddenly I get the error listed in the topic title whenever a new user goes to their profile. Nothing has changed except I switched servers.

I’m not sure exactly when the error started as whoever was already registered before this error happened can go to their profile just fine, it’s just the new people that register that experience this error. Checking the users table new registered users have the same data showing in the table as long time users as well.

I’m novice-intermediate in terms of mysql/php/wordpress. I don’t even know which table this is pulling from. I’m thinking if I just add “EMAIL” to table in question it will go away?

I’ve searched and seen a lot of similar errors on here, and have tested all of those that I could understand to no success. Nothing in the admin panel is showing it needs updating, when I run the /wp-admn/update extension it says my database is already updated.

Any help would be greatly appreciated. I have full Cpanel and PhpMyAdmin access on my server.

My wp_user table looks like this:

1 ID bigint(20) UNSIGNED No None AUTO_INCREMENT
2 user_login varchar(60) utf8mb4_unicode_ci No
3 user_pass varchar(64) utf8mb4_unicode_ci No
4 user_nicename varchar(50) utf8mb4_unicode_ci No
5 user_email varchar(100) utf8mb4_unicode_ci No
6 user_url varchar(100) utf8mb4_unicode_ci No
7 user_registered datetime No 0000-00-00 00:00:00
8 user_activation_key varchar(60) utf8mb4_unicode_ci No
9 user_status int(11) No 0
10 display_name varchar(250) utf8mb4_unicode_ci No