Small request

Discussion in 'Suggestions and Feedback Archive' started by nineko, Dec 29, 2012.

Thread Status:
Not open for further replies.
  1. nineko

    nineko I am the Holy Cat Member

    Joined:
    Mar 24, 2008
    Messages:
    1,902
    Location:
    italy
    Hi admins,


    this is the kind of request which should have probably been delivered through a Private Message, but I wasn't sure which admin was my best bet for this, so I'll write it here and it can be trashed afterwards.


    Basically, my webspace changed URL from "digilander.libero.it" to "digilander.libero.it", so ALL the links I posted over the years (e.g. my songs, my programs, my hack, ...) are now invalid. I hate this a lot because I was SO used to type the address in that way, but there's nothing I can do to avoid it. I waited a week to see if it was only a malfunction and they would put the old URL back up, but it appears that it's not the case. Only the few things I have on Dropbox are safe, obviously.


    So I'm asking whoever has direct database access if it would be possible to run a full database search for "digilander.libero.it" and mass replace it to "digilander.libero.it"


    Thanks in advance and sorry if I bothered you with this unusual request.
     
    Last edited by a moderator: Dec 29, 2012
  2. SeanieB

    SeanieB Dude! Root Admin

    Joined:
    Jul 19, 2008
    Messages:
    230
    Location:
    San Diego, CA
    31 rows affected. ( Query took 1.0334 sec )

    UPDATE sgmc_posts SET post = REPLACE( post, 'iol.it', 'libero.it' ) WHERE post LIKE '%iol.it%'
     
    Last edited by a moderator: Dec 29, 2012
  3. nineko

    nineko I am the Holy Cat Member

    Joined:
    Mar 24, 2008
    Messages:
    1,902
    Location:
    italy
    Thanks, but it seems that the query left the links into a weird state, they still link to the old URL, but the new URL appears if I click on "edit" o_O


    I wonder if IPB has some kind of cache or something...


    If all else fails I'll just edit them by hand, it would be annoying, but I thought there were way more than 31, so it would be doable. Minus the ones in locked topics.
     
    Last edited by a moderator: Dec 29, 2012
Thread Status:
Not open for further replies.