AR banner
Please use the Submit a ticket facility as this provides us automatic tracking of all your emails.
'Search help' below ONLY searches items within the Helpdesk. Use the Search icon in Menu Bar to perform a Search across the entire site if necessary.

REPLIES WILL COME FROM [email protected] CHECK YOUR JUNK FOLDER IF YOU DO NOT GET OUR REPLY.

Knowledgebase
Aircrew Remembered > Aircrew Remembered Help Desk and FAQ > Knowledgebase

Search help:


Cannot find the name 'Down' in a database

Solution

Search Tips are found here.

Our database software utilizes MySQL on our host servers. It is the most widely used database software in the world. It's fast and very reliable.

All MySQL searches you make pass through what is known as a Stopword List, essentially a list of words MySQL does not recognize, it just ignores them. These are generally programmer-centric (or unimportant words such as 'the') and the reason they are on the Stopword List is related to performance efficiency and database security. If you try to Search on any word in the Stopword List, your search will fail. Therefore if the name you are looking for just happens to be the same as a word in the Stopword List, it will actually be in the database but a Search will not find it. The name WILL be in the Names List (found via the Names List button which is found on every database: the purpose of which is to show all the names in this particular database, so you can check the spelling) but you won't be able to Search for it. You can see the Stopword List here.

Unfortunately the Stopword List used by our hosting service includes at least 6 words which can also occur as valid names (there may be others in the Stopword List which can also be valid names, but we haven't noticed any being used in our databases). To overcome this problem, we have changed the relevant names in the database so you can find them.

If you search for the name 'Down' use 'Downe' instead

If you search for the name 'Else' use 'Elsee' instead

If you search for the name 'Just' use 'Juste' instead

If you search for the name 'Little' use 'Littlee' instead

If you search for the name 'Much' use 'Muche' instead

If you search for the name 'New' use 'Newe' instead


Where we have made such changes, we have noted this in the database entry itself so there is no room for confusion as to what the correct name really is.

If you find a Name in the Names List that doesn't show up when you make a Search, let us know via the Helpdesk and we will perform a manual Search for you and make the necessary adjustments to the database.

 
Was this article helpful? yes / no
Related articles Can't find name 'Just' in database
Can't find name 'Much' in database
Can't find name 'New' in database
Cannot find the name 'Else' in a database
Cannot find the name 'Little' in a database
Article details
Article ID: 134
Category: Knowledgebase
Date added: 2017-05-25 15:03:56
Views: 916
Rating (Votes): Article rated 3.3/5.0 (14)

 
« Go back

© 2012 - 2024 Aircrew Remembered - All site material (except as noted elsewhere) is owned or managed by Aircrew Remembered
and should not be used without prior permission.