• Resolved andyward75

    (@andyward75)


    Hi, I use many tables on my site and I have just had to chance the URL from history.hoverugby.club to history.hoverugby.com.

    I have many tables that have links/images in with code similar to the below:

    [caption id="attachment_6205" align="aligncenter" width="300"]<a href="https://history.hoverugby.club/wp-content/uploads/2022/02/1st-XV-1987-1988.jpg"><img src="https://history.hoverugby.club/wp-content/uploads/2022/02/1st-XV-1987-1988-300x225.jpg" alt="" width="300" height="225" /></a> 1st XV 1987-1988 Image courtesy of xxxx[/caption]

    What I would like to do is to change (PHPMYADMIN?) the underlying tables to change all versions of hovegugby.club to hoverugby.com

    So,

    1. Is this possible to do via the plugin
    2. Would I be better not specifying the absolute link (automatic from the plugin though) and just using a relative link – so just remove the https://history.hoverugby.club altogether.
    3. Can I edit the underlying MySQL tables and, if so, which tables do I need to edit

    Many Thanks

    • This topic was modified 4 years, 3 months ago by andyward75.

    The page I need help with: [log in to see the link]

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    thanks for your post, and sorry for the trouble.

    Indeed, the best solution for this should be to use PHPMyAdmin and a search/replace database query. To change all these domains in TablePress tables, you would have to search for hovegugby.club and replace that with hovegugby.com in the wp_posts database table.

    Regards,
    Tobias

    Thread Starter andyward75

    (@andyward75)

    I tried to reply via email but it hasn’t shown. Never mind.

    When changing the wp_posts table, is it just the post_content column to be changed or are there others. It appears I have 103 to change.

    Can I request a change to your fine product that allows it to use relative URLs? So, instead of the full path href=”https://history.hoverugby.club/wp-content/uploads/2022/02/1st-XV-1987-1988.jpg&#8221; we just have “/wp-content/uploads/2022/02/1st-XV-1987-1988.jpg”

    Cheers

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    Hi,

    the post_content column is sufficient. That’s where the table data is stored.

    Regarding the relative URLs request: That’s not really something that I can influence in TablePress, as TablePress uses the regular link editor that comes with WordPress, and possibilities for such customizations are limited, from what I can see.

    Regards,
    Tobias

    Thread Starter andyward75

    (@andyward75)

    Thanks, all OK now. I have run a query to make the change. This can be closed now.

    Plugin Author Tobias Bäthge

    (@tobiasbg)

    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!

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Moved Site URL’ is closed to new replies.