Upgrading CiviCRM on an installation with MySQL binary logging enabled

[nickholden]

I hit an error this morning trying to upgrade CiviCRM from 4.2.1 to 4.2.4. The error is reported by MySQL as "You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)" - it was a simple job to turn off binary logging on my testbed system, run the upgrade again, and then turn binary logging back on, but I guess some people may have problems doing that, either because they're on shared database hosting or because their production site mandates binary logging for some reason.

Either way, it might be good if the upgrade documentation made reference to this being an issue.

Nick

[Error: Upgrade DB to 4.2.2: SQL]
Error Field   Error Value
Type   DB_Error
Code   -1
Message   DB Error: unknown error
Mode   16
UserInfo   DROP TRIGGER IF EXISTS civicrm_acl_before_insert [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
DebugInfo   DROP TRIGGER IF EXISTS civicrm_acl_before_insert [nativecode=1419 ** You do not have the SUPER privilege and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)]
PEAR_Exception: DB Error: unknown error in unknown on line unknown
- DB_Error: DB Error: unknown error in unknown on line unknown