Invalid argument supplied for foreach() in wp-capabilities.php: Case Cracked! [en]

[fr] Le problème avec wp-capabilities.php qui fait qu'on peut se retrouver "exfermé" (enfermé dehors) de son blog WordPress (typiquement en cas de changement de serveur) semble avoir sa source dans le contenu du champ wp_user_roles dans la table wp_options. En particulier, pour la version française, "Abonné" est un rôle d'utilisateur, et en cas de problèmes d'encodage MySQL, le caractère accentué sera corrompu, causant ainsi l'erreur.

Il suffit de remplacer le caractère fautif dans PhpMyAdmin, et on retrouve l'accès à son blog. Bon, reste ensuite à régler les questions d'encodage... mais c'est déjà ça!

Finally. At last. Endlich. Enfin.

Once more, while trying to transfer a WordPress installation from one server to another, I found myself facing the dreaded problem which locks me out of my WordPress install with a rather cryptic message:

Warning: Invalid argument supplied for foreach() in /home/user/wp/wp-includes/capabilities.php on line 31

(Your lineage may vary.)

What happens is that WordPress cannot read user roles, and therefore, even though your password is accepted, you get a message telling you that you’re not welcome in the wp-admin section:

Vous n’avez pas les droits suffisants pour accéder à cette page.

Or, in English:

You do not have sufficient permissions to access this page.

A quick search on the WordPress forums told me that I was [not alone in my fight with wp-capabilities.php](http://wordpress.org/search/wp-capabilities.php?forums=1), but that many problems had not been resolved, and more importantly, that suggested solutions often did not work for everyone.

I’ve bumped into this problem a couple of times before, and I knew that it was linked to encoding problems in the database. (I’ve had my share of encoding problems: [once](http://climbtothestars.org/archives/2004/07/18/converting-mysql-database-contents-to-utf-8/), [twice](http://climbtothestars.org/archives/2005/02/19/problemes-dencodage-mysql/), [thrice](http://climbtothestars.org/archives/2006/07/12/finally-out-of-mysql-encoding-hell/) — “once” being on of the most-visited posts on this blog, by the way, proof if needed that [I’m not alone with mysql encoding issues](http://wordpress.org/search/mysql+encoding?forums=1) either.)

I’ll leave the detailed resolution of how to avoid/cure the MySQL problems later (adding
mysql_query("SET NAMES 'utf8'");
to wp-db.php as detailed in [this thread](http://wordpress.org/support/topic/55282?replies=7#post-311649), and as [zedrdave](http://unknowngenius.com/blog/) had already previously told me to do — should have listened! — should prevent them). So anyway, adding that line to my *working* WordPress install showed me that the problem was not so much in the database dumping process than in the way WordPress itself interacted with the database, because the dreaded wp-capabilities.php problem suddenly appeared on the original blog.

Now, this is where I got lucky. Browsing quickly through the first dozen or so of [forum threads about wp-capability.php problems](http://wordpress.org/search/wp-capabilities.php?forums=1), [this response](http://wordpress.org/support/topic/67796?replies=18#post-392812) caught my eye. It indicated that the source of the problem was the content of the wp_user_roles field (your prefix may vary). In this case, it had been split on more than one line.

I headed for the database, looked at the field, and didn’t see anything abnormal about it at first. All on one line, no weird characters… just before giving up, I moved the horizontal scrollbar to the end of the line, and there — **Eurêka!** I saw it.

Abonné

“Contributor”, in French, is “abonné”, with an accent. Accent which got horribly mangled by the MySQL problems which I’ll strive to resolve shorty. Mangled character which caused the foreach() loop to break in wp-capabilities.php, which caused the capabilities to not be loaded, which caused me to be locked out of my blog.

So, in summary: if you’re locked out of your blog and get a warning/error about wp-capabilities and some invalid foreach() loop thingy, head for PhpMyAdmin, and look carefully through the wp_user_roles field in the wp_options table. If it’s split over two or more lines, or contains funky characters, you have probably found the source of your problem.

Good luck!

Similar Posts:

20 thoughts on “Invalid argument supplied for foreach() in wp-capabilities.php: Case Cracked! [en]

  1. Mmmh, would say me changing the translation file to say “Abonné” instead of “Abonné” would solve the problem for future generations ?

  2. It would. eacute. What would also solve the problem would be adding that utf-8 line in wp-db.php. Will try to catch the WP people about that.

  3. It is a good solution if you use UTF8, but not everyone is. WordPress core seems to need a more comprehensive solution.

  4. Salut Steph’
    j’ai eu également une l’erreur suivante en upgradant à la version WP 2.1

    Fatal error: Call to undefined function: wp_get_current_user() in /home/cybexpor/public_html/wp-includes/capabilities.php

    Ca ressemble un peu à ton erreur. Ce qui m’a sauvé fut simplement de reuploader sur le serveur le répertoire wp-includes…

    A jeudi!
    david

  5. As a total n00b to WP and PHP I cannot tell what in my table might be causing this problem. I’ve managed to dig this up from PHPMyAdmin; I think it is the correct field:

    a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;a:48:{s:13:”switch_themes”;i:1;s:11:”edit_themes”;i:1;s:16:”activate_plugins”;i:1;s:12:”edit_plugins”;i:1;s:10:”edit_users”;i:1;s:10:”edit_files”;i:1;s:14:”manage_options”;i:1;s:17:”moderate_comments”;i:1;s:17:”manage_categories”;i:1;s:12:”manage_links”;i:1;s:12:”upload_files”;i:1;s:6:”import”;i:1;s:15:”unfiltered_html”;i:1;s:10:”edit_posts”;i:1;s:17:”edit_others_posts”;i:1;s:20:”edit_published_posts”;i:1;s:13:”publish_posts”;i:1;s:10:”edit_pages”;i:1;s:4:”read”;i:1;s:8:”level_10″;i:1;s:7:”level_9″;i:1;s:7:”level_8″;i:1;s:7:”level_7″;i:1;s:7:”level_6″;i:1;s:7:”level_5″;i:1;s:7:”level_4″;i:1;s:7:”level_3″;i:1;s:7:”level_2″;i:1;s:7:”level_1″;i:1;s:7:”level_0″;i:1;s:17:”edit_others_pages”;i:1;s:20:”edit_published_pages”;i:1;s:13:”publish_pages”;i:1;s:12:”delete_pages”;i:1;s:19:”delete_others_pages”;i:1;s:22:”delete_published_pages”;i:1;s:12:”delete_posts”;i:1;s:19:”delete_others_posts”;i:1;s:22:”delete_published_posts”;i:1;s:20:”delete_private_posts”;i:1;s:18:”edit_private_posts”;i:1;s:18:”read_private_posts”;i:1;s:20:”delete_private_pages”;i:1;s:18:”edit_private_pages”;i:1;s:18:”read_private_pages”;i:1;s:12:”delete_users”;i:1;s:12:”create_users”;i:1;s:17:”unfiltered_upload”;i:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:34:{s:17:”moderate_comments”;i:1;s:17:”manage_categories”;i:1;s:12:”manage_links”;i:1;s:12:”upload_files”;i:1;s:15:”unfiltered_html”;i:1;s:10:”edit_posts”;i:1;s:17:”edit_others_posts”;i:1;s:20:”edit_published_posts”;i:1;s:13:”publish_posts”;i:1;s:10:”edit_pages”;i:1;s:4:”read”;i:1;s:7:”level_7″;i:1;s:7:”level_6″;i:1;s:7:”level_5″;i:1;s:7:”level_4″;i:1;s:7:”level_3″;i:1;s:7:”level_2″;i:1;s:7:”level_1″;i:1;s:7:”level_0″;i:1;s:17:”edit_others_pages”;i:1;s:20:”edit_published_pages”;i:1;s:13:”publish_pages”;i:1;s:12:”delete_pages”;i:1;s:19:”delete_others_pages”;i:1;s:22:”delete_published_pages”;i:1;s:12:”delete_posts”;i:1;s:19:”delete_others_posts”;i:1;s:22:”delete_published_posts”;i:1;s:20:”delete_private_posts”;i:1;s:18:”edit_private_posts”;i:1;s:18:”read_private_posts”;i:1;s:20:”delete_private_pages”;i:1;s:18:”edit_private_pages”;i:1;s:18:”read_private_pages”;i:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:10:{s:12:”upload_files”;i:1;s:10:”edit_posts”;i:1;s:20:”edit_published_posts”;i:1;s:13:”publish_posts”;i:1;s:4:”read”;i:1;s:7:”level_2″;i:1;s:7:”level_1″;i:1;s:7:”level_0″;i:1;s:12:”delete_posts”;i:1;s:22:”delete_published_posts”;i:1;}}s:11:”contributor”;a:2:{s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:6:{s:10:”edit_posts”;i:1;s:20:”edit_published_posts”;i:1;s:4:”read”;i:1;s:7:”level_1″;i:1;s:7:”level_0″;i:1;s:12:”delete_posts”;i:1;}}s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:2:{s:4:”read”;i:1;s:7:”level_0″;i:1;}}}

    Does anyone know if I am looking at the right thing, and if so, what might the actual problem be? I don’t see any mangled characters.

    Thanks to anyone who can help.

    Andrew

  6. ah I see my row is not wrapping – sorry. I don’t see anything that looks wrong in it but will keep at it. If I find anything will post here and on the WP forums.

  7. Thank you, thank you, thank you! The User roles area was where I was having troubles.

    Cheerful Trails,

    Christian

  8. You are a life saver, thank you! I looked for hours and even my hosting company was not able to help… now it’s fixed!

  9. you guys are much too good for me.

    “So, in summary: if you’re locked out of your blog and get a warning/error about wp-capabilities and some invalid foreach() loop thingy, head for PhpMyAdmin, and look carefully through the wp_user_roles field in the wp_options table. If it’s split over two or more lines, or contains funky characters, you have probably found the source of your problem.”

    so it is scrambled (abonné). what should I do?

  10. Bon, j’avoue, j’ai paniqué. Donc je ne suis plus exfermée sur mon blog. Y a-t-il une manière simple de modifier tous les caractères “scramblés” sur mon blog?
    D’autant que j’en ai d’autres à upgrader , et autrement plus verbeux.
    Merci de m’avoir fourni la solution, quand même…

  11. Bon, j'avoue, j'ai paniqué. Donc je ne suis plus exfermée sur mon blog. Y a-t-il une manière simple de modifier tous les caractères “scramblés” sur mon blog?
    D'autant que j'en ai d'autres à upgrader , et autrement plus verbeux.
    Merci de m'avoir fourni la solution, quand même…

  12. I’m having a heck of a time trying to move servers.. it’s not letting me post now as an admin, and the user roles have changed in WP 3.0.1 Soo…. I found your post, but I don’t think it’s all I need. :)

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>