Just installed ASL on a brand new server and was welcome by these, any ideas?
Code: Select all
2 63 c_web::_init_tables CREATE TRIGGER tortix.before_alert_insert BEFORE INSERT ON alert FOR EACH ROW BEGIN IF (((SELECT code FROM aslw_geo_range WHERE NEW.src_ip BETWEEN ip_start AND ip_end ORDER BY ip_start DESC LIMIT 1) > 0)) THEN BEGIN SET NEW.tld='??'; END;ELSE BEGIN SET NEW.tld=(SELECT code FROM aslw_geo_range WHERE NEW.src_ip BETWEEN ip_start AND ip_end ORDER BY ip_start DESC LIMIT 1); END;END IF;END;
2 63 c_web::_init_tables [b]This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table[/b]'