It is currently 28 Mar 2024, 09:07




 Page 1 of 1 [ 12 posts ] 
Author Message
 Post subject: Search ability
PostPosted: 30 Dec 2014, 16:17 
Advanced fan
Advanced fan
User avatar

Joined: 02 Oct 2008, 04:35
Posts: 565
Location: Minnesota, United States
Has thanked: 0 time
Been thanked: 2 times
Since most people aren't used to the classic boolean type search that's (I'm assuming) is used for searches on the site and forum, is there a way to make it more "google-like"?

I tend to have issues searching for anything with a : or - in it. Many titles have : in them and if I leave it out they don't show up and if I put it in I get no results even with "" around the title. A recent example: I went to search the forums for LD-S2 which I know is in many posts and got no results with "ld-s2" or ld-s2. If I type lds2 I get results but only where it's spelled lds2, nothing where someone spelled it ld-s2 shows up. I'm sure I'm searching incorrectly for the type of search that's implemented here, but if I'm doing it wrong I'm sure others who've known nothing but google are doing it wrong too and getting frustrated.
_________________
Laserdisc Player
CLD-3080 w/ AC-3
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 06 Jan 2015, 18:37 
Hardcore fan
Hardcore fan
User avatar

Joined: 20 Feb 2011, 19:23
Posts: 1033
Location: United Kingdom
Has thanked: 30 times
Been thanked: 26 times
I have the same problems in the main site search. For titles with colons or dashes or any other less than common character I tend to just use google and append "laserdisc" to the end of what I'm searching for and the lddb entry I'm looking for usually comes up.

A recent example I found problematic was searching for Star Wars: Classic Creatures: Return of the Jedi (1983) [PILF-2081] I couldn't remember what the title was so I tried "return of the jedi creatures" which returns no results. In fact searching for " star wars return of the jedi classic creatures" returns no results despite the search term including all of the words of the laserdisc title except for the colons. Oddly searching for "classic creatures" returns it right away.
_________________
Pioneer DVL-919E, Onkyo TX-NR626, LG C8 OLED.
My Collection
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 06 Jan 2015, 19:28 
Jedi Master
Jedi Master
User avatar

Joined: 03 May 2004, 19:05
Posts: 8093
Location: Dullaware
Has thanked: 1218 times
Been thanked: 841 times
agree, there are too many issues with the search once you start dealing with the above, colons, semi colons etc.
these issues are very annoying when searching for things like star trek, star wars or others where there are too many in the database.

________________________________
the rein-o official signature:


Image
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 13 Jan 2015, 20:58 
Jedi Master
Jedi Master
User avatar

Joined: 03 May 2004, 19:05
Posts: 8093
Location: Dullaware
Has thanked: 1218 times
Been thanked: 841 times
OK just found an issue.
when searching for ben hur nothing comes up, but when you search for ben-hur you get all the listings.

one should be able to find with both searches not just one, this will also cut down on insertions by new or old members who don't know about this issue.

________________________________
the rein-o official signature:


Image
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 13 Jan 2015, 21:21 
Jedi Knight
Jedi Knight
User avatar

Joined: 14 Jan 2010, 09:44
Posts: 5968
Location: Ann Arbor
Has thanked: 1273 times
Been thanked: 1089 times
I've never been a member of a forum where the search wasn't total garbage. This one is no exception. It would be nice to have a decent search, but I honestly stopped using the search field on any forum probably a decade ago. This is not a negative statement aimed at this forum in particular, this forum is fantastic, but asking a forum search engine to not suck is like complaining that the "As Seen On TV" section at Target isn't delivering. I assume the search code is built into the forum software package and is not fixed easily. More than once I've typed in the EXACT TEXT that was used as the title of the post and not had it turn up. When it's that bad I don't know what the fix is.

I just go to Google and put the name of the forum in the search. That usually does a pretty good job, a better job anyway.
_________________
All about LD care, inner sleeves, shrink wrap, etc.

https://youtu.be/b3O-vHpHRpM
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 13 Jan 2015, 21:53 
Jedi Master
Jedi Master
User avatar

Joined: 03 May 2004, 19:05
Posts: 8093
Location: Dullaware
Has thanked: 1218 times
Been thanked: 841 times
uh oh, I think I totally miss posted under this topic.
I was talking about just searching for LDs under the database.
Searching under the topics is another story entirely, very hard and it takes time.

again I was talking about regular disc searches.

________________________________
the rein-o official signature:


Image
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 22 Jan 2015, 21:04 
Advanced fan
Advanced fan
User avatar

Joined: 02 Oct 2008, 04:35
Posts: 565
Location: Minnesota, United States
Has thanked: 0 time
Been thanked: 2 times
rein-o wrote:
uh oh, I think I totally miss posted under this topic.
I was talking about just searching for LDs under the database.
Searching under the topics is another story entirely, very hard and it takes time.

again I was talking about regular disc searches.

I think you're OK. I addressed both forum searches and database searches in my original post because the same sorts of searches cause problems in both. I should have made it more clear that I had an issue with BOTH the LDDB title search and the forum search.
_________________
Laserdisc Player
CLD-3080 w/ AC-3
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 17 Aug 2015, 11:28 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
rein-o wrote:
when searching for ben hur nothing comes up, but when you search for Ben-hur you get all the listings.


I fixed the Ben-Hur/Ben Hur one by adding more punctuation and symbols to the transparent list (on LDDb.com).

For the forum, I'm using the default phpBB3 engine and it's not working great with dashes.
Try: "HLD-X9" ! -> No posts were found because the word hld-x9 is not contained in any post.
The work-around is to use . (dot) instead of - (dash), I found that on a phpBB3 forum somewhere. I read someone that I can try to switch from phpBB to MySQL search engine for slightly better performances. Will try that after the current mysql/PHP/Debian migration is successful.

For LDDb, I wrote the best search function I could but I'm no search engine engineer and it remains very static with no fuzzy logic or Boolean capability. When looking for a title I usually try a specific work ("creatures" for the Jedi example) or simply type the reference number in the search box. Ideally "jedi creatures" should try *jedi*creatures* and *creatures*jedi* but I need to write a better search engine for that.

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Search ability  Topic is solved
PostPosted: 25 Aug 2015, 06:42 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
admin wrote:
For LDDb, I wrote the best search function I could but I'm no search engine engineer and it remains very static with no fuzzy logic or Boolean capability. When looking for a title I usually try a specific work ("creatures" for the Jedi example) or simply type the reference number in the search box. Ideally "jedi creatures" should try *jedi*creatures* and *creatures*jedi* but I need to write a better search engine for that.


I'm really stupid... The code for fuzzy search (MATCH AGAINST in MySQL) was already written... but never triggered because the search field was over-filtered!

:thumbdown:

I cleaned up some of the search code and probably broke stuff along the way but I will need you to try and play with it.

This is how it works:


Initially -day didn't work, I had to change the minimum word length for words from 4 to 3 letters (below 3 will be discarded) and rebuild the index for Titles.

Could you all play with it a little and tell me how it looks?

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 25 Aug 2015, 06:49 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
hippiedalek wrote:
I tried "return of the jedi creatures" which returns no results. In fact searching for " star wars return of the jedi classic creatures" returns no results despite the search term including all of the words of the laserdisc title except for the colons.


=> Starting from today, this will work!

http://www.lddb.com/search.php?search=return+of+the+jedi+creatures&sort=title

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 25 Aug 2015, 17:31 
Hardcore fan
Hardcore fan
User avatar

Joined: 20 Feb 2011, 19:23
Posts: 1033
Location: United Kingdom
Has thanked: 30 times
Been thanked: 26 times
The above searches now work! Thanks for the fixes, Julien, great work as always :)
_________________
Pioneer DVL-919E, Onkyo TX-NR626, LG C8 OLED.
My Collection
Offline
 Profile  
 
 Post subject: Re: Search ability
PostPosted: 12 Jan 2018, 06:15 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 4540
Location: Tokyo
Has thanked: 292 times
Been thanked: 1136 times
rein-o wrote:
I was talking about just searching for LDs under the database.


Fair point.

I'm trying to address this here:

Playing a little with quick search auto-complete with ajax

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
LDD-1 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 12 posts ] 


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: