Hello,
When insert this mysql command in kamailio database, i have this error :
Mysql code
"DELIMITER //
CREATE TRIGGER copy_cdrs
AFTER INSERT
ON cdrs FOR EACH ROW
BEGIN
INSERT INTO collection_cdrs SET
cdr_id = NEW.cdr_id,
src_username = NEW.src_username,
src_domain = NEW.src_domain,
dst_username = NEW.dst_username,
dst_domain = NEW.dst_domain,
dst_ousername = NEW.dst_ousername,
call_start_time = NEW.call_start_time,
duration = NEW.duration,
sip_call_id = NEW.sip_call_id,
sip_from_tag = NEW.sip_from_tag,
sip_to_tag = NEW.sip_to_tag,
src_ip = NEW.src_ip,
cost = NEW.cost,
rated = NEW.rated,
sip_code = 200,
sip_reason = ''
;
END; //
DELIMITER ;
"
I have this error " ERROR 1054 (42S22): Unknown column 'dst_ousername' in 'NEW' "
i recreate dst_ousername in mysql but i have the same error
Thanks for help