Update: I may have found the cause of the problem and its due to the column name “users_url” not existing on my current wp_users table. I have found this out by using a dummy wordpress and comparing the wp_users table.
I have tried adding it back to the wp_users table but it seemed to have not done anything. The sql command that i used is
ALTER TABLE wp_users
ADD users_url varchar(100) not null
Is there anything i can do to restore it back?
Thanks