[Plugin: WP-Table Reloaded] 'Some' tables gone after site launch

Hi,

the reason for this happening is the search and replace that you performed in the database. The tables that are not working now likely contained references (links or images) with the subfolder in them. By removing them directly through search and replace, the internally used format (so-called “serialized strings” from the PHP function serialize()) was corrupted.

To fix this, you should restore the tables in question from a backup of the old site. You will need to replace the relevant entries in the wp_options database table. Their names start with “wp_table_reloaded_data_”.
If you don’t have a backup, you could try to do the search and replace in the reverse order, on all tables that are now broken. This should restore the internal data format, so that you can access the tables again in WP-Table Reloaded.

Regards,
Tobias

Thank you, sadly I didn’t back up the db (idiotic, I know!) so I’l build the tables back from scratch.

Thanks for your very swift help.

Hi,

yesh, that’s unfortunate. ?? Sorry about that.

Best wishes,
Tobias

I can confirm this is not working. I had over 200 tables. This is a disaster… I moved everything back, everything worked but the tables… How is this possible ? Please help.

Hi,

thanks for your report.

Can you please provide more details? What exactly is not working? What steps did you perform?
Did you try with a “WP-Table Reloaded Dump file”?

Regards,
Tobias

Hi,

please also take a look at
https://www.ads-software.com/support/topic/plugin-wp-table-reloaded-cannot-find-wp-table-in-database-backup-lost-a-table
and
https://www.ads-software.com/support/topic/plugin-wp-table-reloaded-anyway-to-revocover-lost-tables-after-moving-website
where similar issues are discussed.

Regards,
Tobias

Hello,

I tried moving everything back… and doing the s&r in reverse but still the tables aren’t showing up (they are present in the database).

I even tried this great script that’s addressing this… https://interconnectit.com/124/search-and-replace-for-wordpress-databases/

However, nothing helped…

Any suggestions ? ??

Hi,

thanks for the description. Search/Replace in the wp_options table (even with that script that you mention) can unfortunately cause tables in WP-Table Reloaded to break, especially if they contain links/URLs. (This is a drawback of the internal data format that is used, which I unfortunately did not learn until it was too late…)

Can you try to restore everything to the state before you search/replaced for the first time, from the backup that you hopefully have?

Regards,
Tobias

Yes, I did restore it. Thank god for backups ! Anyway, i used the script and it worked beautifully with cforms2 and your plugin !

So, take this statement as a testimonial or feedback, I don’t know, but feel free to suggest it to others that move their WP instances to other domains/subdomains/folders. Thing is to use it before they move the files and before they do anything to the database. Of course, backups are a MUST, BEFORE touching anything.

Cheers !

Hi,

ah, great. That’s good news! ??
Thanks for the insights on how it worked for you!

Best wishes,
Tobias