Other Users don't have Roles and Capabilities

Using this code

SELECT *
FROM wp_usermeta
LEFT JOIN wp_users ON wp_users.ID = user_id
WHERE meta_key = 'wp_capabilities'

I found out that I other users that were on my blog doesn’t have a meta_value for wp_capabilities. I only need a code or a snippet on how I could update other users roles and capabilities. The last time I manually inserted values for the wp_capability went wrong as number of users doubled

You should not have to insert any code. Are you using the dashboard and users to control the role? You can select all (except admin and those you don’t want to change) and edit all the roles at once.

A clean update? Use the dashboard/updates to reinstall or update wp.

I forgot that I’m running a WordPress MS. The SQL files that I uploaded on my database came from a WordPress MU, the old site I administered before I updated my site, and its meta keys for the users are set to “wp_1_capabilities”.

This the link for the screenshot:
https://www.facebook.com/photo.php?fbid=388436224513861&set=a.374251569265660.91956.100000424603595&type=3&theater

What I did before is that I ran a fresh install of WordPress 3.1.1 cause I was lazy to update the old version of WordPress that I was using. When I uploaded the wp_users and wp_usermeta, I encountered this issue and this issue.

I did a query to update the database and set the meta keys to “wp_capabilities”. Thus resolves this issue

Thanks @kmessinger and sorry for the late reply ??