Is it possible: reset page_name values

  • I while ago I imported a shed load of content from another blogging platform (one I wrote myself) and wrote a custom importer for it. It would seem I didn’t do a greta job because quite a few pretty links are broken, for example:

    https://www.coldclimate.co.uk/2002/01/01/Atlast—a-track-listing/ is a real post (see https://www.coldclimate.co.uk/2002/01/01/) but you can’t access it.

    Looking in the db it would seem there is a column for these urls – wp_posts.page_name.

    Is there a way to get WP to recalculate all these values. There seems to be a sanitization routine, but I don’t want to write a script to call it and UPDATE each row if possible.

Viewing 1 replies (of 1 total)
  • Thread Starter coldclimate

    (@coldclimate)

    Nobody any ideas on this one at all? I’ve corrected loads by hand, about to write cursor to do it for me but the pattern match is a bitch.

Viewing 1 replies (of 1 total)
  • The topic ‘Is it possible: reset page_name values’ is closed to new replies.