View Issue Details

IDProjectCategoryView StatusLast Update
3092Composrsearchpublic2017-03-03 16:23
ReporterAdam Edington Assigned ToChris Graham  
PrioritynormalSeverityminor 
Status resolvedResolutionfixed 
Summary3092: Search issues
DescriptionCouple of issues I am having with search, the first being no results for a single term (ie, Madonna) whereas a term such as 'Britney Spears' would return results when both exist in a Gallery.

The other problem I have noticed is that if you enter a meta tag such as '2017 Releases' there is no + automagically added between the two terms (which exist on a single line). Adding the + manually returns the results, so just wondering if there is any reason not to return on terms entered.
TagsNo tags attached.
Attach Tags
Time estimation (hours)
Sponsorship open

Sponsor

Date Added Member Amount Sponsored

Activities

Chris Graham

2017-02-26 19:03

administrator   ~4806

There are some limitations with MySQL's full text search. I am improving the documentation to make it a bit clearer. Use quotes if you're not doing a boolean search, "+" is only for boolean searches.

Keyword search for spaces with keywords has now been improved for this case.

Adam Edington

2017-03-03 12:18

administrator   ~4829

Last edited: 2017-03-03 12:20

Okay, well I can add a meta tag like 2017 Releases and when it's shown on a page the actual link created for that term doesn't have the "+" needed actually offer results is what I meant. I only got results when making it 2017+Releases in the URL it gave me.

Not sure you got what I meant and I'm not sure I get what you meant about adding "'s around a single term. I don't need to do that on any other site search, you enter a single term like Madonna and if there's any results you get them.

Adam Edington

2017-03-03 15:37

administrator   ~4834

Last edited: 2017-03-03 15:37

On RC33, if I search for 'Except One' without quotes I get nothing. If I search for 'Except One - Disease' it finds the video. Only other way to get to it with a simple 'Except One' search is to check the advanced link on Videos and select the actual category the video is in. However, this brings up both videos, one of which has nothing to do with that search term (which seems to be omitted from the URL at this stage).

Chris Graham

2017-03-03 16:23

administrator   ~4837

> I only got results when making it 2017+Releases in the URL it gave me.

This is a bit confusing to read, because "+" in a URL is a space. Also sometimes "%20" is used for the same thing. This is because URLs cannot contain spaces.
If it didn't have a "+" then that implies there was a space in the URL (which would be fine as the browser would auto fix that), or it was joined like "2017Releases" which I don't think is true.

I think you're actually saying you altered the search term in the search box (not the URL itself).

You are right there's a bug there, it should have quoted the tag in the tag link. I hadn't realised you were talking about tag links from content, I thought you were just talking about you typed in. I have fixed that for the next RC.

I wouldn't expect 'Except One' to return a result as both those words are likely 'stop words' in MySQL, i.e. ignored. If you put it in quotes though it will use a different algorithm that doesn't strip stop words out. I think. It gets complex due to the various limitations with MySQL, like the commonality limitation (i.e. if you have just 1 or 2 test content entries, search results may be missing because MySQL won't return more than 50% of a result set back to you).

Issue History

Date Modified Username Field Change
2017-02-26 08:06 Adam Edington New Issue
2017-02-26 19:03 Chris Graham Note Added: 0004806
2017-02-26 19:03 Chris Graham Status Not Assigned => Resolved
2017-02-26 19:03 Chris Graham Resolution open => fixed
2017-02-26 19:03 Chris Graham Assigned To => Chris Graham
2017-03-03 12:18 Adam Edington Note Added: 0004829
2017-03-03 12:19 Adam Edington Note Edited: 0004829
2017-03-03 12:20 Adam Edington Note Edited: 0004829
2017-03-03 15:37 Adam Edington Note Added: 0004834
2017-03-03 15:37 Adam Edington Note Edited: 0004834
2017-03-03 16:23 Chris Graham Note Added: 0004837