Some products dont show in search

Hi!

Looks like the translation ID for italian is missing from Cesarini Sartori Rossobastardo product. If I switch to english, I can see the result.

You can try 3 different solutions:

1. Solution

• Deactivate and Activate WPML again. This should generate the missing tranlsations.
• …then Re-create the Index Engine (Delete Index -> New index: http://i.imgur.com/PoFPNGg.png )

2. If 1. solution not working, then:

Open wp-content/plugins/ajax-search-pro/includes/etc/indextable.class.php file and go to line 908 – 926, where you should see this:

[php]private function langcode_post_id($post){
global $wpdb;

$post_type = "post_" . $post->post_type;

$query = $wpdb->prepare("
SELECT language_code
FROM " . $wpdb->prefix . "icl_translations
WHERE
element_type = ‘%s’ AND
element_id = %d"
, $post_type, $post->ID);
$query_exec = $wpdb->get_row($query);

if ( null !== $query_exec )
return $query_exec->language_code;

return "";
}[/php]

Change it to:

[php]private function langcode_post_id($post){
global $wpdb;
global $sitepress;

$post_type = "post_" . $post->post_type;

$query = $wpdb->prepare("
SELECT language_code
FROM " . $wpdb->prefix . "icl_translations
WHERE
element_type = ‘%s’ AND
element_id = %d"
, $post_type, $post->ID);
$query_exec = $wpdb->get_row($query);

if ( null !== $query_exec )
return $query_exec->language_code;

if ( is_object($sitepress) && method_exists($sitepress, ‘get_default_language’) )
return $sitepress->get_default_language();

return "";
}[/php]

Then Re-create the Index Engine (Delete Index -> New index: http://i.imgur.com/PoFPNGg.png )

Let me know if any of this helps!

Can you please provide temporary FTP and Administrator access?

I would like to check the search configuration and debug the code for the problem.

You can upload a .txt file or edit your first post in this thread for the details.

Both methods are safe and only visible to me and you.

Hi!

Thank you for the details. I have found the problem and fixed it in the search code. I’m including this fix in the upcoming update, so you don’t have to worry about it 🙂