Warning: array_keys() expects parameter 1 to be array, boolean given in wp-admin/includes/class-wp-users-list-table.php on line 196

Otro castañazo para la colección de cosas que pasan todos los días …

En este caso, un wordpress multidominio que al listar usuarios aparece este mensaje de error

[shell]

Warning: array_keys() expects parameter 1 to be array, boolean given in /home/sitename/public_html/wp-admin/includes/class-wp-users-list-table.php on line 196

[/shell]

En este caso estuve trasteando bastante con las bases de datos ya que el cliente nos pidió algo muy específico para su worpdress y alguna cosa se quedaría perdida por ahí… el caso es que nos falta la informacion de los roles que se puede consultar con esta SQL:

[sql]

select * from wp_options where option_name=’wp_user_roles’ ;

[/sql]

Debería generar una fila de resultados y el contenido de ‘option_value‘ debe ser esto :

[php]

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

[/php]

Este chorro es el contenido serializado de un array de roles

Así que, para arreglar el error y que podamos editar tranquilamente los perfiles de los usuarios trendremos que editar o insertar el contenido por cada sitio del multistio WPMU.

Como nota, los sitios de wpmu usan las tablas de forma que agregan un ID a partir del site 2 de forma que el prefijo de las tablas es wp_2_options para el caso del site 2.

[sql]

insert into wp_3_options SET option_value=’a:5:{s:13:»administrator»;a:2:{s:4:»name»;s:13:»Administrator»;s:12:»capabilities»;a:47:{s:13:»switch_themes»;b:1;s:11:»edit_themes»;b:1;s:16:»activate_plugins»;b:1;s:12:»edit_plugins»;b:1;s:10:»edit_users»;b:1;s:10:»edit_files»;b:1;s:14:»manage_options»;b:1;s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:6:»import»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:8:»level_10″;b:1;s:7:»level_9″;b:1;s:7:»level_8″;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;s:12:»delete_users»;b:1;s:12:»create_users»;b:1;s:14:»edit_dashboard»;b:1;}}s:6:»editor»;a:2:{s:4:»name»;s:6:»Editor»;s:12:»capabilities»;a:33:{s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;}}s:6:»author»;a:2:{s:4:»name»;s:6:»Author»;s:12:»capabilities»;a:10:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:4:»read»;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;s:22:»delete_published_posts»;b:1;}}s:11:»contributor»;a:2:{s:4:»name»;s:11:»Contributor»;s:12:»capabilities»;a:6:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:4:»read»;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;}}s:10:»subscriber»;a:2:{s:4:»name»;s:10:»Subscriber»;s:12:»capabilities»;a:2:{s:4:»read»;b:1;s:7:»level_0″;b:1;}}}’ ,option_name=’wp_3_user_roles’ ;
insert into wp_4_options SET option_value=’a:5:{s:13:»administrator»;a:2:{s:4:»name»;s:13:»Administrator»;s:12:»capabilities»;a:47:{s:13:»switch_themes»;b:1;s:11:»edit_themes»;b:1;s:16:»activate_plugins»;b:1;s:12:»edit_plugins»;b:1;s:10:»edit_users»;b:1;s:10:»edit_files»;b:1;s:14:»manage_options»;b:1;s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:6:»import»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:8:»level_10″;b:1;s:7:»level_9″;b:1;s:7:»level_8″;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;s:12:»delete_users»;b:1;s:12:»create_users»;b:1;s:14:»edit_dashboard»;b:1;}}s:6:»editor»;a:2:{s:4:»name»;s:6:»Editor»;s:12:»capabilities»;a:33:{s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;}}s:6:»author»;a:2:{s:4:»name»;s:6:»Author»;s:12:»capabilities»;a:10:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:4:»read»;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;s:22:»delete_published_posts»;b:1;}}s:11:»contributor»;a:2:{s:4:»name»;s:11:»Contributor»;s:12:»capabilities»;a:6:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:4:»read»;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;}}s:10:»subscriber»;a:2:{s:4:»name»;s:10:»Subscriber»;s:12:»capabilities»;a:2:{s:4:»read»;b:1;s:7:»level_0″;b:1;}}}’ ,option_name=’wp_4_user_roles’ ;
insert into wp_5_options SET option_value=’a:5:{s:13:»administrator»;a:2:{s:4:»name»;s:13:»Administrator»;s:12:»capabilities»;a:47:{s:13:»switch_themes»;b:1;s:11:»edit_themes»;b:1;s:16:»activate_plugins»;b:1;s:12:»edit_plugins»;b:1;s:10:»edit_users»;b:1;s:10:»edit_files»;b:1;s:14:»manage_options»;b:1;s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:6:»import»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:8:»level_10″;b:1;s:7:»level_9″;b:1;s:7:»level_8″;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;s:12:»delete_users»;b:1;s:12:»create_users»;b:1;s:14:»edit_dashboard»;b:1;}}s:6:»editor»;a:2:{s:4:»name»;s:6:»Editor»;s:12:»capabilities»;a:33:{s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;}}s:6:»author»;a:2:{s:4:»name»;s:6:»Author»;s:12:»capabilities»;a:10:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:4:»read»;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;s:22:»delete_published_posts»;b:1;}}s:11:»contributor»;a:2:{s:4:»name»;s:11:»Contributor»;s:12:»capabilities»;a:6:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:4:»read»;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;}}s:10:»subscriber»;a:2:{s:4:»name»;s:10:»Subscriber»;s:12:»capabilities»;a:2:{s:4:»read»;b:1;s:7:»level_0″;b:1;}}}’ ,option_name=’wp_5_user_roles’ ;
insert into wp_6_options SET option_value=’a:5:{s:13:»administrator»;a:2:{s:4:»name»;s:13:»Administrator»;s:12:»capabilities»;a:47:{s:13:»switch_themes»;b:1;s:11:»edit_themes»;b:1;s:16:»activate_plugins»;b:1;s:12:»edit_plugins»;b:1;s:10:»edit_users»;b:1;s:10:»edit_files»;b:1;s:14:»manage_options»;b:1;s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:6:»import»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:8:»level_10″;b:1;s:7:»level_9″;b:1;s:7:»level_8″;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;s:12:»delete_users»;b:1;s:12:»create_users»;b:1;s:14:»edit_dashboard»;b:1;}}s:6:»editor»;a:2:{s:4:»name»;s:6:»Editor»;s:12:»capabilities»;a:33:{s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;}}s:6:»author»;a:2:{s:4:»name»;s:6:»Author»;s:12:»capabilities»;a:10:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:4:»read»;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;s:22:»delete_published_posts»;b:1;}}s:11:»contributor»;a:2:{s:4:»name»;s:11:»Contributor»;s:12:»capabilities»;a:6:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:4:»read»;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;}}s:10:»subscriber»;a:2:{s:4:»name»;s:10:»Subscriber»;s:12:»capabilities»;a:2:{s:4:»read»;b:1;s:7:»level_0″;b:1;}}}’ ,option_name=’wp_6_user_roles’ ;
insert into wp_7_options SET option_value=’a:5:{s:13:»administrator»;a:2:{s:4:»name»;s:13:»Administrator»;s:12:»capabilities»;a:47:{s:13:»switch_themes»;b:1;s:11:»edit_themes»;b:1;s:16:»activate_plugins»;b:1;s:12:»edit_plugins»;b:1;s:10:»edit_users»;b:1;s:10:»edit_files»;b:1;s:14:»manage_options»;b:1;s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:6:»import»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:8:»level_10″;b:1;s:7:»level_9″;b:1;s:7:»level_8″;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;s:12:»delete_users»;b:1;s:12:»create_users»;b:1;s:14:»edit_dashboard»;b:1;}}s:6:»editor»;a:2:{s:4:»name»;s:6:»Editor»;s:12:»capabilities»;a:33:{s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;}}s:6:»author»;a:2:{s:4:»name»;s:6:»Author»;s:12:»capabilities»;a:10:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:4:»read»;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;s:22:»delete_published_posts»;b:1;}}s:11:»contributor»;a:2:{s:4:»name»;s:11:»Contributor»;s:12:»capabilities»;a:6:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:4:»read»;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;}}s:10:»subscriber»;a:2:{s:4:»name»;s:10:»Subscriber»;s:12:»capabilities»;a:2:{s:4:»read»;b:1;s:7:»level_0″;b:1;}}}’ ,option_name=’wp_7_user_roles’ ;
insert into wp_8_options SET option_value=’a:5:{s:13:»administrator»;a:2:{s:4:»name»;s:13:»Administrator»;s:12:»capabilities»;a:47:{s:13:»switch_themes»;b:1;s:11:»edit_themes»;b:1;s:16:»activate_plugins»;b:1;s:12:»edit_plugins»;b:1;s:10:»edit_users»;b:1;s:10:»edit_files»;b:1;s:14:»manage_options»;b:1;s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:6:»import»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:8:»level_10″;b:1;s:7:»level_9″;b:1;s:7:»level_8″;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;s:12:»delete_users»;b:1;s:12:»create_users»;b:1;s:14:»edit_dashboard»;b:1;}}s:6:»editor»;a:2:{s:4:»name»;s:6:»Editor»;s:12:»capabilities»;a:33:{s:17:»moderate_comments»;b:1;s:17:»manage_categories»;b:1;s:12:»manage_links»;b:1;s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:17:»edit_others_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:10:»edit_pages»;b:1;s:4:»read»;b:1;s:7:»level_7″;b:1;s:7:»level_6″;b:1;s:7:»level_5″;b:1;s:7:»level_4″;b:1;s:7:»level_3″;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:17:»edit_others_pages»;b:1;s:20:»edit_published_pages»;b:1;s:13:»publish_pages»;b:1;s:12:»delete_pages»;b:1;s:19:»delete_others_pages»;b:1;s:22:»delete_published_pages»;b:1;s:12:»delete_posts»;b:1;s:19:»delete_others_posts»;b:1;s:22:»delete_published_posts»;b:1;s:20:»delete_private_posts»;b:1;s:18:»edit_private_posts»;b:1;s:18:»read_private_posts»;b:1;s:20:»delete_private_pages»;b:1;s:18:»edit_private_pages»;b:1;s:18:»read_private_pages»;b:1;}}s:6:»author»;a:2:{s:4:»name»;s:6:»Author»;s:12:»capabilities»;a:10:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:20:»edit_published_posts»;b:1;s:13:»publish_posts»;b:1;s:4:»read»;b:1;s:7:»level_2″;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;s:22:»delete_published_posts»;b:1;}}s:11:»contributor»;a:2:{s:4:»name»;s:11:»Contributor»;s:12:»capabilities»;a:6:{s:12:»upload_files»;b:1;s:10:»edit_posts»;b:1;s:4:»read»;b:1;s:7:»level_1″;b:1;s:7:»level_0″;b:1;s:12:»delete_posts»;b:1;}}s:10:»subscriber»;a:2:{s:4:»name»;s:10:»Subscriber»;s:12:»capabilities»;a:2:{s:4:»read»;b:1;s:7:»level_0″;b:1;}}}’ ,option_name=’wp_8_user_roles’ ;

[/sql]

Os dejo aquí un chorro de sql para copiar y pegar 😀