Archive for January, 2010
My Garmin Forerunner 305 doesn’t power on – It’s just DEAD! The Solutions.
Monday, January 18, 2010 14:51 19 CommentsIf you experienced the same problem as I did and your Garmin Forerunner 305 just doesn’t turn on then try one of the steps i describe below to bring it back to life. Beside not responding to any buttons the computer doesnt recognize it either when connected through the USB interface.
I’ll present you with a [...]
Wordpress – Weird characters after wordpress upgrade
Saturday, January 16, 2010 23:02 No CommentsIf you see weird characters after upgrading your wordpress version, the reason for that might be wrong character encodings.
1. Easy solution:
- open wp-config.php for edit.
- make sure you have empty values for define(’DB_CHARSET’, ”); and define(‘DB_COLLATE’, ”);
2. Convert all tables to UTF-8
- follow these steps. not tested yet!
MYSQL – Disabling FULLTEXT Search stopwords
Friday, January 15, 2010 0:38 No CommentsTo disable MySQL FULLTEXT Search stopwords open the mysql config file and below [mysqld] add the following line:
ft_stopword_file = “”
By setting the ft_stopword_file value to an empty string the usual stopwords won’t be ignored any more.
Here is what the manual says about setting a new stopwords file:
To override the default stopword list, set the ft_stopword_file [...]
MySQL – How to change the FULLTEXT SEARCH 4 character minimum behaviour
Thursday, January 14, 2010 23:56 No CommentsBy default the FULLTEXT minimum characters behaviour is set to 4 characters. To check what value is preset on your server type the following query:
SHOW VARIABLES LIKE ‘ft%’;
That shoud bring up a result similar to this:
Variable_name
Value
ft_boolean_syntax
+ -><()~*:””&|
ft_max_word_len
84
ft_min_word_len
4
ft_query_expansion_limit
20
ft_stopword_file
(built-in)
To change the ftp_min_word_len you have to edit the my.ini configuration file.
Below [mysqld] add this line to decrease the [...]