bannerBaka-UpdatesManga
Manga Poll
Do you go back and read the extras and side stories that are released after you've already finish the main series?
Always
Usually
Sometimes
Never
 
mascot
Manga is the Japanese equivalent of comics
with a unique style and following. Join the revolution! Read some manga today!

RSS Feed

Series (title) search bugs

You must be registered to post!
From User
Message Body
Member


14 years ago
Posts: 41

I've found a few search results that don't give any results, yet should.

By way of a complete example: here...
Title search for here: no results. Letter filter for here (match beginning of title): about a dozen results (and this excludes a few series with here in the middle of the title (and not there or where) that you can find by searching releases).

Other problem terms: her, he, there, where, everywhere. (I'd add h, but it seems you don't match single letters at all.)

Oddly enough, whereabouts turned up results just fine. Besides the variations on here, I've tried a small number of other search terms which all worked fine.

ADDENDUM:
I've discovered that by quoting the search term, you can get results...however, the term then appears to act basically like regex instead of a whole word match, so that searching "he" matches Cheap and not just He. So while this method might be okay for longer terms, it's not exactly ideal.

Not quite about the search, rather about its ordering/sorting...it doesn't work, for title, year, or rating.

Default order: pretty obviously not in any sensible order, not by title, year, or rating, not even series id or main title.
By title: exact same ordering as the default (i.e., not correct). Perhaps the default order is supposed to be by title?
By year: slight change from default, but still not correctly ordered.
By rating: slight change again, but still not correctly ordered.

Sort and page navigation (within results) links escape special characters (including backslashes!), leading to a vicious cycle.

I can search for "here" (the quotes are part of the term) and I get one set of results, but then if I try to change the sort or move to another page of results, these links escape the quotes with backslashes. This comes out like I was searching for here plus (i.e., logical OR in your system) a double-quote character, which is a different set of results which I do not want. Even crazier, if you don't notice that those backslashes got added and click another of those links, they escape the quotes again, plus the backslashes it just added! This is exponential growth, a vicious cycle.

Edit:
It occurs to me that 3 issues in one topic may not be...polite? appreciated? I didn't notice a rule saying not to, though...so until someone speaks up about it, I'll stick with this for now.


... Last edited by tericloth 14 years ago
user avatar
Site Admin


14 years ago
Posts: 2855
  1. It uses mysql's fulltext index on title. Quotes is a special thing i added to do mysql 'LIKE' searches (less efficient, hard on DB) We also support AND and OR clauses. "here" is a dictionary word, as is 'he', (read about mysql fulltext stop words).

  2. Not sure what you mean here. Default is by title. Clicking on the year or rating will do ordering based on those fields ... year is an alpha sort (which is bad but meh), but rating is a numerical float based sort.

  3. I think i've fixed this 600 times, but it always seems to break. i will investigate.


Post #445022 - Reply To (#444958) by Manick
Post #445022 - Reply To (#444958) by Manick
Member


14 years ago
Posts: 41

Quote from Manick

  1. Not sure what you mean here.

I mean when I look at the results for test ordered by title, I see...
1st: Please Test Me (aka Otameshi Kudasai)
2nd: Angel Test
3rd: Baka to Test to Shokanjuu
(etc...)
From P, down to A, then back up to B is not alphabetical.

So, the sort doesn't work properly...at least, not for me. The order doesn't seem to follow any of the details I can think to examine (year, rating, series id, etc); it looks entirely random, to me.

Likewise the results I see for order by year or rating are basically random.


user avatar
Site Admin


14 years ago
Posts: 2855

Ah, the sorting is also handled by mysql's fulltext algorithm.

where match (title) against ('test') order by match (title) against ('test')

I'd like to improve the search too ...


You must be registered to post!