Hi folks,

Using the 32294 revision from codeplex i'm having an MySQL install issue when trying to do a fresh install at my web hosting (www.web10.dk).

The fresh install worked like a charm when I did it on my local machine.

I think the issue is about privileges in MySQL but I'm not sure.

I've broken the error down to the origin of the first line of the "Total.sql" script is creating a function called ConvertGuid.
CREATE FUNCTION ConvertGuid(guid CHAR(37)) RETURNS CHAR(37) RETURN guid;

When executing this line in "MySQL Query Browser" against my database at my web hosting it gives this error (which conforms to the MySQL Exception from the install):
This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

If I add one of the 'NO SQL', 'READS SQL DATA' or 'DETERMINISTIC' to the function like:
CREATE FUNCTION ConvertGuid(guid CHAR(37)) RETURNS CHAR(37) READS SQL DATA RETURN guid;

It instead gives this error:
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)

I've tried to execute this function on a local db with user privileges only to the specific database (as I excpect the privileges is at my web hosting), and this works fine.

Maybe it has something to do with binary logging instead of privileges?

As far as I can tell binary logging is enabled in MySQL at my web hosting, but not on my local MySQL installation.

I'm quite new to MySQL so if anyone could please confirm if this error is privilege related or not, and maybe give a hint or two?

Best regards
Glenn

Hi Glenn,

Thanks for your research!

Regards,

Ruben

---

Ruben Verborgh | Umbraco Core Team Developer | Working on: Data layer table utility. | LinkedIn