Interactibe Banner and changing Links with database sql

  • Resolved volkhardv

    (@volkhardv)


    7 years, 8 months ago

    Hello,
    i’m uing the interactive banner and want to move a site to another Domain.
    For this i have to correct the links. For not to do thhis Manual i try to modify the links with a SQL-Statement in the database.
    I try following statement for relinking from “https://customer.vogeler-ag.de/source” to “https://customer.vogeler-ag.de/target”:

    update wp_postmeta set meta_value=replace(meta_value,’url:http%3A%2F%2Fcustomer.vogeler-ag.de%2Fsource%2F’,’url:http%3A%2F%2Fcustomer.vogeler-ag.de%2Ftarget%2F’)
    where meta_value like ‘%url:http%3A%2F%2Fcustomer.vogeler-ag.de%2Fsource%2F%’

    after this the pages with the interactive banner are corrupted.

    can you help me?

    best regards

    Volkhard

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Ruslan Suhar

    (@rsukhar)

    Hey volkhardv,

    Hope the question is still actual …

    The best option would be, of course, to simply use relative links.

    But if you’re using absolute links in many-many places already, it will be a good idea to use WP CLI search-replace to process the whole database a proper way. Somewhere the data may be stored as PHP-serialized arrays, and simple SQL update can really corrupt your data.

    • This reply was modified 7 years, 7 months ago by Ruslan Suhar.
    Thread Starter volkhardv

    (@volkhardv)

    Hello Ruslan,

    thanks for your hints.

    How can i enter relative links in the interactive banner? It always make absolut links in the database if i select a existing page…

    best regards

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Interactibe Banner and changing Links with database sql’ is closed to new replies.