the error that I got three times is
JDatabaseMySQL::query: 1307 - Failed to CREATE PROCEDURE TeraWurfl_RIS SQL=CREATE PROCEDURE `TeraWurfl_RIS`(IN ua VARCHAR(255), IN tolerance INT, IN matcher VARCHAR(128)) BEGIN DECLARE curlen INT; DECLARE wurflid VARCHAR(128) DEFAULT NULL; DECLARE curua VARCHAR(255); SELECT CHAR_LENGTH(ua) INTO curlen; findua: WHILE ( curlen >= tolerance ) DO SELECT CONCAT(LEFT(ua, curlen ),'%') INTO curua; SELECT idx.DeviceID INTO wurflid FROM jos_terawurflindex idx INNER JOIN jos_terawurflmerge mrg ON idx.DeviceID = mrg.DeviceID WHERE idx.matcher = matcher AND mrg.user_agent LIKE curua LIMIT 1; IF wurflid IS NOT NULL THEN LEAVE findua; END IF; SELECT curlen - 1 INTO curlen; END WHILE; SELECT wurflid as DeviceID; END
Any ideas ?