I am getting SQL insert errors on several things if I do not specifically enter a value in a place where by default there is no value.
For example, if I do not enter a value for “Pause before answer” in an incoming route, I get the following:
FATAL ERROR
INSERT INTO incoming (cidnum,extension,destination,privacyman,pmmaxretries,pmminlength,alertinfo, ringing, mohclass, description, grppre, delay_answer, pricid) values (’’,’’,‘from-did-direct,2000,1’,‘0’,‘3’,‘10’,’’, ‘’, ‘default’, ‘Default’, ‘’, ‘’, ‘’) [nativecode=1366 ** Incorrect integer value: ‘’ for column ‘delay_answer’ at row 1]SQL -
INSERT INTO incoming (cidnum,extension,destination,privacyman,pmmaxretries,pmminlength,alertinfo, ringing, mohclass, description, grppre, delay_answer, pricid) values (’’,’’,‘from-did-direct,2000,1’,‘0’,‘3’,‘10’,’’, ‘’, ‘default’, ‘Default’, ‘’, ‘’, ‘’)
Any thoughts on a fix for this??