Some products dont show in search

[Enzo Nardo Di MaioParticipant]

Dear,
i have installed your plugin but some products dont show in search. Example:

Cesarini Sartori Rossobastardo but if search Cesarini Sartori the ajax search show me only 2 products
Ruffino Chianti Superiore
Antinori only some products
this also for other some products.
How i can fix it?
i used table index.
Best Regards

• This topic was modified 7 years, 4 months ago by  Enzo Nardo Di Maio.

[Ernest MarcinkoKeymaster]

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: https://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:

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 "";
}

Change it to:

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 "";
}

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

Let me know if any of this helps!

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Enzo Nardo Di MaioParticipant]

Dear,
Dont work. Work only in EN website. I have insert new products Zenato and in EN website work, in IT site no.
it does not work with Regular Engine.
Best Regards.

[Ernest MarcinkoKeymaster]

Can you please provide temporary FTP and Administrator access?

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

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Enzo Nardo Di MaioParticipant]

yes, how i can send you in private?

[Ernest MarcinkoKeymaster]

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.

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Enzo Nardo Di MaioParticipant]

ok i wait your response.

[Ernest MarcinkoKeymaster]

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 🙂

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Enzo Nardo Di MaioParticipant]

Thanx =)

[Enzo Nardo Di MaioParticipant]

Hi, with new version i have the same problem. How i can fix it?
Thanx.

[Ernest MarcinkoKeymaster]

Hi!

I’ve just tested and it seems all right to me. This version has the changes I’ve made on your site.

I have tried:
“Cesarini Sartori Rossobastardo” – got 1 result on both sites
“Ruffino Chianti Superiore” – no results on IT, because the DOCG category is excluded, and the product belongs there
“Antinori” – lots of products on both languages

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Enzo Nardo Di MaioParticipant]

Yes, i have rewrite the article, try to items on VINI – VINI BIANCHI – ABRUZZO, example Fantini Farnese Casale Vecchio Cococciola. I noticed that the old products do not indexes,

[Ernest MarcinkoKeymaster]

The “Fantini Farnese Casale Vecchio Cococciola” would return this I guess: http://www.enotecatuscia.it/prodotto/fantini-farnese-casale-vecchio-cococciola-terre-di-chieti-igt/

But if you check the product, it’s in the IGT category (https://i.imgur.com/09nNWyu.png), which is excluded on the Advanced Options panel: https://i.imgur.com/qwZLfAK.png
so the product is filtered out.

Best,
Ernest Marcinko
If you like my products, don't forget to rate them on codecanyon :)

[Enzo Nardo Di MaioParticipant]

oops 🙂
Thanx

[Author]

Posts