Where are slugs saved (DB / PHP)? No duplicate, yet WP says there is.

  • Resolved tvejacques

    (@tvejacques)


    7 months, 1 week ago

    The problem:
    Of 131 static pages, WP finds 36 conflicts with permalinks, and adds the -2 to the slug.

    That is strange, as:

    * Permalink Manager plugin by Maciej Bis shows no conflicts at all for the custom permalinks of Pages or Product Categories.

    * Slugs Manager (WPFactory) shows “No old slugs found in database”.

    • There are no duplicate file permalinks (in Pages listing 131 custom permalinks).
    • There are no duplicate product permalinks (Products –> Categories listing 669 custom permalinks)
    • No Posts, no any other option.

    The 36 conflicts do not show in these plugins, but must be somewhere in WP. The question is, why only for these 36, and not for the other almost 100?

    We suspect when importing the site from the developing site something went wrong. Otherwise why would these conflicts show?

    We need to get rid of these wrong -2 slugs as lots of functionalities still need to be added and we do not want to run into problems later on.

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

Viewing 2 replies - 1 through 2 (of 2 total)
  • Moderator bcworkz

    (@bcworkz)

    Post slugs are saved in the wp_posts table in field “post_name”. Similar for taxonomy terms but in wp_terms under field “slug”. You can reliably determine if a slug is in use by querying for it in the phpMyAdmin app.

    Beware: making the wrong query or altering the DB via this app can seriously corrupt your DB. Never directly alter DB records unless you have a recent, reliable backup of your DB and you’re confident you know what you’re doing and recognize the risks involved. It’s safe to use the app’s search tab to find certain records. You may look but don’t touch ??

    As I said in your other topic, if a slug is not in use, you should be able to change an existing -2 slug to it in the page editor. I suspect the -2 was appended as part of an import process and its existence does not mean the non -2 slug is in use.

    Thread Starter tvejacques

    (@tvejacques)

    bcworkz thanks a million!

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Where are slugs saved (DB / PHP)? No duplicate, yet WP says there is.’ is closed to new replies.