| Author |
Message |
Slow 1200
Samba Member
Joined: July 02, 2004
Posts: 2105
|
 Posted: Mon Mar 20, 2017 8:58 am Post subject: Classified search |
 |
|
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 
it wasn't like that not long ago, did the search just change? |
|
| Back to top |
|
 |
EverettB 
Administrator
Joined: April 11, 2000
Posts: 69798
Location: Phoenix Metro
|
| Posted: Mon Mar 20, 2017 4:25 pm Post subject: Re: Classified search |
|
|
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 |
|
|
Slow 1200
Samba Member
Joined: July 02, 2004
Posts: 2105
|
| Posted: Fri Jun 23, 2017 3:39 am Post subject: Re: Classified search |
|
|
did the classified search break?  |
|
| Back to top |
|
|
oddengineer
Samba Member
Joined: August 21, 2006
Posts: 112
|
| Posted: Fri Jun 23, 2017 7:10 am Post subject: Re: Classified search |
|
|
| that's what im wondering too im getting it in both the classifieds and the forums section |
|
| Back to top |
|
|
bbrowncods
Samba Member
Joined: December 27, 2014
Posts: 58
Location: Virginia
|
| Posted: Fri Jun 23, 2017 7:12 am Post subject: Re: Classified search |
|
|
| Search not working "General Error". |
|
| Back to top |
|
|
EverettB
Administrator
Joined: April 11, 2000
Posts: 69798
Location: Phoenix Metro
|
|
| Back to top |
|
|
heimlich
VWNOS.com
Joined: November 20, 2016
Posts: 6588
Location: Houston, Texas
|
| Posted: Fri Jun 23, 2017 10:47 pm Post subject: Re: Classified search |
|
|
| 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 |
|
|
EverettB
Administrator
Joined: April 11, 2000
Posts: 69798
Location: Phoenix Metro
|
| Posted: Fri Jun 23, 2017 11:09 pm Post subject: Re: Classified search |
|
|
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 |
|
|
heimlich
VWNOS.com
Joined: November 20, 2016
Posts: 6588
Location: Houston, Texas
|
| Posted: Sat Jun 24, 2017 8:43 am Post subject: Re: Classified search |
|
|
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 |
|
|
|
