cecilporter

this worked perfectly for me! awesome, thanks!

same here. ran it as root but it throws errors: Error Code : 1418 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) Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000 --------------------------------------------------- 0 row(s) affected Execution Time : 00:00:00:047 Transfer Time : 00:00:00:000 Total Time : 00:00:00:047 --------------------------------------------------- 4 row(s) affected Execution Time : 00:00:00:062 Transfer Time : 00:00:00:000 Total Time : 00:00:00:062 --------------------------------------------------- 74 row(s) affected Execution Time : 00:00:00:032 Transfer Time : 00:00:00:000 Total Time : 00:00:00:032 --------------------------------------------------- Query : UPDATE `creature_template_addon` SET `auras` = ConvertAuras(`auras`) WHERE `auras` IS NOT NULL Error Code : 1305 FUNCTION mangos.ConvertAuras does not exist Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000 --------------------------------------------------- 0 row(s) affected Execution Time : 00:00:00:313 Transfer Time : 00:00:00:000 Total Time : 00:00:00:313 --------------------------------------------------- 52 row(s) affected Execution Time : 00:00:00:312 Transfer Time : 00:00:00:000 Total Time : 00:00:00:312 --------------------------------------------------- 173 row(s) affected Execution Time : 00:00:00:266 Transfer Time : 00:00:00:000 Total Time : 00:00:00:266 --------------------------------------------------- Query : UPDATE `creature_addon` SET `auras` = ConvertAuras(`auras`) WHERE `auras` IS NOT NULL Error Code : 1305 FUNCTION mangos.ConvertAuras does not exist Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000 --------------------------------------------------- Query : DROP FUNCTION `ConvertAuras` Error Code : 1305 FUNCTION mangos.ConvertAuras does not exist Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000 --------------------------------------------------- 0 row(s) affected Execution Time : 00:00:00:000 Transfer Time : 00:00:00:000 Total Time : 00:00:00:000 ---------------------------------------------------

broken link