Hello, I am currently having an issue with MySQL!
What’s going wrong here? I am a cPanel user, and yes I have searched this and found no definitive answers. It appears this is more specific than other people with the same error codes issues. Please add a detailed response that I can follow along with! P.s I am using a shared hosting account.
DELIMITER $$-- -- Functions -- CREATE DEFINER = `root`@`localhost` FUNCTION `fnc_calcWalkedDistance` ( `steamid64` BIGINT UNSIGNED ) RETURNS INT( 10 ) UNSIGNEDNO SQL BEGIN DECLARE finished INTEGER DEFAULT 0; DECLARE distance INTEGER DEFAULT 0; DECLARE x1, x2, z1, z2 FLOAT; DECLARE curs CURSOR FOR SELECT x, z FROM log_positions WHERE `steamid` = steamid64 ORDER BY `timestamp` DESC ; DECLARE CONTINUE HANDLER FOR NOT FOUND SET finished =1; OPEN curs; FETCH curs INTO x1, z1; SET x2 = x1; SET z2 = z1; calculate : LOOPFETCH curs INTO x1, z1; IF finished =1 THEN LEAVE calculate; END IF ; SET distance = distance + SQRT( POW( x2 - x1, 2 ) + POW( z2 - z1, 2 ) ) ; -- SET distance = distance + 1; SET x2 = x1; SET z2 = z1; END LOOP calculate; CLOSE curs; RETURN distance; END$$
Here is the error code:
MySQL said: Documentation #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
It means you don’t have privileges to create the trigger with [email protected] user..
try removing definer from the trigger command:
CREATE DEFINER =