Migration problem with link urls in tablepress tables

  • Resolved cobradesign

    (@cobradesign)


    9 years, 5 months ago

    I created a wp installation on my testing server before I moved it to the clients webhotel. As usual I moved the installation using filezilla and phpmyadmin, updated the htaccess and changed the urls in the database through the Database Search and Replace Script from interconnect it. Everything worked fine but all the urls in the tablepress tables linking to pdf files in the media library still contain the old adresses. The script should have changed the links just like everything else but it doesn’t. In fact it doesn’t seem to find the urls at all? How can I update the links in the tables without having to enter them manually one by one?

    https://www.ads-software.com/plugins/tablepress/

Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    The reason for this basically is that TablePress uses the JSON format to store the table data. In JSON, characters like / (which appear in URLs in e.g. https://www...) can have a special meaning, which is why they are usually escaped by a \ (to basically take the special meaning away from them).

    So, a URL in a TablePress table will therefore be stored as e.g.

    http:\/\/www.example.com\/path\/

    with all / preceded by an extra \.

    And this is now what you will have to do in a second round of using Database Search/Replace: Instead of searching/replacing the regular URL, search for

    http:\/\/www.old-domain.com\/path\/

    and replace that with

    http:\/\/www.new-domain.com\/path\/

    so that the / and \ are left in order.

    Regards,
    Tobias

    Thread Starter cobradesign

    (@cobradesign)

    Awesome, works like a charm! Thank you so much for your answer and for responding so quickly. I’ll be happy to make a donation for a great plugin and excellent support. ??

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    no problem, you are very welcome! ?? Good to hear that this helped!
    And thanks for wanting to donate, I really appreciate that!

    Best wishes,
    Tobias

    P.S.: In case you haven’t, please rate TablePress here in the plugin directory. Thanks!

    Hello I have not that much of knowledge about this change, can you tobias be a little more explicit? where do I change the url?

    For what I understand I need to run a sql script to update the script, can you give me it tobias? I do not know which sql table or field I need to update. Thanks!

    Plugin Author TobiasBg

    (@tobiasbg)

    Hi,

    Sorry for the long wait for a reply. As a I was on a long vacation without internet access the last couple weeks, I could not reply earlier.

    Unfortunately, I don’t have that SQL query readily available at the moment. The best way should be to use a DB search/replace plugin where you do the replacement that I mention above.

    Regards,
    Tobias

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Migration problem with link urls in tablepress tables’ is closed to new replies.

Tags