# Search problems in v2.3

**URL:** https://meta.discourse.org/t/search-problems-in-v2-3/121301
**Category:** Support
**Created:** [6월 25, 2019, 5:15오후 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301 "2019-06-25T17:15:04Z")
**Posts on this page:** 16
**Page:** 1

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [6월 25, 2019, 5:15오후 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/1 "2019-06-25T17:15:04Z")

</div>

Hello,

I’ve upgraded our Discourse instance from 2.2.6 to 2.3. Unfortunately we’ve noticed some issues with search:

- the result contains mostly totally unrelated posts (many posts don’t have the search phrase)
- the search ignores the options (like Matching in title only)

It shows up with terms containing accent like Hungarian word “tészta” 🙂 **Ignore accents when searching for text.** in admin settings is unchecked.

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [6월 26, 2019, 1:28오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/2 "2019-06-26T01:28:50Z")

</div>

If you ever amend the site setting `search ignore accents` you must rebuild the full search index with:

```plaintext
./launcher enter app
rake search:reindex

```

---

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [6월 26, 2019, 7:31오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/3 "2019-06-26T07:31:47Z")

</div>

Thanks for the hint! Unfortunately it doesn’t solve the problem ☹

It’s quite weird that some pre-2.3 posts contain search URLs (some has multi-word search terms with different accents) which are working fine and return valid result while new search queries are not working and give back not relevant posts.

---

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [6월 30, 2019, 11:34오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/4 "2019-06-30T11:34:04Z")

</div>

Has nobody met this problem? 😨

Unfortunately accents can’t be ignored because it would result in inaccurate results. Where should I look to fix this issue? Maybe downgrading back to 2.2 (it’d be just a temporary fix though ☹ )?

Any idea is welcome!

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [7월 1, 2019, 12:03오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/5 "2019-07-01T00:03:19Z")

</div>

I still don’t understand the problem.

Post an exact chunk of text here with behaviour you would expect. We can then test this on local.

---

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [7월 1, 2019, 7:40오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/6 "2019-07-01T07:40:46Z")

</div>

Search term: “kávé in:title” (it doesn’t work without in:title either)

A snippet from results:

- Sesame cabbage
- Cabbage pastry
- About swearing and rude speech
- Walnut, chocolate masala **coffee**
- Cabbage pizza
- Homemade **coffee** concentrate

The correct result should be:

- Walnut, chocolate masala **coffee**
- Walnut, milky **coffee**
- Homemade **coffee** concentrate

Besides the irrelevant results, some valid ones are not listed at all.

Thanks a lot!

---

<div class="post-metadata">

### Author: ![sam](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/sam/32/102149_2.png) [@sam](https://meta.discourse.org/u/sam)
#### Post date: [7월 1, 2019, 7:45오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/7 "2019-07-01T07:45:28Z")

</div>

And you confirm 100% that `search ignore accents` in site setting is unchecked and that you did a reindex after unchecking that?

---

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [7월 1, 2019, 7:50오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/8 "2019-07-01T07:50:48Z")

</div>

![search_settings](https://global.discourse-cdn.com/meta/original/3X/4/7/472581f22d5d830fdd2f625ccb87516323e74507.png)

I did the reindex after you’ve mentioned in your post and it completed without any issues.

---

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [7월 14, 2019, 8:20오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/10 "2019-07-14T08:20:23Z")

</div>

Any update on this issue?

---

<div class="post-metadata">

### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [7월 15, 2019, 10:25오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/12 "2019-07-15T10:25:08Z")

</div>

I just tested on [try.discourse.org](http://try.discourse.org) and created 5 topics with the titles you provided.

 ![image](https://global.discourse-cdn.com/meta/original/3X/8/8/88f4af57577898f58d1f0aa06228a077c492b6ce.png)

Then, I searched for “`kávé in:title`” and got these results

 ![image](https://global.discourse-cdn.com/meta/original/3X/9/5/959a89407d98d3a326505665fd19950414e6d666.png)

Which looks correct to me 🤷‍♂️

Can you show us the list of all the site settings you’ve changed?  
(⚠ _make sure you scrap all sensitive values though_)

---

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [7월 16, 2019, 8:26오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/13 "2019-07-16T08:26:52Z")

</div>

Thank you for looking into this problem 👍

 ![backup](https://global.discourse-cdn.com/meta/original/3X/4/a/4ab448d6a035973181273c0fae19c45f1274a47f.png) ![basic_settings](https://global.discourse-cdn.com/meta/original/3X/4/1/41301cefc6532c2006c48a76c74071543e3f6d58.png) ![files](https://global.discourse-cdn.com/meta/original/3X/b/f/bf1d0deae9366cf9b11b8d6077a9adf4a7f425c1.png) ![login](https://global.discourse-cdn.com/meta/original/3X/8/c/8c5a389dd409c87c16b5cb4b6fe2c3faf8e891ea.png) ![misc](https://global.discourse-cdn.com/meta/original/3X/7/3/73910c7d8413713212ca9b3593b04f9e592241e5.png) ![publish](https://global.discourse-cdn.com/meta/original/3X/c/f/cfb5b697d56427d93bc11f5c663c507f1d67f4d6.png) ![required](https://global.discourse-cdn.com/meta/original/3X/0/2/02b4014729d1d5ac39bc8dfb8a14bc2933ee7f4a.png) ![search](https://global.discourse-cdn.com/meta/original/3X/4/0/40ad89c160a7e55875f3ede0eeaf9d05ae508041.png) ![security](https://global.discourse-cdn.com/meta/original/3X/9/6/9639a59f69c77ea73c7e3e387919bdb003c71cea.png) ![spam](https://global.discourse-cdn.com/meta/original/3X/0/8/081137845e196a6dcf414936a27b653428bfbf22.png) ![user_settings](https://global.discourse-cdn.com/meta/original/3X/6/a/6abfc11b15ae8e684c6680283fb1ed7a3b11da12.png)

Branding was left out there are only images.

---

<div class="post-metadata">

### Author: ![zogstrip](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/zogstrip/32/512781_2.png) [@zogstrip](https://meta.discourse.org/u/zogstrip)
#### Post date: [7월 17, 2019, 8:07오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/14 "2019-07-17T08:07:40Z")

</div>

Just tried locally with the default locale set to “`magyar`” and it works as well

 ![image](https://global.discourse-cdn.com/meta/original/3X/7/c/7c5f92340403405601e3ebb71313950c75484c17.png)

Can you make sure you upgrade to latest and check again?

---

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [8월 7, 2019, 3:08오후 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/15 "2019-08-07T15:08:16Z")

</div>

Yes but unfortunately it did not help ☹

---

<div class="post-metadata">

### Author: ![netpositive](https://avatars.discourse-cdn.com/v4/letter/n/8edcca/32.png) [@netpositive](https://meta.discourse.org/u/netpositive)
#### Post date: [9월 11, 2019, 9:47오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/16 "2019-09-11T09:47:04Z")

</div>

I’ve made a fresh local install and “kávé” worked OK but some other words did not. It seems the problem is related to the full text search in PostgreSQL and how the text is parsed. For example from search word “kávé” will be “ká” after normalization and that normalized form will be matched to the text so “ **ká** vé” and “ **ká** poszta” are both correct results for the FTS 🙂

I hope the situation will improve with using hunspell dictionaries in PostgreSQL but currently the Hungarian one is broken 😭

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [4월 16, 2023, 8:39오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/17 "2023-04-16T08:39:16Z")

</div>



---

<div class="post-metadata">

### Author: ![RGJ](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/rgj/32/523185_2.png) [@RGJ](https://meta.discourse.org/u/RGJ)
#### Post date: [4월 16, 2023, 8:40오전 UTC](https://meta.discourse.org/t/search-problems-in-v2-3/121301/18 "2023-04-16T08:40:29Z")

</div>


