Django 1.11 - Use search with unaccent extensionWhat is a “slug” in Django?How do I do a not equal in Django queryset filtering?Does Django scale?What's the difference between django OneToOneField and ForeignKey?Need a minimal Django file upload exampledifferentiate null=True, blank=True in djangoHow to update User object without creating new one?How to create a user with just First name, Last name and emai. And not with the usernameDjango Invitation app link to other modelsdjango full text search: how to do with accent text

Why does there seem to be an extreme lack of public trashcans in Taiwan?

Changing the PK column of a data extension without completely recreating it

Can an open source licence be revoked if it violates employer's IP?

What does BREAD stand for while drafting?

What publication claimed that Michael Jackson died in a nuclear holocaust?

What did the 8086 (and 8088) do upon encountering an illegal instruction?

How can I find out about the game world without meta-influencing it?

I am caught when I was about to steal some candies

How do I properly use a function under a class?

Can I attach a DC blower to intake manifold of my 150CC Yamaha FZS FI engine?

Someone who is granted access to information but not expected to read it

What's the relation between у.е. to USD?

Is it good practice to create tables dynamically?

Why is it bad to use your whole foot in rock climbing

Which are the methodologies for interpreting Vedas?

Print "N NE E SE S SW W NW"

David slept with Bathsheba because she was pure?? What does that mean?

How (un)safe is it to ride barefoot?

How to import .txt file with missing data?

Can I use 220 V outlets on a 15 ampere breaker and wire it up as 110 V?

Nth term of Van Eck Sequence

Can you open the door or die? v2

The best in flight meal option for those suffering from reflux

Is it advisable to add a location heads-up when a scene changes in a novel?



Django 1.11 - Use search with unaccent extension


What is a “slug” in Django?How do I do a not equal in Django queryset filtering?Does Django scale?What's the difference between django OneToOneField and ForeignKey?Need a minimal Django file upload exampledifferentiate null=True, blank=True in djangoHow to update User object without creating new one?How to create a user with just First name, Last name and emai. And not with the usernameDjango Invitation app link to other modelsdjango full text search: how to do with accent text






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








0















Problem



We need to use Django search with the unaccent extension. So far I installed the extension with a migration and added 'django.contrib.postgres' to installed apps. After I wrote some code to query the databe. I don't know why but I keep getting this error and I can't find any information about what it means.



Error



text search configuration "unaccent" does not exist at character 701



Migration



from django.db import migrations


class Migration(migrations.Migration):

dependencies = [
('team', '0006_team_team_image'),
]

operations = [
UnaccentExtension()
]


Code



from django.contrib.postgres.search import SearchVector, SearchQuery

sv = SearchVector('first_name', 'last_name', 'email')
parsed_body = json.loads(request.body.decode('utf-8'))
query = parsed_body['query']
users = User.objects.annotate(search = sv).filter(search = SearchQuery(query, config = 'unaccent'))

response =
'users': ['full_name': u.get_full_name(), 'email': u.email, 'pk': u.pk for u in users]










share|improve this question




























    0















    Problem



    We need to use Django search with the unaccent extension. So far I installed the extension with a migration and added 'django.contrib.postgres' to installed apps. After I wrote some code to query the databe. I don't know why but I keep getting this error and I can't find any information about what it means.



    Error



    text search configuration "unaccent" does not exist at character 701



    Migration



    from django.db import migrations


    class Migration(migrations.Migration):

    dependencies = [
    ('team', '0006_team_team_image'),
    ]

    operations = [
    UnaccentExtension()
    ]


    Code



    from django.contrib.postgres.search import SearchVector, SearchQuery

    sv = SearchVector('first_name', 'last_name', 'email')
    parsed_body = json.loads(request.body.decode('utf-8'))
    query = parsed_body['query']
    users = User.objects.annotate(search = sv).filter(search = SearchQuery(query, config = 'unaccent'))

    response =
    'users': ['full_name': u.get_full_name(), 'email': u.email, 'pk': u.pk for u in users]










    share|improve this question
























      0












      0








      0








      Problem



      We need to use Django search with the unaccent extension. So far I installed the extension with a migration and added 'django.contrib.postgres' to installed apps. After I wrote some code to query the databe. I don't know why but I keep getting this error and I can't find any information about what it means.



      Error



      text search configuration "unaccent" does not exist at character 701



      Migration



      from django.db import migrations


      class Migration(migrations.Migration):

      dependencies = [
      ('team', '0006_team_team_image'),
      ]

      operations = [
      UnaccentExtension()
      ]


      Code



      from django.contrib.postgres.search import SearchVector, SearchQuery

      sv = SearchVector('first_name', 'last_name', 'email')
      parsed_body = json.loads(request.body.decode('utf-8'))
      query = parsed_body['query']
      users = User.objects.annotate(search = sv).filter(search = SearchQuery(query, config = 'unaccent'))

      response =
      'users': ['full_name': u.get_full_name(), 'email': u.email, 'pk': u.pk for u in users]










      share|improve this question














      Problem



      We need to use Django search with the unaccent extension. So far I installed the extension with a migration and added 'django.contrib.postgres' to installed apps. After I wrote some code to query the databe. I don't know why but I keep getting this error and I can't find any information about what it means.



      Error



      text search configuration "unaccent" does not exist at character 701



      Migration



      from django.db import migrations


      class Migration(migrations.Migration):

      dependencies = [
      ('team', '0006_team_team_image'),
      ]

      operations = [
      UnaccentExtension()
      ]


      Code



      from django.contrib.postgres.search import SearchVector, SearchQuery

      sv = SearchVector('first_name', 'last_name', 'email')
      parsed_body = json.loads(request.body.decode('utf-8'))
      query = parsed_body['query']
      users = User.objects.annotate(search = sv).filter(search = SearchQuery(query, config = 'unaccent'))

      response =
      'users': ['full_name': u.get_full_name(), 'email': u.email, 'pk': u.pk for u in users]







      django django-models






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Mar 25 at 0:19









      Tiago MartinsTiago Martins

      286




      286






















          0






          active

          oldest

          votes












          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55329861%2fdjango-1-11-use-search-with-unaccent-extension%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55329861%2fdjango-1-11-use-search-with-unaccent-extension%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

          SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

          은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현