Hello, In my asterisk, I created database using MariaDB. Also I created data table called CDR for storing call details in my database. But After each call, it saved data with duplicate. I mean save same data set twice. How fix this issue?
To prevent duplicate entries in your CDR table, you can add a unique constraint to the appropriate columns in your database schema.
ALTER TABLE CDR ADD CONSTRAINT unique_cdr_entry UNIQUE (call_id);
Replace call_id with the appropriate column name that uniquely identifies each call entry. This constraint ensures that no duplicate entries with the same call_id will be inserted into the table.
i hope it will work for you.
Unique constraints are not there to work round this sort of problem. Although there isn’t enough information to understand this particular issue, if you are getting two records when you expect one, it is probably because you don’t understand how CDRs work.
Without the column names, dialplan, and CDR settings, I’m not sure why there are two records, but you should “fix” this by suppressing the second one, without understanding what is happening.