Hello! Log in or Register   |  Help  |  Donate  |  Buy Shirts  See all banner ads | Advertise on TheSamba.com  
TheSamba.com
 
Classified search
Forum Index -> Site Share: Facebook Twitter
Reply to topic
Print View
Quick sort: Show newest posts on top | Show oldest posts on top View previous topic :: View next topic  
Author Message
Slow 1200
Samba Member


Joined: July 02, 2004
Posts: 1557

Slow 1200 is offline 

PostPosted: Mon Mar 20, 2017 8:58 am    Post subject: Classified search Reply with quote

I just typed "ported" in the ad search, restricting to title only, and I also get all the ads with the word "port", which means I get about 5 billion non-relevant ads Laughing

it wasn't like that not long ago, did the search just change?
Back to top
View user's profile Send private message Gallery Classifieds Feedback
EverettB Premium Member
Administrator


Joined: April 11, 2000
Posts: 55592
Location: Phoenix, AZ
EverettB is offline 

PostPosted: Mon Mar 20, 2017 4:25 pm    Post subject: Re: Classified search Reply with quote

Yes, I recently changed it so it would find any "plurals" automatically.
Example: If you search on door it will pull up ads with doors too.

Apparently it thinks ported is a variation of port

You can override this by selecting the "exact phrase" selection from the search type box.
This assumes you are searching only on ported, otherwise there may be an issue if you are using more than 1 word for the exact match as it will try to find the exact phrase instead.

If you have any other examples of things that no longer work as expected, feel free to post.

For anyone:
If anyone else finds any issues, let me know.
_________________
How to Post Photos
Everett Barnes - [email protected] | My wanted ads
"Water is the only drink for a wise man" | "Communication prevents complaints"
Stop dead photo links! Post your photos to The Samba Gallery!
Back to top
View user's profile Send private message Send e-mail Visit poster's website Facebook Instagram Gallery Classifieds Feedback
Slow 1200
Samba Member


Joined: July 02, 2004
Posts: 1557

Slow 1200 is offline 

PostPosted: Fri Jun 23, 2017 3:39 am    Post subject: Re: Classified search Reply with quote

did the classified search break? Popcorn
Back to top
View user's profile Send private message Gallery Classifieds Feedback
oddengineer
Samba Member


Joined: August 21, 2006
Posts: 70

oddengineer is offline 

PostPosted: Fri Jun 23, 2017 7:10 am    Post subject: Re: Classified search Reply with quote

that's what im wondering too im getting it in both the classifieds and the forums section
Back to top
View user's profile Send private message Gallery Classifieds Feedback
bbrowncods
Samba Member


Joined: December 27, 2014
Posts: 36
Location: Virginia
bbrowncods is offline 

PostPosted: Fri Jun 23, 2017 7:12 am    Post subject: Re: Classified search Reply with quote

Search not working "General Error".
Back to top
View user's profile Send private message Gallery Classifieds Feedback
EverettB Premium Member
Administrator


Joined: April 11, 2000
Posts: 55592
Location: Phoenix, AZ
EverettB is offline 

PostPosted: Fri Jun 23, 2017 7:46 am    Post subject: Re: Classified search Reply with quote

Thanks for the heads up - it is fixed now.
_________________
How to Post Photos
Everett Barnes - [email protected] | My wanted ads
"Water is the only drink for a wise man" | "Communication prevents complaints"
Stop dead photo links! Post your photos to The Samba Gallery!
Back to top
View user's profile Send private message Send e-mail Visit poster's website Facebook Instagram Gallery Classifieds Feedback
kawfee Premium Member
Samba Member


Joined: November 20, 2016
Posts: 1821
Location: Houston, Texas
kawfee is offline 

PostPosted: Fri Jun 23, 2017 10:47 pm    Post subject: Re: Classified search Reply with quote

Just wondering what kind of database you are using on the backend to search. If you have something such as SQL Server you could map the search term into a regular expression. This would also allow the flexibility to search for wildcards anywhere in the text. You would probably want to limit these types of searches to indexed fields.
Back to top
View user's profile Send private message Visit poster's website Gallery Classifieds Feedback
EverettB Premium Member
Administrator


Joined: April 11, 2000
Posts: 55592
Location: Phoenix, AZ
EverettB is offline 

PostPosted: Fri Jun 23, 2017 11:09 pm    Post subject: Re: Classified search Reply with quote

It's mySQL but the search indexing is a separate indexing program that is more efficient.

Quote:
you could map the search term into a regular expression. This would also allow the flexibility to search for wildcards anywhere in the text

No, this is too intensive with the tables in use here, searches would take forever and the site would crash. It used to work this way years ago when the database was small, until it became an issue.

Indexing:
The classifieds text could be indexed with a FULL TEXT type field and was in the past but the separate program that is in use now is more efficient.
_________________
How to Post Photos
Everett Barnes - [email protected] | My wanted ads
"Water is the only drink for a wise man" | "Communication prevents complaints"
Stop dead photo links! Post your photos to The Samba Gallery!
Back to top
View user's profile Send private message Send e-mail Visit poster's website Facebook Instagram Gallery Classifieds Feedback
kawfee Premium Member
Samba Member


Joined: November 20, 2016
Posts: 1821
Location: Houston, Texas
kawfee is offline 

PostPosted: Sat Jun 24, 2017 8:43 am    Post subject: Re: Classified search Reply with quote

The searching is very fast. I have been pleased with it.

I can see you are very technical. I suppose you have to be running your own site.

There are other ways but I suppose you have to balance your resources. More people should buy premium memberships!
Back to top
View user's profile Send private message Visit poster's website Gallery Classifieds Feedback
Display posts from previous:   
Reply to topic    Forum Index -> Site All times are Mountain Standard Time/Pacific Daylight Savings Time
Page 1 of 1

 
Jump to:  
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 vote in polls in this forum

About | Help! | Advertise | Donate | Premium Membership | Privacy/Terms of Use | Contact Us | Site Map
Copyright © 1996-2016, Everett Barnes. All Rights Reserved.
Not affiliated with or sponsored by Volkswagen of America | Forum powered by phpBB