Roger

Yeah, that sucks. Still an awesome plugin though!

Thank you developer(s)/maintainer(s) of it!

Have you tried installing this highly recommend Plugin first and running it to replace all instances of the previous IP address for the new URL?
https://www.ads-software.com/support/plugin/velvet-blues-update-urls/

It’s even recommend by the WordPress documentation people — https://codex.www.ads-software.com/Moving_WordPress#Changing_Your_Domain_Name_and_URLs

P.S. Maybe try exporting/saving that zip file from a different computer too, before you make it available for us to check out. (And you don’t have to leave it available long, you can delete it after we take a look. )

Hi, if there’s no private info in the website, like a password protected section of the website — then can you upload a copy of the zip file to some place like Google Drive or Dropbox so we can take a look.

It might be something easy that’s only affecting your 1 MacBook and doesn’t affect other computers.

Sincerely,

Roger

Thank you!

I see a table called “wp_options” with a row named “wp_user_roles”.

It contains:

a:5:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;a:62:{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:15:”unfiltered_html”;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:17:”unfiltered_upload”;b:1;s:14:”edit_dashboard”;b:1;s:14:”update_plugins”;b:1;s:14:”delete_plugins”;b:1;s:15:”install_plugins”;b:1;s:13:”update_themes”;b:1;s:14:”install_themes”;b:1;s:11:”update_core”;b:1;s:10:”list_users”;b:1;s:12:”remove_users”;b:1;s:9:”add_users”;b:1;s:13:”promote_users”;b:1;s:18:”edit_theme_options”;b:1;s:13:”delete_themes”;b:1;s:6:”export”;b:1;}}s:6:”editor”;a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:34:{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:15:”unfiltered_html”;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:5:{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;}}}

I can not find any table or option named “user_metadata”.

I’m guessing that the roles are assigned in the “wp_usermeta” table?

How does it work there?

here’s what my wp_usermeta table looks like:

umeta_id user_id meta_key meta_value
1 1 nickname Dave
2 1 rich_editing true
3 1 comment_shortcuts false
4 1 admin_color classic
5 1 wp_capabilities a:1:{s:13:”administrator”;b:1;}
7 1 wp_user_level 10
8 1 wp_usersettingstime 1268608634
9 1 first_name David
10 1 last_name fisherman
11 1 wp_usersettings align=center&editor=tinymce&m3=o&hidetb=1&galfile=1&galcols=2&m4=o&m8=o&m0=o&m5=o&m7=o&m1=c&m2=c
12 1 wp_autosave_draft_ids a:6:{i:-1268454452;i:8;i:-1268455316;i:17;i:-1268458522;i:42;i:-1268462136;i:57;i:-1268477259;i:69;i:-1268603508;i:79;}
13 1 closedpostboxes_dashboard a:2:{i:0;s:17:”dashboard_primary”;i:1;s:19:”dashboard_secondary”;}
14 1 metaboxhidden_dashboard a:1:{i:0;s:0:””;}
15 1 closedpostboxes_page a:1:{i:0;s:0:””;}
16 1 metaboxhidden_page a:1:{i:0;s:7:”slugdiv”;}
17 1 closedpostboxes_post a:1:{i:0;s:0:””;}
18 1 metaboxhidden_post a:1:{i:0;s:0:””;}
21 1 wp_dashboard_quick_press_last_post_id 94
20 1 screen_layout_post 2

Are all 20 of those lines for my 1 user?
(i only have 1 user right now).

Is there any document out there that breaks down how it works?
(if not, i think i’ll make one after i deciper it all! ?? )

Thanks,

Roger