New User Roles Won’t Work

If you just upgraded to 2.5, then backup your database and try to force a database upgrade (set db_version to 6124).

Michael:
Ive been having this problem for the last couple versions, I think it might have been due to a plugin, but I am unsure.

Well might try my suggestion first.

Or, from another 2.5 install of WordPress, copy the value of the wp_user_roles record in wp_options to your working database.

A third option to consider is exporting (Manage->Export) your blog. Then dropping your database tables, doing the wp-admin/install.php, then importing (Manage->Import->WordPress).

I tried the force upgrade, that did nothing, it seems like everything to do with the users does not work, I can not change profile info..

I will try those other two suggestions early in the week..

Any other suggestions, Im hesitant to move the whole database over..

Bump? Anyone know a plugin to clean up my database?

Please? Any suggestions are really appreciated..

From what you wrote so far, it looks like in one of your earlier updates you destroyed your database. The level of destruction was not that high, that your blog rendered useless but with one of the latest updates you completely destroyed it.

As far as I’m concerned of, there is no tool that will test wordpress database integrity. I suggest that you create a new installation from scratch and you try to import export data via XML.

The exporting works fine, but when I get to the second installation and click import, it takes forever and then i get a php timeout..

Are you able to higher the timeout value and try again?

No. Thats the problem.

Okay, then I would consider to create a test-environment on your own box, for example with XAMPP. Get your online database to work locally and you can configure php like it pleases you. Then try the import locally. You can export the mysql database later on to you life host then.

i’m having the same issue. i was able to create users and edit roles in the past.

i’m looking at the database and seeing this for the users that were created a while back:

umeta_id user_id meta_key meta_value
15 3 wp_capabilities a:1:{s:13:”administrator”;b:1;}

but for the new users, these aren’t in there at all.