Page MenuHomePhabricator

On Special:Drilldown Searching a string on pdf fullText display a database error
Closed, ResolvedPublic

Description

On the page Special:Drilldown, when searching a string that exist on pdf full text field (Table _fileData) it displays "A database query error" Error: 1054 Unknown column '1' in 'order clause

Check the full error message on : http://discoursedb.org/wiki/Special:Drilldown/_fileData?title=Special%3ADrilldown%2F_fileData&_search=France

If I search in the Special:ViewData
Table(s): _fileData
Where : _fullText HOLDS LIKE '%AnyWord%'
I get a fatal error "Wikimedia\Rdbms\DBQueryError"

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptJun 6 2019, 3:01 PM

Sorry about the first problem - I just checked in what I think is a fix for it.

For the second problem, I think you just need to replace "HOLDS LIKE" with "HOLDS". _fileData is not a list field.

Thanks for the fix for the first problem, will you release a new (minor) version of Cargo ?
For the second problem I still get a database error with
Table(s): _fileData
Where: _fullText HOLDS '%France%'

http://discoursedb.org/wiki/Special:ViewData?title=Special%3AViewData&tables=_fileData&fields=&where=HOLDS+%27%25France%25%27&join_on=&group_by=&having=&order_by=&limit=&offset=&format=

@Nicolas_NALLET - try _fullText MATCHES 'France'

Sorry - I meant to say "LIKE", not "HOLDS". But "MATCHES" is probably an even better idea.

And yes, I should release a new version of Cargo, with all the bug fixes from the last few months...

Yaron_Koren closed this task as Resolved.Jun 10 2019, 6:16 PM
Yaron_Koren claimed this task.

I have now also released a new version of Cargo. Closing this bug.