Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
How did you get it to work? The code of the guy above, where you have to do it manually every time, works perfectly, but the "better" code doesn't seem to work for me... :confused:

I`m also from germany ;)

Sorry just saw this after I posted. The step by step guide I just did is pretty much baby steps but it sounds like you are already their just falling at the last hurdle.
You basically just do what ever you did to run zigmob's code but with the code from https://gist.github.com/jonathan-wheeler/0f8235f5904365e3c75a instead. Are you getting any error messages or does it just have no effect? Im not sure what program or sql console you are using to execute the query's but it seems to work find in navicat.
 
I can say the actual Beta of WhatsApp is working under IOS8

"FF" Bug not present
 
Sorry just saw this after I posted. The step by step guide I just did is pretty much baby steps but it sounds like you are already their just falling at the last hurdle.
You basically just do what ever you did to run zigmob's code but with the code from https://gist.github.com/jonathan-wheeler/0f8235f5904365e3c75a instead. Are you getting any error messages or does it just have no effect? Im not sure what program or sql console you are using to execute the query's but it seems to work find in navicat.

It just doesn't seem to have any effect, but I tested it with iOS 7. Will try with iOS 8 now, to see if it works there. Anyway, thanks for your help.

update:
Awesome! Your fix works "perfectly" with iOS 8. ;) Thanks a lot, dude!!!!
 
Last edited:
For those having endless issues with whatsapp crashing. If you send any word that has a double f in it I.e "off" This will cause the app to crash completely. This is likely the reason group chats are crashing too - logs show dispatch queue error being the main culprit


This has already been covered in previous threads
 
Its actually very simple but if your not comfortable with the steps then I would strongly suggest you don't try it but considering people in this situation are on the beta I assume you at least have a vague understanding of all the processes involved.

1. Turn off icloud documents for whatsapp (Settings> icloud>Documents & Data) and also turn off any funky accessibility settings you might have like zoom or bold as they also cause issues with whatsapp. Turn off wifi and turn on airplane mode(prevents you get new messages during the process) Quit whatsapp and close it fully(double tap home button and swipe it away).

2. Download and install iExplorer (free trial)

3. If you don't have anything that can connect to sqllite databases I'd suggest you go with Navicat for SQLite (free trial). Download and install.

4. Plug in your iphone and open up iExplorer. Click "Apps> WhatsApp> Documents" right click "ChatStorage.sqlite" and export to folder.

5. Go to the location you exported the file to and make a copy of it for a backup. Open the sqlite file in navicat. Click on the connection in the left hand panel and rightclick on the database think its called "main" and select "New Query".

6. A new window should appear, click on the "Query Editor" tab and paste in.
Code:
-- Cleans up existing messages --
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%';

-- Sets up trigger's to re-clean message text when ever new messages are created --
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;

7. Click the Run button and the query will execute. Exit Navicat and copy the sqllitefile back into the Whatsapp directory on your iphone. Whatsapp will still crash when ever you receive a message with these combination but when you reopen it, it should work fine.

Seeing as the issue will probably be fixed by the time iOS8 goes public it is probably best to remove these triggers once its stable. Just repeat the previous steps but run these queries instead.
Code:
DROP TRIGGER insert_Ff;
DROP TRIGGER insert_Fi;
DROP TRIGGER insert_Fl;

thanks!
 
Amazing Bug finding ...

I have found several other strings (without enough in common to have found the thread that connects them) that causes an identical crash. The fi/ff/fl digraphs crashed me as well, but the following (examples all include Emoji characters) were breaking messages as well.

[EXAMPLE 1]
##############

[EXAMPLE 2]
########

[EXAMPLE 3]
⚽⚽⚽⚽⚽################

[EXAMPLE 4]
########

[EXAMPLE 5]
## ##
## ##
## ##
## ## ##

## ## ##
##
## ## ##
##
## ## ##

##
## ##
## ##
## ## ##
## ##
## ##

I'm poking around some more to see if I can find specific connections.
 
Ruled out some things ...

Well, the set of Emoji-featuring messages that was crashing seems to be pretty diverse.

The Spanish and American flags are 2-character combinations (the US flag is �� and ��, where the Spanish flag is �� and �� ). Good fonts turn a sequential pair of those characters that represents a country code (ES or US) into the flag.

But one of the crashing messages didn't have any flags. Only dancing girls. And she's a single-width character ...

They both start with 0xF0 0x9F ... maybe that's related. Time for more testing.

----------

# and # make ES makes the Spanish flag.

# and # make US makes the US flag.

----------

Not related to the 0xF0 0x9F ... I have messages that are just a string of clapping hands (starts with the same sequence) that doesn't crash.
 
Thanks for the guide on setting up the triggers. I just have one recommendation. The first update and trigger for "ff" should be changed to allow for more than two f(s) in a row. Here is my recommendation:

Code:
-- Cleans up existing messages --
update ZWAMESSAGE
set ZTEXT = replace( ZTEXT, '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%';

-- Sets up trigger's to re-clean message text when ever new messages are created --
CREATE TRIGGER insert_Ff AFTER INSERT ON ZWAMESSAGE
BEGIN 
  UPDATE ZWAMESSAGE 
  SET ZTEXT = replace( ZTEXT, '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;
 
Last edited:
i think its a lot more simple to install the latest whatsapp beta. The issue isn't there on that versions and its easy to install :)
 
i think its a lot more simple to install the latest whatsapp beta. The issue isn't there on that versions and its easy to install :)

Can you do this, without being an apple developer?

(Yeah I know, I shouldn't install iOS 8 betas without being a developer... please don't kill me ;) )
 
Can you do this, without being an apple developer?

(Yeah I know, I shouldn't install iOS 8 betas without being a developer... please don't kill me ;) )

Hehe i won't kill you :) but no...
Well.. In theory you can, but you need a developer to add you to his "team" and share his certificate with you. Then you can install and use the beta he signs with his certificate :)
 
Hehe i won't kill you :) but no...
Well.. In theory you can, but you need a developer to add you to his "team" and share his certificate with you. Then you can install and use the beta he signs with his certificate :)

Thanks for that. ;)

hm I guess, I will just wait until they release it to public, which should happen by monday if they are still on schedule to "add Voice calling in q2".
 
i think its a lot more simple to install the latest whatsapp beta. The issue isn't there on that versions and its easy to install :)

hello,

where can I get that beta version? I've searched google but I've come up with no results..

I am a registered developer so I should be able to put it, right?

Thanks!
 
well after lots of what beta releases now i can say its perfect....!! but still facing connectivity problem which makes whatsapp hang for while...!!:)
 
well after lots of what beta releases now i can say its perfect....!! but still facing connectivity problem which makes whatsapp hang for while...!!:)

Hello
Can you please update me how can I have an access for these beta versions?
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.