Comment 9 for bug 1081947

I've created a couple of patches - the first addresses the problem where if a site was first created with version 1.0 or earlier there were missing keys on some fields. The patch checks on upgrade if the keys exist and if not adds them
https://reviews.mahara.org/#/c/2744/

The second patch addresses a couple of places where CAST() is used for mysql sql queries.
https://reviews.mahara.org/#/c/2748/

If someone has a large mysql site can they check that patch 2 does
 A) work - eg one still gets the same results when using it as they do when it is not in place, and
 B) that it makes for faster db calls

Cheers

Robert