search

jonrainier / DayZ-Private-Server

DayZ Private Server by Pwnoz0r
98 stars 131 forks source link

Error Code: 1418. #155

Open brantpastore opened 5 years ago

brantpastore commented 5 years ago

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 commented 5 years ago

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