DayZ-Private-Server icon indicating copy to clipboard operation
DayZ-Private-Server copied to clipboard

Error Code: 1418.

Open brantpastore opened this issue 6 years ago • 1 comments

Ran into this error while running the included SQL file CREATE DEFINER=dayzhivemind@%FUNCTIONgenerateUID(instint) RETURNS bigint(20) BEGIN DECLARE Min BIGINT DEFAULT 10000000; DECLARE Max BIGINT DEFAULT 99999999; DECLARE UID BIGINT DEFAULT 0; WHILE (UID = 0) DO SET UID = ROUND(Min + RAND() * (Max - Min)); IF (UID IN (SELECT ObjectUID FROM object_data WHERE CharacterID = 0 AND Instance = inst)) THEN SET UID = 0; END IF; END WHILE; RETURN UID; END 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) 0.000 sec

brantpastore avatar Jan 08 '19 07:01 brantpastore

Ive pushed a commit (hash bec07f624711f796f91208184641f767837927fc) to resolve this error.

brantpastore avatar Jan 08 '19 07:01 brantpastore