Hi @astrudwick,
Please use the export/import feature of the plugin to transfer your plugin tables to another website. The plugin stores the WordPress database name with your publications and projects. When you transfer to another website, you database names will usually change. The export/import feature of the plugin will automatically convert the database names.
This does not apply yo remote database if you use the same name for your remote database connection on both servers.
Does this solve your issue?
Peter
Since the data is live (with limitations) and some has been updated, is there an alternative of patching a table somewhere to update the database name? The Data Publisher entries were fixable through the normal edit but the Project Templates are playing hard to get.
Hi @gpanton,
There are two easy ways to handle this:
(1) Use the Data Explorer
(2) Use the Query Builder
(1) Start the Data Explorer and search for table ‘xx_wpda_project_page’. Explorer the table and update the column page_schema_name where necessary.
(2) If you are familiar with SQL, you can update all rows containing the wrong schema name at once:
update xx_wpda_project_page
set page_schema_name = 'new schema name'
where page_schema_name = 'old schema name';
NOTE xx_ is your WP prefix
Hope this helps,
Peter
Thanks, Peter. Did that but doesn’t seem to be sufficient. I see that f1_wpda_project_table needs similar treatment. Are there any other tables to do. It’s particularly the project templates I’m hoping to see restored.
Sorry! You’re right. You need to do the same for table xx_wpda_project_table.
Does this help?
Peter
Thanks, I think that’s got it.
Graham
Hi Peter
I realise I posted my previous updates against the wrong thread. Here I’m back on the correct one. Can’t see how to attach screenshot here, but when I find a way you should see the bottom entry is the start of the old schema entries which continue on the next page, none of which can be accessed. Above are the new entries, each created by going into Data Explorer>Manage>Alter. No saving but on exit the new entry appeared.
I want to know if I can safely remove the old entries.
Regards
Graham
In the absence of a ready means of sending the screenshot, here’s two rows from the Data Designer screen, relating to a single table. There’s similar pairs for each of the other tables:
HSevent
dbs3118133 Sun Aug 22, 2021 2:52 pm Sun Aug 22, 2021 2:52 pm
HSevent
wordpress-313637afba Thu May 6, 2021 4:35 pm Thu May 6, 2021 7:30 pm
Another point: I went into the WPDA Contact Us and noticed that it still shows https://hadleigh.strudwickstaging.co.uk instead of the site moved to, ie http://hadsoc.org.uk
Hi Graham,
To transfer your license from one domain to another:
– open your account page
– go to Websites
– remove the old domain
– add the new domain
After that you need to upload the premium version to your new domain and activate it withyour activation key.
Hope this helps,
Peter