[Plugin: WP-Table Reloaded] Anyway to revocover lost tables after moving website

Anyway to Recover…

More on this. The plugin lists the id of the tables, but they are all empty, no Table Name or Description. It’s like the plugin has lost the location of the data.

I can see the data in the wp_options table, but there’s info in there to also describe the table itself, so I can’t just copy and paste the data back to WP-Table-Reloaded. Am I missing something? Is there a config file or field that tells WP-Table-Reloaded where the data is?

Hi,

thanks for your report, and sorry about the trouble you are experiencing.

You probably did a search/replace on the table fields in the wp_options table, to replace the old server URL with the one. This unfortunately broke the tables (a really bad drawback of the interally used format, so-called serialized strings, that I noticed only when it was too late to change it…).
The only chance you have is to try to revert that search/replace on your tables, i.e. on all fields that are named like “wp_table_reloaded_data_…”. You will need to search for the new URL and replace that with the old.

Regards,
Tobias

Thanks for responding. Yes, search/replace did occur!

So, if I have an option_name: “wp_table_reloaded_data_6”
The option value can be seen here:
https://pastebin.com/eYADdqGs

The URLs I see are paths to images and such. Is there a spefic URL to replace?

Hi,

ok, that explains it then. I assume that the URLs in the images were changed by the search/replace? This then corrupted the “length information” that this PHP data format stores for each tables cell.

You will need to revert see search/replace, by searching for the new URL and replacing it with the old URL. Unfortunately, this won’t guarantee that your tables will work again, but is the only real chance that I’m aware of.

Regards,
Tobias

I just ran a test, and if I replace the URLs back to the old server, then the tables show up in the WP Admin, which I can then edit using WP-Table Reloaded to change the URLs to the new server. A little tedious but it works. Thanks!

Hi,

that’s good news, as it means that you will be able to restore your tables with this procedure.

Yes, changing the links manually in the admin area would be tedious, but there is a work-around here as well, that could at least save you some time: Export the table to CSV, and open that file in Notepad or another text editor. Then do a search/replace there, to change the old to the new URLs. Save the modified file and in WP-Table Reloaded import it again, and select to replace the existing table.
This should be faster than manually replacing every link in the tables.

Regards,
Tobias