I bought a new HP 6500 Wireless with WiFi and Ehternet. The installation went smooth, but when I wanted to add it to other computers in my home network no computer could see the printer. At least I did not know how to configure them to see the new network printer. Using "Browse" or "network" options in "Add printer" dialog did not find the HP 6500 device.
This guide show how to configure a MS Windows computer:
http://uis.georgetown.edu/software/documentation/winxp/winxp.network.printer.html
Saturday, January 23, 2010
Friday, January 08, 2010
MySQL FULLTEXT search and stopwords
If you are trying too look for a word like 'yours' in the TEXT MySQL field you will never get any result. This is because 'yours' is one of the 'stopwords' ignored in the MySQL searches.
Here is the list of all such stopwords
The bad thing is that this behavior does not change even if you search in BOOLEAN mode. This note describes this as a requested fix for some later MySQL release.
Anyway, if you want to search for just ANY word, without taking in consideration the 'stopwords' list of MySQL, add this line
in [mysqld] section of your my.cnf file (for XAMPP on Win xamp-folder/mysql/bin/my - no extension)
Next:
a) restart mysql daemon / service
b) rebuild tables indexes, e.g. by the following SQL comand:
Now you can search for words like "can", "me" and "you" and - what a surprise! - find the records containing them.
Here is the list of all such stopwords
The bad thing is that this behavior does not change even if you search in BOOLEAN mode. This note describes this as a requested fix for some later MySQL release.
Anyway, if you want to search for just ANY word, without taking in consideration the 'stopwords' list of MySQL, add this line
ft_stopword_file=""
Next:
a) restart mysql daemon / service
b) rebuild tables indexes, e.g. by the following SQL comand:
REPAIR TABLE `Texts` QUICK
Now you can search for words like "can", "me" and "you" and - what a surprise! - find the records containing them.
Subscribe to:
Posts (Atom)