Solution: WhatsApp crashes on iOS 8 Beta

WhatsApp Logo
Last week, I finally decided to upgrade my iPhone 5 to iOS 8 Beta 4. When the iOS Beta 1 was available, I took the risk to have it installed. But, it was too disappointing for too many bugs and errors. I’m excited about the upcoming iOS 8 features, and I want to try some of the features. There is a discussion thread at MacRumors Forum which lists the application compatibility on iOS 8. Anyway, I have lots of apps installed right now. If you’re not sure about having the iOS Beta, you can wait for the official release.
I have some applications that are not running well, and one of them was WhatsApp. It keeps crashing. I can accept the fact that some other applications are broken or crashed. But, WhatsApp is an app that I use on daily basis. After searching for solutions, there are two popular ways to fix this issue:

I chose the second option, because it’s pretty straight forward. Big thanks to Ritvij Pathak’s The Tech Portal. So, what was the problem? Quoting from the site:

The main reason for the crashes is typographic ligature. For those of you who didn’t get what it is, don’t fret, we didn’t either. Turns out it has something to do with two letters being read as one syllable. Ex: letter combos like ff, fi, ffi, fii, will make WhatsApp crash.

What I found was that WhatsApp crashed when I typed some words or there are some words that are already in the database file. So, I followed the instructions and had everything solved. I want to reproduce the solution based on my experience.
I need to download two applications: iExplorer and Navicat for SQLite. Both are paid applications but the trial version are available. After I had it installed, these are steps I did. Anyway, WhatsApp iCloud setting should be turned off.
Open iExplorer — your iPhone should be connected, of course — and navigate to Apps > WhatsApp > Documents. Export the ChatStorage.sqlite file by right-clicking on the file and choose the export destination of your choice. You will need this file later. Having the backup for this file is advisable. So, after exporting this file, duplicating this file won’t hurt.
iex-1972401972491724
Open Navicat for SQLite and import the ChatStorage.sqlite from the previous step. Navigate to Query and add a new query. Paste the query below, and Run it.

update ZWAMESSAGE
set ZTEXT = replace( ZTEXT, 'ff', 'f f')
where ZWAMESSAGE.ZTEXT like '%ff%';
update ZWAMESSAGE
set ZTEXT = replace( ZTEXT, 'fi', 'f i')
where ZWAMESSAGE.ZTEXT like '%fi%';
update ZWAMESSAGE
set ZTEXT = replace( ZTEXT, 'fl', 'f l')
where ZWAMESSAGE.ZTEXT like '%fl%';
CREATE TRIGGER insert_Ff AFTER INSERT ON ZWAMESSAGE
BEGIN
  UPDATE ZWAMESSAGE
  SET ZTEXT = replace( ZTEXT, 'ff', 'f f')
  WHERE ZWAMESSAGE.ZTEXT like '%ff%';
END;
CREATE TRIGGER insert_Fi AFTER INSERT ON ZWAMESSAGE
BEGIN
  UPDATE ZWAMESSAGE
  SET ZTEXT = replace( ZTEXT, 'fi', 'f i')
  WHERE ZWAMESSAGE.ZTEXT like '%fi%';
END;
CREATE TRIGGER insert_Fl AFTER INSERT ON ZWAMESSAGE
BEGIN
  UPDATE ZWAMESSAGE
  SET ZTEXT = replace( ZTEXT, 'fl', 'f l')
  WHERE ZWAMESSAGE.ZTEXT like '%fl%';
END;

Your ChatStorage.sqlite has been updated. The next thing you need to do is bring the file back to the iPhone using iExplorer. Move it to the same place and if you’re asked to replace the file, just replace the file.
My previous errors with WhatsApp was fixed immediately. But, it seems that the errors still occur under different situation. The most common problem is that WhatsApp still keep crashing when I type some words in the window. For now, the temporary solution works, and let’s wait the official update from WhatsApp team. I’m sure they will fix it once iOS 8 is available.

Flickr for iPhone: Timestamp problem?

I am not sure when this kind of problem appeared for the first time. Not exactly a big problem, but something that does not work well. I’m now using Flickr for iPhone Version 1.4.2 on iPhone 4 (Software Version: 4.3.5), and so far the primary feature — I consider photo upload feature as primary feature here — works well. At least, it helps me a lot to upload photos taken using my iPhone directly to Flickr.
I know, there are some other methods that I use like transferring photos using Image Capture or iPhoto to my laptop and upload them using Flickr Uploadr. I almost never use Email-to-Flickr feature.
Okey, back to the problem.
When I go to “Activity” tab, I see that there are some activities on uploaded photos (new comments, favorited, and added to gallery by other users). But, there is a single activity that should not be there. The latest activity should be on the top — and I think this is what Flickr (for iPhone) exactly want to have. You can see “655 days ago” there. It is a valid activity, and I’ve checked from the web browser.
So, I tweeted about this small issue. I’m not sure how many other Flickr users out there who have the same issue. Karen Yeo (Hi Karen!) came with an idea to re-authorize the application. I did it, but I think I need to be more patient to have it fixed. Is it an issue on the application? Not sure.
I’ll wait.
Update: Oct 13, 2011 04:56 PM (GMT+7)

I’m still curious. I’m now with iOS 5 now. So, I just tried a different approach to see how whether it solved the problem or not.
I logged in using my other account and liked my own photo to see whether the “old activity” disappeared or not — considering that they’re displayed by date/time. It didn’t.

So, what is the best Twitter Client?

Not exactly a Twitter client, but tool to manage social media accounts like Twitter, Facebook, LinkedIn, Google+ and more.
When I created my first Twitter account in 2006, there weren’t any applications for desktop or mobile. But, it’s 2011 and the service grows so fast. It’s around one billion tweets sent per week (according to March 2011 data). I love Twitter, and I also joined some other services. I don’t use all of them on daily basis, but more about learning how the service works, and how they’are designed. This is something I consider as something-I-like-to-do.
We are connected to each other using social media services. Many people want to be in the front row to get the latest news. They also want to know what is the latest information in the industry they’re involving with. I want to get the news shared by people I’m following on Twitter, or just to see what’s happening from my timeline.
At the same time, I want to share updates. These things seemed easy to be done. But, when it’s involving multiple social media accounts, I can be very busy. Not always, but sometime.
I have been trying and have some application installed on my gadgets — and also my MacBook Pro. I’m having Nokia N8, BlackBerry, and iPhone 4 now. Okey, don’t ask me why I need to have those gadgets. I just have them and don’t use them at the same time. But, I usually switch between those gadget — and of course, applications installed.
The thing is that not all applications works on every device I have with me, even they share similar features. Among many applications (free or paid) to manage my social media account. And these are some applications (including Twitter clients) I use — I switch between applications when I’m on my iPhone as my primary device right now.

I don’t have iPad and Android-based devices anyway. So, why bother having (too) many applications when I don’t use them all? Again, I like exploring how those things work. And, I like working on my account using its native application. For example like using Facebook for iPhone to explore Facebook, even HootSuite also works fine. Why? Switching between application is easy. Right?
I don’t have any other applications like TweetDeck, or Twitter for Mac on my Mac. For the web-based tool I sometime use HootSuite, CoTweet and Twitter website.
For the next post, I think I’ll write short reviews about those applications. From a end-user perspective. There are many tools/services that offer so many features. Probably, they works for businesses, not for personal use. Some are paid service, and some are free. When it comes into a simple question: “What is the best Twitter client?”, the answer should be simple: A client that works for you. Right?

Tumbleweed: Tumblr Desktop Client

Tumblweed Screenshot
After I decided to start a tumblelog (again), the first thing I did was finding a desktop client. For now, Tumblr does not support XML-RPC protocol, but they do have API.
I’m not familiar with API, so I searched for solution. Luckily, I found Tumbleweed. Login using Tumblr account, and you can start writing. If you have web camera, you can also capture using it, and post it as photo. What I like from Tumblweed:

  • The interface is clean, easy to understand.
  • Support multiple tumble format — of course!
  • It also support tags and timestamp modification
  • Support multiple tumblelogs from Tumblr, using Tumblr domain or custom domain.

But, there are some limitations (it’s more about my personal preferences):

  • When writing a “Quote”, there is no textarea to write the description. It’s only an “input” type.
  • Entry history. If you have many contents, you only see your last 20 entries.
  • Inline editing. All posted contents can’t be edited from the interface.

Those features seems not available for now — based on my observation. But, I’m fine with that since this is the best Tumblr desktop client I found so far. If you have any recommendation, please share.
Anyway, if you want to install Tumblweed, you need to have Adobe AIR installed first.

WordPress Apps for LinkedIn

We can add WordPress application for LinkedIn now.

With the WordPress App, you can sync your WordPress blog posts with your LinkedIn profile, keeping everyone you know in the know. Once added, you can filter your posts with a special LinkedIn tag and even display your personal WordPress Gravatar (global avatar). Updates are automatically sent to your network for instant notifications and gratification. (WordPress Apps details)

This application is available for both WordPress.com and self-hosted WordPress.