lawsie
Member
Posted 6 months ago #
First of all thanks for this great plugin, it has really made a huge difference to a technical machinery site I have built.
I build the entire site in a sub-directory then moved the files to the root to launch, I updated the site location in WordPress settings and ran a search and replace (using Frank Bültge's plugin) to replace any mention of the old sub-directory.
The entire launch went very well, but I have lost some of my WP-Table Reloaded tables. The first 28 tables are still intact, but newest five or six tables appear to have disappeared, I've tried looking for them in the wp_options but don't appear to be able to find them.
Help :)
http://wordpress.org/extend/plugins/wp-table-reloaded/
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
lawsie
Member
Posted 6 months ago #
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
ladless
Member
Posted 3 months ago #
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
ladless
Member
Posted 3 months ago #
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... http://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
ladless
Member
Posted 3 months ago #
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
