LiewCF.com

I am a Flickr Pro user for years and uploaded over 700 photos to Flickr. On the other hand, I have made many friends on Facebook.

Now, how do I share my Flickr photos with my Facebook friends without having to upload the photos again?

Flickr2Facebook Uploader

Flickr2Facebook is an unofficial Flickr to Facebook uploader(bookmarklet) which allows you upload photos to Facebook from Flickr.

1. Visit Flickr2Facebook site, login Flickr to allow Flickr2Facebook access your Flickr account.
2. Save the Flickr2Facebook bookmarklet to your web browser bookmark(do this once).
3. Goto your Flickr photo page that you would like to upload to Facebook, and click the Flickr2Facebook bookmarklet in your web browser bookmark.
4. Click on the Flickr2Facebook logo that appears over your Flickr photo. You will be asked to choose the Facebook photo album you would like to upload into (thus, you need to create photo album first) and the Flickr photo will be uploaded to selected Facebook photo album. It’s fast!
5. Back to the Facebook photo album to approve the newly uploaded photos.

View my Facebook photo albums.

(Continued…)

Yahoo Messenger is one of the most popular instant messengers of today. When you download Yahoo! Messenger(YM), you actually only download a small size installer which will download the full size Yahoo Messenger when it is loaded.

But, the YM installer restarts the installation when your line is unstable or the YM download site is busy. It is rather irritating. I once spent 30 minutes to see it keeps restarting the installation!

Here is the solution! We can skip the small YM installer and directly download the full Yahoo! Messenger standalone installer.

Here are the download links for YM standalone installer:

• Yahoo! Messenger 8.1 full standalone installer
• Yahoo! Messenger 9 BETA standalone installer

Hopefully this tip will solve your problem. It is useful too when you need to install YM on multiple computers. BTW, my YM id is liewcf1980

It is quite common that mod_security is interfering the functions of your web applications. mod_security is installed and enabled by your web server admin but you can still disable it for your individual website using .htaccess file by following this tutorial.

“mod_security is an Apache module (for Apache 1 and 2) that provides intrusion detection and prevention for web applications.” — HowtoForge

Disable mod_security in .htaccess file

1. If you do not have one yet, an .htaccess file in the folder of your web application
2. To disable mod_security COMPLETELY, add the following line to the .htaccess file:
   SecFilterEngine Off
   OR, to disable HTTP POST scanning only, use the following instead:
   SecFilterScanPOST Off
3. Save the file and test your web application to check whether disabling mod_security has solved your problem.

I recommend you to try SecFilterScanPOST Off first, instead of disabling mod_security completely.

(Continued…)

I have a community site powered by Drupal but it cannot display chinese characters, even though it supports unicode by default.

All non-English characters are displayed as question marks (???). I tried to reinstall Drupal but without any luck. Yesterday, I finally discovered the problem and solved it!

The problem

Last time, I installed Drupal using the cPanel Fantastico script installer. The installer created database using Latin collation. That’s why Drupal cannot display Chinese characters because the database is not unicode (UTF-8).

Lesson learned: Do not install script using cPanel Fantastico.

The solution

The solution is simple, correct the tables’ collation to UTF-8 using the following SQL query (thanks to neo_fox):

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

I ran the query using phpMyAdmin found in cPanel hosting control panel. But the drawback is that you need to run the SQL query for every single table…

I modified 20+ tables and it works! Now my friends can leave chinese message on the community website.

Google has released a free tool called Google Calendar Sync for users to sync between their Microsoft Outlook calendar and Google Calendar. No more missing meeting when you have no access to office PC.

The windows only tool that allows you to sync events between Google Calendar and Microsoft Outlook Calendar. You can choose the sync direction and the frequency.

The main advantage of sync between calendar is that you can access your calendar events anytime anywhere on Google Calendar (as long as you have Internet access). The new events you added on Google Calendar when you are not in office will be added to office PC’s Microsoft Outlook Calendar after sync.

How to use Google Calendar Sync?

1. Download Google Calendar Sync (windows only)
2. Install the tool.
3. Configure the Google Calendar Sync’s settings

Google Calendar Sync will stay in your Windows System Tray, and automatically sync your calendar on sync time interval. You can also right-click on the calendar icon to sync manually or access Google Calendar Sync Settings window.

Have you tried Google Calendar Sync? What do you think?