I have my own Server with Voice Switch and not really familiar with SQL.
Having problem with following: 02-25 12:05:32 MySQL error description : Duplicate entry '0' for key 'UQ_CallsIDCC' 02-25 12:05:32 MySQL sql state : Duplicate entry '0' for key 'UQ_CallsIDCC' (this error gives from switch connected to SQL and doesn't update call records into database as value is always 0 and can't repeat same Unique value)
I know there is trigger left from previous admin, but simple gives an error when executing:
delimiter $$
create trigger calls
before insert on calls
for each row
BEGIN
IF NEW.id_cc > '0' THEN
set NEw.id_cc = '0';
set NEw.id_cn = '0';
END IF;
END
$$
When trying to execute trigger I get error:
"This version of SQL doesn't yet support 'multiple triggers'
