Hi @renpersonal,
How did you transfer your publications? Did you use the Data Publisher or another tool?
Thanks,
Peter
Hi Peter, Data Publisher.
The transfer to staging to main site is full. Then, the views already created in data publisher lost the connection to database.
Hi @renpersonal,
You can export your publications from the Data Publisher or Data Explorer. When you export on your source server the plugin replaces the WP table prefix and schema with special markers. When you import on your destination server the markers are replaced with the WP table prefix and schema of your destination server.
LIMITATION =
This only works if your tables are stored in your WP database!!!
ALTERNATIVE =
If your tables are stored in another database you either need to edit the export file, or make sure the database names are equal on both servers. If you cannot rename your database (due to limitations of your ISP or other) you could create a remote connection in the Data Explorer that loops back to your default WP database. That allows you to give both remote connections the same name and transfer your publications without errors.
SURPRISE ❓
I checked the code and I see now that the Data Publisher export does not convert the table prefix. 🙈 Remarkable no one ever reported this before! 😐 I will fix this in the next release. As a temporary workaround you can export the wp_wpda_publisher table directly from the Data Explorer. That export converts the table prefix correctly.
Thanks a lot for reporting this issue 😊
Peter
