Search plugin error

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
eanon
Posts: 16
Joined: 18 Feb 2013, 13:22

Search plugin error

Post by eanon »

Hello,

I don't know where to ask about an error with the Search 0.0.3 by Krasnov Kirill (the support tab in the project page at GitHub doesn't seem very active - 1 question without answer). This plugin appears in the the official MantisBT Community Plugins at http://github.com/mantisbt-plugins?page=1, so I guess we can talk about it here (even if not listed in the Plugin section of the forum).

Well, my MantiBT is for internal use between me and my team of testers. Mantis is initially installed on my dev station under Windows/Apache and reachable by my testers through another Mantis front-end under CentOS/Apache. Both front-end are MantisBT 1.2.14.

The Search plugin is well installed in both cases (ie. the two front-end), but in both cases I get this same error trying to launch a search :

Code: Select all

APPLICATION ERROR #401 

Database query failed. Error received from database was #1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where (summary LIKE '%test%')' at line 1 for the query: select * from where (summary LIKE ?).

Previous non-fatal errors occurred. Page contents follow.
APPLICATION WARNING #100: Configuration option "bug" not found.
APPLICATION WARNING #100: Configuration option "bug_text" not found.
APPLICATION WARNING #100: Configuration option "bugnote_text" not found.

So, don't know if it's an issue with my database or in the SQL query... What do you think ?

PS : The reason why I installed this plugin is to conduct research in the bugnotes. So, if you have another solution, I'm ready to listen 8O
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Search plugin error

Post by atrol »

Enter an issues for it at https://github.com/mantisbt-plugins/search/issues and/or contact the author by e-mail.

I don't know what this plugin is able to search what you can't search on the "View Issues" page.
Please use Search before posting and read the Manual
eanon
Posts: 16
Joined: 18 Feb 2013, 13:22

Re: Search plugin error

Post by eanon »

OK, if I really need it, I'll submit an issue report, but before that let make the point (your last sentence intrigued me) :

Does the standard search field in the "View issues" page allows searching in all the fields (including bugnotes) ?
Does it allows searching from an expression with AND/OR/NOT ?

If the answers to these two questions are YES, I don't need this plugin !
If it's yes for the first question only, it would be very well too and I could live w/o this plugin for the moment.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Search plugin error

Post by atrol »

Sounds a bit strange to me.
You are installing a plugin before trying what the standard functionality does?

The notes are also searched.

There is a simple syntax, e.g. enter: Word1 Word2 -Word3
and you will get all issues that contain
Word1 AND Word2 AND NOT Word3
Please use Search before posting and read the Manual
eanon
Posts: 16
Joined: 18 Feb 2013, 13:22

Re: Search plugin error

Post by eanon »

I tried of course... But didn't succeeded with a word (even not an expression) I thought was in my bugnotes.. I'll take a new try.

Edit on 2014/09/19 : Effectivelly, it works with standard search feature. Maybe my previous try was with a filter hidding the relevant report... Don't know. Well, so, a question : Why do you reference the Search plugin in what we could consider (at least from the visitor point of view) like an official list (ie. approved one) ?
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Search plugin error

Post by atrol »

eanon wrote:Why do you reference the Search plugin in what we could consider (at least from the visitor point of view) like an official list (ie. approved one) ?
I am not aware that I ever referenced any plugin as a approved one.
Please use Search before posting and read the Manual
eanon
Posts: 16
Joined: 18 Feb 2013, 13:22

Re: Search plugin error

Post by eanon »

This plugin is in one of the two lists directly referenced from http://www.mantisbt.org/addons.php. So, a visitor can suppose that it's a kind of approved plugins.
atrol
Site Admin
Posts: 8366
Joined: 26 Mar 2008, 21:37
Location: Germany

Re: Search plugin error

Post by atrol »

eanon wrote: So, a visitor can suppose that it's a kind of approved plugins.
The plugins are all 3rd party development. The authors are responsible for the plugins.
You get "MantisBT Community Plugins" at https://github.com/mantisbt-plugins

There is also no MantisBT Team copyright and contact in this plugin.
https://github.com/mantisbt-plugins/sea ... rch.php#L5
https://github.com/mantisbt-plugins/sea ... ch.php#L44
Please use Search before posting and read the Manual
eanon
Posts: 16
Joined: 18 Feb 2013, 13:22

Re: Search plugin error

Post by eanon »

Understood, but maybe you should add a mention indicating this (ie. no filter nor approval). Explicit is always clearer than implcit.
Post Reply