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'