Hi Keith, I tried searching for 'oil pump' in the Pre-war section and this came up:-
Information
The following words in your search query were ignored because they are too common words: pump oil.
You must specify at least one word to search for. Each word must consist of at least 3 characters and must not contain more than 14 characters excluding wildcards
The same happened when I tried 'brakes'
Tony.
Pre war section search facility
-
Tony Fearn
- Posts: 1743
- Joined: Thu Feb 09, 2006 5:33 pm
- Your interest in the forum: Early pre-wars. Owner of 1933 'Flying Fox' 'Sarah Jane, and 1934 Short saloon 'Mary Ellen'.
- Given Name: Anthony
- Location: Clayton le Moors, Lancashire, the Premier County in the British Isles!!
-
Keith Clements
- websitedesign
- Posts: 3968
- Joined: Wed Feb 08, 2006 11:22 am
- Your interest in the forum: Jup NKD 258, the most widely travelled , raced and rallied Jowett.
- Given Name: Keith
- Contact:
Re: Pre war section search facility
Try
+oil* +pump*
or
+brak*
or +br*ke
Sorry it is not as good as Google. The question is whether I open up the Forum to search engines!
The forum is stored in a database (MySQL) that does have better search facilities, but PHPBB (on which this forum is based) uses (I think) a much older technique where it creates its own list of words in topics and stores these in the database. This is because the database engine did not have the freeform search capability when PHPBB was first written.
+oil* +pump*
or
+brak*
or +br*ke
Sorry it is not as good as Google. The question is whether I open up the Forum to search engines!
The forum is stored in a database (MySQL) that does have better search facilities, but PHPBB (on which this forum is based) uses (I think) a much older technique where it creates its own list of words in topics and stores these in the database. This is because the database engine did not have the freeform search capability when PHPBB was first written.
skype = keithaclements ;
-
Forumadmin
- Site Admin
- Posts: 20648
- Joined: Tue Feb 07, 2006 5:18 pm
- Your interest in the forum: Not a lot!
- Given Name: Forum
Re: Pre war section search facility
I have done some research on the searching issue and am considering using the database search facility rather than the native php facility as this should be quicker.
Also i am looking at modding the system to allow 3 character word and phrase searches.
The text below is fo my memory when i get around to it!!!
Also i am looking at modding the system to allow 3 character word and phrase searches.
The text below is fo my memory when i get around to it!!!
MySQL fulltext search for 3 char words
If you are familiar with full text searching in MySQL, you will be surprised to know that MySQL doesn’t index words containing 3 or less characters by default. Searching such words ends up with no result. I am sure sometime you also suffered from the same problem. If you are not familiar with this default behavior of MySQL you may spend hours after hours trying to find out what went wrong. Well, here is the solution for you
There is a system option named “ft_min_word_len” by which you can define the minimum length of words to be indexed. You need to set value to this configuration directive in your MySQL configuration file which is found under “/etc/mysql” or “/etc”. In windows you can look under windows directory or MySQL home folder. You need to set this value under [mysqld] section.
[mysqld]
ft_min_word_len=3
There is also a handy method if you don’t want to change in your configuration file. Just start your mysql daemon with the following command
mysqld --ft_min_word_len=3
You may also need to rebuild your index.
Now you can search words with 3 characters in your full text queries
