Error with sql 11217_01_mangos_creature_addon

[Auntie Mangos]

Having problems with this, looked at the previous post i don't seem to understand the solution. Could someone tell me how to correct this? Used this guide here

http://getmangos.eu/community/topic/16174/install-log-with-ubuntu-1010/

Help would be greatly appreciated.

[chuanhsing]

you need the root privileges to add this sql

mysql -u root -p mangos < sql/updates/11217_01_mangos_creature_addon.sql

[stolenwhisper]

I tried that too, it was in the setup guide. Still had errors :-(

[cecilporter]

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
---------------------------------------------------

[stolenwhisper]

any ideas anyone? Found a few bugs with creatures in instances too. Wondering if its just because i skipped this database or if it's a mangos error. The errors in instances i'm getting is some instances don't spawn correctly, and some when engaging an enemy they drop through the floor and then when unflagged for combat they return above the floor.

[Patman128]

Run SET GLOBAL log_bin_trust_function_creators = 1; and try it again.

[stolenwhisper]

how do I do that? Sorry for the n00b question. Still kind of new to linux.

[Patman128]

Open the MySQL console with mysql in your command line, or use a front-end like phpMyAdmin.

[antiroot]

I prefer not to use root to do my mangos stuff, i did the following so only the mangos user was needed and so that mysql configs didn't need to be changed

mysql> GRANT SUPER ON *.* TO 'mangos'@'localhost';

and edited 11217_01_mangos_creature_addon.sql with this

diff --git a/sql/updates/11217_01_mangos_creature_addon.sql b/sql/updates/11217_01_mangos_creature_addon.sql
index cf00588..0256b3e 100644
--- a/sql/updates/11217_01_mangos_creature_addon.sql
+++ b/sql/updates/11217_01_mangos_creature_addon.sql
@@ -8,6 +8,8 @@ DELIMITER %%

CREATE FUNCTION `ConvertAuras`(`auras` varchar(1024))
RETURNS varchar(1024) CHARSET utf8
+DETERMINISTIC
+READS SQL DATA
BEGIN
  DECLARE tmp VARCHAR(1024);
  DECLARE curr VARCHAR(10);

seems to have worked for me since the creature_addon table reflected the correct changes afterward

plus i don't like having to turn things on in off in mysql to make something work with it, only downside is that it gives mangos SUPER globally, which i revoke after updating the db

[chuanhsing]

antiroot, thanks your information.

[stolenwhisper]

Thanks anti root, will be trying this later tonight when I get home. I appreciate the responses guys.