XMLWordPrintable

Details

    Description

      When searching for some keywords I was getting no results.
      Attributes were searchable and I tried to raise StopWordThresholdValue and StopWordThresholdPercent to avoid stop words issues with no results.

      Then I tried to rebuild index tables with bin/php/updatesearchindex.php and I was getting a SQL error, some chars were making the query syntax invaild.

      This is the error from the log:

      Query error (1366): Incorrect string value: '\xE9\x80' for column 'word' at row 134. Query: INSERT INTO
      ezsearch_word ( word, object_count )
      VALUES ('hat', '1' ), ('unternehmen', '1' ), ('seine', '1' ), ('kompetenz', '1' ), ('technisches', '1' ), ('genutzt', '1' ), ('realisieren', '1' ), ('welche', '1' ), ('dem', '1' ), ('hochsten', '1' ), ('qualitatsstandard', '1' ), ('gerecht', '1' ), ('werden', '1' ), ('an', '1' ), ('absoluten', '1' ), ('spitze', '1' ), ('bietet', '1' ), ('kuche', '1' ), ('aktuellem', '1' ), ('stil', '1' ), ('gestaltet', '1' ), ('tillverkat', '1' ), ('kåpor', '1' ), ('år', '1' ), ('trettio', '1' ), ('års', '1' ), ('erfarenhet', '1' ), ('och', '1' ), ('dagligt', '1' ), ('engagemang', '1' ), ('att', '1' ), ('kunna', '1' ), ('erbjuda', '1' ), ('dig', '1' ), ('uppmarksamhet', '1' ), ('detaljer', '1' ), ('basta', '1' ), ('europeisk', '1' ), ('under', '1' ), ('vilka', '1' ), ('utvecklat', '1' ), ('kunskap', '1' ), ('gjort', '1' ), ('mojligt', '1' ), ('oss', '1' ), ('skapa', '1' ), ('stor', '1' ), ('samling', '1' ), ('produkter', '1' ), ('med', '1' ), ('enastående', '1' ), ('personlighet', '1' ), ('teknik', '1' ), ('gått', '1' ), ('samman', '1' ), ('produkten', '1' ), ('gjorde', '1' ), ('falmecs', '1' ), ('medarbetare', '1' ), ('verkliga', '1' ), ('experter', '1' ), ('inom', '1' ), ('utveckling', '1' ), ('gor', '1' ), ('våra', '1' ), ('ett', '1' ), ('koncentrat', '1' ), ('spiskåpan', '1' ), ('excellens', '1' ), ('producem', '1' ), ('hote', '1' ), ('bucatarie', '1' ), ('peste', '1' ), ('treizeci', '1' ), ('ani', '1' ), ('experiența', '1' ), ('și', '1' ), ('angajament', '1' ), ('cotidian', '1' ), ('cu', '1' ), ('scopul', '1' ), ('va', '1' ), ('oferi', '1' ), ('calitate', '1' ), ('atenție', '1' ), ('detalii', '1' ), ('atingand', '1' ), ('cele', '1' ), ('mai', '1' ), ('inalte', '1' ), ('culmi', '1' ), ('ale', '1' ), ('excelenței', '1' ), ('europene', '1' ), ('care', '1' ), ('ne', '1' ), ('am', '1' ), ('dezvoltat', '1' ), ('competențele', '1' ), ('ce', '1' ), ('au', '1' ), ('permis', '1' ), ('cream', '1' ), ('colecție', '1' ), ('colosala', '1' ), ('produse', '1' ), ('personalitate', '1' ), ('remarcabila', '1' ), ('tehnologia', '1' ), ('pasiunea', '1' ), ('fuzionat', '1' ), ('pentru', '1' ), ('cel', '1' ), ('bun', '1' ), ('produs', '1' ), ('posibil', '1' ), ('oamenii', '1' ), ('devenit', '1' ), ('adevarați', '1' ), ('experți', '1' ), ('aspirații', '1' ), ('facand', '1' ), ('din', '1' ), ('produsele', '1' ), ('noastre', '1' ), ('simbol', '1' ), ('hotei', '1' ), ('抽油', '1' ), ('油烟', '1' ), ('烟机', '1' ), ('机', '1' ), ('专业', '1' ), ('业制', '1' ), ('制逧, '1' ), ('造三', '1' ), ('三十', '1' ), ('十年', '1' ), ('年', '1' ), ('年的', '1' ), ('的行', '1' ), ('行业', '1' ), ('业经', '1' ), ('经验', '1' ), ('验', '1' ), (',', '1' ), ('以及', '1' ), ('及我', '1' ), ('我们', '1' ), ('们在', '1' ), ('在质', '1' ), ('质量', '1' ), ('量和', '1' ), ('和细', '1' ), ('细节', '1' ), ('节上', '1' ), ('上对', '1' ), ('对客', '1' ), ('客户', '1' ), ('户的', '1' ), ('的日', '1' ), ('日常', '1' ), ('常承', '1' ), ('承诺', '1' ), ('诺', '1' ), ('造就', '1' ), ('就了', '1' ), ('了今', '1' ), ('今日', '1' ), ('日能', '1' ), ('能在', '1' ), ('在欧', '1' ), ('欧洲', '1' ), ('洲享', '1' ), ('享誉', '1' ), ('誉最', '1' ), ('最佳', '1' ), ('佳。', '1' ), ('。三', '1' ), ('年间', '1' ), ('间', '1' ), ('们已', '1' ), ('已开', '1' ), ('开发', '1' ), ('发出', '1' ), ('出专', '1' ), ('专门', '1' ), ('门的', '1' ), ('的技', '1' ), ('技术', '1' ), ('术', '1' ), ('积累', '1' ), ('累了', '1' ), ('了经', '1' ), ('使我', '1' ), ('们能', '1' ), ('能创', '1' ), ('创逧, '1' ), ('造大', '1' ), ('大量', '1' ), ('量的', '1' ), ('的产', '1' ), ('产品', '1' ), ('品并', '1' ), ('并获', '1' ), ('获得', '1' ), ('得绝', '1' ), ('绝佳', '1' ), ('佳声', '1' ), ('声誉', '1' ), ('誉。', '1' ), ('。', '1' ), ('历经', '1' ), ('经', '1' ), ('年技', '1' ), ('术和', '1' ), ('和激', '1' ), ('激情', '1' ), ('情的', '1' ), ('的完', '1' ), ('完美', '1' ), ('美融', '1' ), ('融合', '1' ), ('合', '1' ), ('为您', '1' ), ('您提', '1' ), ('提供', '1' ), ('供最', '1' ), ('最优', '1' ), ('优质', '1' ), ('质的', '1' ), ('品', '1' ), (';', '1' ), ('这', '1' ), ('年使', '1' ), ('使得', '1' ), ('得', '1' ), ('fammec', '1' ), ('人成', '1' ), ('成为', '1' ), ('为真', '1' ), ('真正', '1' ), ('正的', '1' ), ('的专', '1' ), ('专家', '1' ), ('家', '1' ), ('也让', '1' ), ('让我', '1' ), ('们的', '1' ), ('品优', '1' ), ('优秀', '1' ), ('秀地', '1' ), ('地成', '1' ), ('为抽', '1' ), ('机的', '1' ), ('的象', '1' ), ('象征', '1' ), ('征。', '1' )

      There are some chinese chars that are added to the query but result without the string delimiter.

      I tried to fix the issue by editing addObject() in ezsearchengine.php by utf8-encoding the result of this line:

      $text = eZSearchEngine::normalizeText( htmlspecialchars ($metaDataPart['text'], ENT_NOQUOTES, 'UTF-8' ) , true );

      which becomes:

      $text = utf8_encode(eZSearchEngine::normalizeText( htmlspecialchars ($metaDataPart['text'], ENT_NOQUOTES, 'UTF-8' ) , true ));

      After that it seems working properly

      Attachments

        Activity

          People

            Unassigned Unassigned
            alex.berlato alex.berlato
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours
                2h