how to change user roles for users who doesn’t have any. (about 8000 users)

You can do it by executing simple SQL query:

UPDATE wp_usermeta
   SET meta_value="a:1:{s:11:"contributor";b:1;}" 
 WHERE meta_key = 'wp_capabilities' 
   AND meta_value="a:1:{s:10:"subscriber";b:1;}"

This query will updated all subscribers to be contributors.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)