kaossius

Hello, an idee for this error ?:

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

Error with navicat lite 9.1.9

LOG:

mysql> ALTER TABLE db_version CHANGE COLUMN required_11214_02_mangos_command required_11217_01_mangos_creature_addon bit;

CREATE TABLE `temp_auras` (

`spell` mediumint(8) unsigned NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=utf8;

DELIMITER %%

CREATE FUNCTION `ConvertAuras`(`auras` varchar(1024))

RETURNS varchar(1024) CHARSET utf8

BEGIN

DECLARE tmp VARCHAR(1024);

DECLARE curr VARCHAR(10);

DECLARE k INT;

DECLARE pos INT;

DECLARE startp INT;

SET @k = 0;

SET @tmp = '';

SET @startp = 1;

SET @pos = LOCATE(' ', auras);

DELETE FROM temp_auras;

WHILE @pos > 0 DO

IF @k = 0 THEN

SET @curr = SUBSTR(auras, @startp, @pos - @startp);

IF NOT EXISTS(SELECT spell FROM temp_auras WHERE spell = @curr) THEN

SET @tmp = CONCAT(@tmp, @curr, ' ');

INSERT INTO temp_auras VALUES(@curr);

END IF;

END IF;

SET @k = 1-@k;

SET @startp = @pos+1;

SET @pos = LOCATE(' ', auras, @startp);

END WHILE;

SET @tmp = RTRIM(@tmp);

RETURN @tmp;

END%%

DELIMITER ;

UPDATE `creature_template_addon` SET `auras` = REPLACE(`auras`, ' ', ' ');

UPDATE `creature_template_addon` SET `auras` = TRIM(`auras`);

UPDATE `creature_template_addon` SET `auras` = NULL WHERE `auras` = '';

UPDATE `creature_template_addon` SET `auras` = ConvertAuras(`auras`) WHERE `auras` IS NOT NULL;

UPDATE `creature_addon` SET `auras` = REPLACE(`auras`, ' ', ' ');

UPDATE `creature_addon` SET `auras` = TRIM(`auras`);

UPDATE `creature_addon` SET `auras` = NULL WHERE `auras` = '';

UPDATE `creature_addon` SET `auras` = ConvertAuras(`auras`) WHERE `auras` IS NOT NULL;

DROP FUNCTION `ConvertAuras`;

DROP TABLE `temp_auras`;

Query OK, 0 rows affected

Records: 0 Duplicates: 0 Warnings: 0

Query OK, 0 rows affected

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

Query OK, 1 row affected

Rows matched: 8683 Changed: 1 Warnings: 0

Query OK, 30 rows affected

Rows matched: 8683 Changed: 30 Warnings: 0

Query OK, 0 rows affected

Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1305 : FUNCTION testsql.ConvertAuras does not exist

Query OK, 0 rows affected

Rows matched: 20014 Changed: 0 Warnings: 0

Query OK, 17 rows affected

Rows matched: 20014 Changed: 17 Warnings: 0

Query OK, 0 rows affected

Rows matched: 0 Changed: 0 Warnings: 0

ERROR 1305 : FUNCTION testsql.ConvertAuras does not exist

ERROR 1305 : FUNCTION testsql.ConvertAuras does not exist

Query OK, 0 rows affected

Thank you for your answers.

Thanks a lot toupielf !!