Main Content

Magnolia Community Forums: Get help with Magnolia: Binary (asset) full text search broken with 5.5.5?


  • tomwespi
    tomwespi
    Full name: Tom Wespi
    Posts: 38
    Last post: Sep 18, 2017 1:33:28 PM
    Binary (asset) full text search broken with 5.5.5?
    #1 by tomwespi on Aug 25, 2017 11:33:38 AM

    Hello there

    I try to achieve a fulltext search with searchfn over PDF files saved in the DAM workspace. Locally i also changed the index_configuration as described in https://jira.magnolia-cms.com/browse/MGNLDAM-667

    Since this still does not work I downloaded https://www.magnolia-cms.com/dam/jcr:82b2af18-0db3-425b-a075-f55929c29f8b/forrester-wave-wcm-2017Q1-magnolia-reprint.pdf and uploaded i to https://demoauthor.magnolia-cms.com in the dam app.

    When searching with the jcr tools or the dam app search, I was not able to find the document. Here a query I used:

    select * from nt:base where contains(*,'capabilities')

    No results with nodetype nt:base neither with mgnl:asset. Is binary full text search broken with 5.5.5? Has anybody achieved a search over binaries with 5.5.5? Any help highly appreciated.

    Best

    Tom

  • fgrilli
    fgrilli
    Full name: federico grilli
    Posts: 210
    Last post: Aug 28, 2017 11:57:29 AM
    Registered on: Sep 15, 2010
    Re: Binary (asset) full text search broken with 5.5.5?
    #2 by fgrilli on Aug 25, 2017 3:24:10 PM

    Hello Tom,

    I did some testing and actually can confirm that full-text search on PDFs doesn't work, not even when modifying the indexing configuration, as suggested at https://jira.magnolia-cms.com/browse/MGNLDAM-667. It's odd anyway, as the full text indexing should happen out of the box by using jackrabbit's default tika-config.xml which is correctly read at system startup.

    Furthermore, I found an old post on the forum where the feature did seem to work and the fix was only a matter of specifying the correct node type in the query https://forums.magnolia-cms.com/forum/thread.html?threadId=29180454-714e-4493-8783-245b193fd811

    Have you noticed if this used to work for you in previous Magnolia versions?

    Cheers,

    Federico

  • tomwespi
    tomwespi
    Full name: Tom Wespi
    Posts: 38
    Last post: Sep 18, 2017 1:33:28 PM
    Re: Binary (asset) full text search broken with 5.5.5?
    #3 by tomwespi on Aug 25, 2017 3:44:19 PM

    Hi Frederico

    I can confirm that it works OFTB with
    - 5.3.11, (sql, nt:base, select * from nt:base where contains(*,'capabilities')
    - 5.4.6 (sql, nt:base, select * from nt:base where contains(*,'capabilities')

  • fgrilli
    fgrilli
    Full name: federico grilli
    Posts: 210
    Last post: Aug 28, 2017 11:57:29 AM
    Registered on: Sep 15, 2010
    Re: Binary (asset) full text search broken with 5.5.5?
    #4 by fgrilli on Aug 28, 2017 11:57:29 AM

    Hello Tom,

    I filed a ticket about it https://jira.magnolia-cms.com/browse/MAGNOLIA-7123.

    HTH,

You don't have the permission to post on this thread

Sign in

To login on this forum, you can use your Magnolia Forge, Support or Partner account, or, below, your Google, Yahoo! or OpenID account. If you have trouble logging in, or any other sort of issue, please let us know in the Meta forum, on the user-list, or simply by email at forum-admin at magnolia-cms dot com.

* Required

... or sign in with:

  • icon http://{your-openid-url}
  • icon
  • icon https://me.yahoo.com/