I have migrated my site to new hosting. I used Updraft Plus to do so.
Most things seem to work fine on the new site. In the migration process the database table prefix has changed (from 81zD2). Views which used a filter for the capabilities field (81zD2_capabilities) no longer work. There is also no option to filter by the value of the new database table (the filter dropdown only lists 81zD2_capabilities - a field which no longer exists) and not the new table (see screenshot).
Is there a way in which Toolset views can recognise the new table as it used to on the old hosting or a way to migrate views to the new site from the old one which would update the list of user fields?
If not, I am left with multiple views which can't be filtered by user capability. The data is still there as I can see it on the new hosting in PHPmyadmin.
This applies both the views copied from the previous hosting and to new views created on the new hosting.
In a case like this there are usually more hidden issues than just the records not showing up. What I would recommend that you do is to remigrate the entire site using the duplicator plugin.
You mention this custom field here "81zD2_capabilities" is this field still visible when you go to Toolset -> Custom Fields and check your user fields assuming it was a field created in Types.
Ok thank you for the update. Can you let me know the results once you've remigrated the website using the duplicator plugin.
Secondly what you can try doing is to recreate that exact custom field with the exact same slug and see if it starts to show up. However I do suspect the issue is with the migration because the table prefixing shouldn't affect the data.
Thanks,
Shane
The topic ‘[Closed] Accessing user meta after migration to new hosting’ is closed to new replies.