Archive for January, 2010

My Garmin Forerunner 305 doesn’t power on – It’s just DEAD! The Solutions.

Monday, January 18, 2010 14:51 42 Comments

If 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 [...]

This was posted under category: Sports Tags: , , , , , , , , , , , , , , , , ,

WordPress – Weird characters after wordpress upgrade

Saturday, January 16, 2010 23:02 No Comments

If 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!

This was posted under category: Wordpress Tags: , , , , , , , , , , , , ,

MYSQL – Disabling FULLTEXT Search stopwords

Friday, January 15, 2010 0:38 1 Comment

To 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 [...]

This was posted under category: Database Tags: , , , , ,

MySQL – How to change the FULLTEXT SEARCH 4 character minimum behaviour

Thursday, January 14, 2010 23:56 No Comments

By 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 [...]

This was posted under category: Database Tags: , , , , , , , ,