Prestashop Core Application V1.5
  1. Prestashop Core Application V1.5
  2. PSCFV-8312

Prestashop 1.5.3.1 search not working in 6 languages and only partly in 1

    Details

    • Type: Bug Bug
    • Status: Closed
    • Resolution: Canceled
    • Affects Version/s: None
    • Fix Version/s: None
    • Security Level: All-users
    • Labels:
      None

      Description

      Hi,

      I am using Prestashop 1.5.3.1 and i have over 200 products added. Indexation says 219/220 and rebuilding it doesnt help. My website URL is http://www.spellendiscounter.nl

      I am using the top search module. I have a lot of problems with products not showing up in the search:

      Please help me it's driving me crazy

      Thank you,
      Bart

        Activity

        Hide
        Bart added a comment -

        I tried the following just now, because i read http://www.prestashop.com/forums/topic/232306-module-search-zoek-werkt-niet-bij-nl-taal/:
        File : classes/Search.php
        search:
        $limit = max(1, floor($limit / $max_possibilities) * $max_possibilities);
        replace with:
        $limit = max(1, floor($limit / $max_possibilities)) * $max_possibilities;

        This causes the following:

        • indexation takes forever, causes gateway timeout after several minutes, only 48/220 show up as indexed
        • some products show up in all languages now, but a lot are not there, because indexation seems to get stuck

        Any clue anyone?

        Show
        Bart added a comment - I tried the following just now, because i read http://www.prestashop.com/forums/topic/232306-module-search-zoek-werkt-niet-bij-nl-taal/: File : classes/Search.php search: $limit = max(1, floor($limit / $max_possibilities) * $max_possibilities); replace with: $limit = max(1, floor($limit / $max_possibilities)) * $max_possibilities; This causes the following: indexation takes forever, causes gateway timeout after several minutes, only 48/220 show up as indexed some products show up in all languages now, but a lot are not there, because indexation seems to get stuck Any clue anyone?
        Hide
        Rémi GAILLARD added a comment -

        Hi Bart,

        Can you try to apply this patch https://github.com/PrestaShop/PrestaShop/commit/f62064516994d9dea262f678f8173c812da96e5a and give us a feedback ?

        Best Regards,

        Show
        Rémi GAILLARD added a comment - Hi Bart, Can you try to apply this patch https://github.com/PrestaShop/PrestaShop/commit/f62064516994d9dea262f678f8173c812da96e5a and give us a feedback ? Best Regards,
        Hide
        Bart added a comment -

        Hi Remi,

        Just to be sure, are these steps correct:

        • connect with ftp
        • download the file to local drive: classes/Search.php
        • open with Notepad++
        • replace line 385 with $limit = max($max_possibilities, floor($limit / $max_possibilities) * $max_possibilities);
        • save file
        • re upload and overwrite existing file through FTP
        • ? do i need to restart some services or index after that?

        Thank you!
        Bart

        Show
        Bart added a comment - Hi Remi, Just to be sure, are these steps correct: connect with ftp download the file to local drive: classes/Search.php open with Notepad++ replace line 385 with $limit = max($max_possibilities, floor($limit / $max_possibilities) * $max_possibilities); save file re upload and overwrite existing file through FTP ? do i need to restart some services or index after that? Thank you! Bart
        Hide
        Rémi GAILLARD added a comment -

        Yes, that's it.
        And you need to rebuild your search index after and it should be working

        Best Regards,

        Show
        Rémi GAILLARD added a comment - Yes, that's it. And you need to rebuild your search index after and it should be working Best Regards,
        Hide
        Bart added a comment - - edited

        I did the above, indexation lasted forever but it seems to be working ok now. I was just wondering if the ps index table is suppose to be this large with only 225 products and 7 languages:
        Table Action Rows Type Collation Size Overhead
        ps_search_index Browse Structure Search Insert Empty Drop ~117,941Rows InnoDB utf8_general_ci 6.5 MiB -

        Its by far the largest table in the database

        Show
        Bart added a comment - - edited I did the above, indexation lasted forever but it seems to be working ok now. I was just wondering if the ps index table is suppose to be this large with only 225 products and 7 languages: Table Action Rows Type Collation Size Overhead ps_search_index Browse Structure Search Insert Empty Drop ~117,941Rows InnoDB utf8_general_ci 6.5 MiB - Its by far the largest table in the database
        Hide
        Rémi GAILLARD added a comment -

        Thank you for your feedback.
        Yes, this is normal, this table store all the words of your products for each languages.

        Best Regards,

        Show
        Rémi GAILLARD added a comment - Thank you for your feedback. Yes, this is normal, this table store all the words of your products for each languages. Best Regards,
        Hide
        Arnel Cee added a comment -

        Hello Remi - thanks for providing a solution for the issue. I had a quick question. I have a customer with a similar problem, but they are in version 1.5.4.1, will this solution also apply to that version? Or is a different patch available. The customer is working in Dutch and trying to upload 2600 products, but they are not all appearing when searched. I will send the customer this link after I make this comment. We do appreciate the help!

        Arnel C.
        InMotion Hosting Community Support Team

        Show
        Arnel Cee added a comment - Hello Remi - thanks for providing a solution for the issue. I had a quick question. I have a customer with a similar problem, but they are in version 1.5.4.1, will this solution also apply to that version? Or is a different patch available. The customer is working in Dutch and trying to upload 2600 products, but they are not all appearing when searched. I will send the customer this link after I make this comment. We do appreciate the help! Arnel C. InMotion Hosting Community Support Team

          People

          • Assignee:
            Rémi GAILLARD
            Reporter:
            Bart
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: