Hi,
thanks for your post, and sorry for the trouble.
How exactly did you migrate your date to the new site? What method did you use?
Do you still have access to the old site?
Regards,
Tobias
Hey Tobias,
thanks for your quick response. Unfortunately I don’t have access to the old website anymore. I exported the database und imported it into the new website. There I was able to find my tables in “wp_posts”. I changed the database name though, is there a way to tell the plugin that is not “wp_posts”, but “xyz_posts”? Or any way to export them from the database?
Regards,
Van
Hi,
TablePress does care if the name is “wp_posts” or “xyx_posts”. It only cares that there are rows in that database table with value of “tablepress_table” in the “post_type” column. In addition, TablePress needs the “tablepress_tables” row in the “wp_options” database table. This holds the connection between the table IDs in the post IDs from the “wp_posts” database tables.
So, did you also migrate the “wp_options” database table?
Regards,
Tobias
Hi,
I did not migrate the wp_options entries from the old one, however, I cannot find any tablepress entries in the old wp_options section?
Regards,
Van
Hi,
if you didn’t migrate the wp_options table, you basically lost the connection between table ID and post ID.
If the other rows are in your wp_posts table however, we can at least restore the data. If possible, I’d like to take a direct look at this on your site. Could you therefore please get in touch via email (the address is in the main plugin file “tablepress.php”)? That way, I can investigate this directly. Thanks!
Regards,
Tobias
Thanks Tobias, I contacted you via email :).
Van
Hi,
thanks! I was able to take a look and installed “TablePress Debug Extension”. This gives you access to the raw table data (via the “TP Tables” menu on the left), and adds a “Debug” tab in TablePress. Using this, I re-added the connection between table IDs and WordPress post IDs.
Thus, you should now see all your tables again in TablePress. However, they will most likely have different table IDs than on the old site. You should now check what ID you used for each table in the Shortcodes on the pages and change the ID to that again, on each table’s “Edit” screen.
Regards,
Tobias
Tobias!
I just checked and changed all the table ids to the correct one. I am so thankful for your support. You can’t imagine how stressful this was for me! Thank you so much, you are truly a hero!
Regards
Van
Hi,
no problem, you are very welcome! 🙂 Good to hear that this helped!
Best wishes,
Tobias
P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!
