jbnet

Thank you mathew.cantore.
I don’t know what I was thinking, your solution is much better than mine.

It’s ok for me only with Google Chrome, not with Firefox.

Thank you Icefall5.
I don’t understand why the code don’t working.
It’s ok for me.

Maybe this :

if ( !$request ) return $query;
/*
    $sql = "SELECT $wpdb->posts.ID, $wpdb->postmeta.meta_value, $wpdb->posts.post_type FROM $wpdb->posts  ".
	            "LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) WHERE ".
	            "  meta_key = 'custom_permalink' AND ".
	            "  meta_value != '' AND ".
	            "  ( LOWER(meta_value) = LEFT(LOWER('".mysql_real_escape_string($request_noslash)."'), LENGTH(meta_value)) OR ".
	            "    LOWER(meta_value) = LEFT(LOWER('".mysql_real_escape_string($request_noslash."/")."'), LENGTH(meta_value)) ) ".
	            "  AND post_status != 'trash' AND post_type != 'nav_menu_item'".
	            " ORDER BY LENGTH(meta_value) DESC, ".
	            " FIELD(post_status,'publish','private','draft','auto-draft','inherit'),".
	            " FIELD(post_type,'post','page'),".
	            "$wpdb->posts.ID ASC  LIMIT 1";

    $posts = $wpdb->get_results($sql);
*/
  $sql = "SELECT $wpdb->posts.ID, $wpdb->postmeta.meta_value, $wpdb->posts.post_type FROM $wpdb->posts  ".
          "LEFT JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) WHERE ".
          "  meta_key = 'custom_permalink' AND ".
          "  meta_value != '' AND ".
          "  ( LOWER(meta_value) = LEFT(LOWER('%s'), LENGTH(meta_value)) OR ".
          "    LOWER(meta_value) = LEFT(LOWER('%s'), LENGTH(meta_value)) ) ".
          "  AND post_status != 'trash' AND post_type != 'nav_menu_item'".
          " ORDER BY LENGTH(meta_value) DESC, ".
          " FIELD(post_status,'publish','private','draft','auto-draft','inherit'),".
          " FIELD(post_type,'post','page'),".
          "$wpdb->posts.ID ASC  LIMIT 1";

  $posts = $wpdb->get_var( $wpdb->prepare(
    $sql,
    $request_noslash, // an unescaped string (function will do the sanitization for you)
    $request_noslash // an untrusted integer (function will do the sanitization for you)
  )
  );

Could you give me the URL ?

Search the string “custom_permalinks_request” in functions.php

Did you check the functions.php file?
A function that overloads the one that was changed?

Hello,

Nothing, just reload the page.

Maybe clear your cache….

Regards