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

          Swift 4 - func physicsWorld not invoked on collision? The Next CEO of Stack OverflowHow to call Objective-C code from Swift#ifdef replacement in the Swift language@selector() in Swift?#pragma mark in Swift?Swift for loop: for index, element in array?dispatch_after - GCD in Swift?Swift Beta performance: sorting arraysSplit a String into an array in Swift?The use of Swift 3 @objc inference in Swift 4 mode is deprecated?How to optimize UITableViewCell, because my UITableView lags

          Access current req object everywhere in Node.js ExpressWhy are global variables considered bad practice? (node.js)Using req & res across functionsHow do I get the path to the current script with Node.js?What is Node.js' Connect, Express and “middleware”?Node.js w/ express error handling in callbackHow to access the GET parameters after “?” in Express?Modify Node.js req object parametersAccess “app” variable inside of ExpressJS/ConnectJS middleware?Node.js Express app - request objectAngular Http Module considered middleware?Session variables in ExpressJSAdd properties to the req object in expressjs with Typescript