Triggers to regroup CDRs mysql problem dst_ousername

37 views
Skip to first unread message

nabil...@moji.fr

unread,
Jun 1, 2018, 4:54:16 AM6/1/18
to CDR-Stats
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



nabil...@moji.fr

unread,
Jun 1, 2018, 4:56:08 AM6/1/18
to CDR-Stats
Reply all
Reply to author
Forward
0 new messages