Sunday, 24 August 2014

how to disable hover track changes tooltips in apple pages

how to disable hover track changes tooltips in apple pages

The symptom is you have change tracking enabled and whenever you stop your mouse movement for a few seconds, a tooltip appears blocking the text so you can’t read or edit.





(e.g. using sudo vi)


/Applications/iWork\ \'09/

change the key SFTDefaultShowTooltip from true to false:

search using 









To edit or make a change, cursor to the word "true" and press the X key four times... then press i to insert, type "false", press esc key, then :wq!


I don’t know if the following works, but it returns no error and makes no change: … please email me if you find a way to make this method work.

defaults write

SFTDefaultsShowTooltip -bool false

Saturday, 23 August 2014

etymology of ravens and crows

It just occurred to me that raven and crow are the same word.


Grimm’s law allows h <-> k/c/g between Latin and Germanic; here are some examples:

heart -> card (cardiac)  (h -> c)

garden (yard) -> hortis (horticulture) (g -> h)

hundred -> cent (century) (h -> c)

Examples of lenition (softening) of gutturals or stops in Germanic occurs in similar examples:

Ich (German)

Ik (Dutch)

Ek (Afrikaans)

Ic (Old English)

I (modern English)


Take old English Hraefn or Norse Hravn for Raven. Icelandic pronounces Hr as Kr. Similarly, assuming the H was pronounced and gradually lenited till it disappeared in modern English, we have Kravn -> Raven

But look.

Latin has Corvinus for Crow. (Crvn) Compare this now to the Kravn above.

Yet the Grimm’s law h->k/c shows that Corvin -> Horvin or Hrovin.

Crow and Raven are the same word from presumably a proto Indo European *Korvin or similar.

Now, how is Crow the same as Latin Corvinus? This is easy. Swapping letters around is commonplace; think of “third” vs “three”, or German “Durch” vs English “Through” (OE: Thurh). Thurh in Old English in particular gives three change examples: D in German to Th in English; UR/RU swap; and lenition of the guttural German CH to H in English. So… take Crow in English. W/V/U are interchangeable across Europe under Grimm’s law… (remember: V is actually just latin U, and W is called “double u," not "double vee")… so we get Crov. Then swap OR/RO like in Through/Durch or Three/Third… (OE: Thri; Thrid)… result: Corv; the Latin stem.

Sunday, 3 August 2014

mysql 5.0-5.6 upgrade error

InnoDB: Recalculation of persistent statistics requested for table "roundcubemail"."session" but the required persistent statistics storage is not present or is corrupted. Using transient stats instead"


between 5.0/5.1 and 5.5/5.6 they did some major re-working of the internal structure of the mysql main database. 


run commands to verify and then restart it in a safe mode.

so pretty much service mysqld stop, mysqld_safe, service mysqld stop, service mysqld start


ERROR 2049 (HY000): Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

This will happen usually when you upgrade from 5.0/5.1 to 5.5 or higher.

So, first thing, shutdown mysql:

shell> service mysqld stop

Then, check if the files / folders in your mysql directory have been changed to own by root, this happened with us.

shell> chown -R mysql.mysql /var/lib/mysql

Then restart and tell it to not worry about privileges / permissions:

shell> sudo mysqld --skip-grant-tables &

You will then be able to login without a username / password:

shell> mysql

mysql> UPDATE mysql.user SET Password=PASSWORD(’NEW_PASSWORD') where User='root’;


Stop Mysql and start it up again normally (not with the skip-grant tables)
shell> service mysqld stop

shell>sudo service mysqld start

Your new password should now work.

Then, run the command:

shell> mysql_upgrade -u root -p

this will check your tables and fix most problems, watch the output and make sure all is okay.