Hi,
I'm getting the below error when trying to link a template with items that has application name "LOG"
Any idea what might be wrong here and how can I fix it?
- Mosh
I'm getting the below error when trying to link a template with items that has application name "LOG"
Any idea what might be wrong here and how can I fix it?
- Error in query [INSERT INTO applications (name,hostid,applicationid) VALUES ('LOG','10289','9583'),('LOG','10384','9584'),('LO G','10385','9585'),('LOG','10386','9586'),('LOG',' 10387','9587'),('LOG','10388','9588'),('LOG','1038 9','9589'),('LOG','10390','9590'),('LOG','10391',' 9591'),('LOG','10392','9592'),('LOG','10393','9593 '),('LOG','10394','9594'),('LOG','10395','9595'),( 'LOG','10396','9596'),('LOG','10397','9597'),('LOG ','10398','9598'),('LOG','10399','9599'),('LOG','1 0400','9600'),('LOG','10401','9601'),('LOG','10402 ','9602'),('LOG','10403','9603'),('LOG','10404','9 604'),('LOG','10405','9605'),('LOG','10406','9606' ),('LOG','10407','9607'),('LOG','10408','9608'),(' LOG','10409','9609'),('LOG','10410','9610'),('LOG' ,'10411','9611'),('LOG','10412','9612'),('LOG','10 413','9613'),('LOG','10414','9614'),('LOG','10415' ,'9615'),('LOG','10416','9616'),('LOG','10417','96 17'),('LOG','10418','9618'),('LOG','10419','9619') ,('LOG','10420','9620'),('LOG','10421','9621'),('L OG','10422','9622'),('LOG','10423','9623'),('LOG', '10424','9624'),('LOG','10425','9625'),('LOG','104 26','9626'),('LOG','10427','9627'),('LOG','10428', '9628'),('LOG','10429','9629'),('LOG','10430','963 0'),('LOG','10431','9631'),('LOG','10432','9632'), ('LOG','10433','9633'),('LOG','10434','9634'),('LO G','10435','9635'),('LOG','10436','9636'),('LOG',' 10758','9637'),('LOG','10759','9638'),('LOG','1076 0','9639'),('LOG','10761','9640'),('LOG','10802',' 9641'),('LOG','11005','9642'),('LOG','11117','9643 '),('LOG','11118','9644'),('LOG','11119','9645'),( 'LOG','11131','9646'),('LOG','11135','9647'),('LOG ','11145','9648'),('LOG','11146','9649')] [Cannot add or update a child row: a foreign key constraint fails (`zabbix`.`applications`, CONSTRAINT `c_applications_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE)]
- SQL statement execution has failed "INSERT INTO applications (name,hostid,applicationid) VALUES ('LOG','10289','9583'),('LOG','10384','9584'),('LO G','10385','9585'),('LOG','10386','9586'),('LOG',' 10387','9587'),('LOG','10388','9588'),('LOG','1038 9','9589'),('LOG','10390','9590'),('LOG','10391',' 9591'),('LOG','10392','9592'),('LOG','10393','9593 '),('LOG','10394','9594'),('LOG','10395','9595'),( 'LOG','10396','9596'),('LOG','10397','9597'),('LOG ','10398','9598'),('LOG','10399','9599'),('LOG','1 0400','9600'),('LOG','10401','9601'),('LOG','10402 ','9602'),('LOG','10403','9603'),('LOG','10404','9 604'),('LOG','10405','9605'),('LOG','10406','9606' ),('LOG','10407','9607'),('LOG','10408','9608'),(' LOG','10409','9609'),('LOG','10410','9610'),('LOG' ,'10411','9611'),('LOG','10412','9612'),('LOG','10 413','9613'),('LOG','10414','9614'),('LOG','10415' ,'9615'),('LOG','10416','9616'),('LOG','10417','96 17'),('LOG','10418','9618'),('LOG','10419','9619') ,('LOG','10420','9620'),('LOG','10421','9621'),('L OG','10422','9622'),('LOG','10423','9623'),('LOG', '10424','9624'),('LOG','10425','9625'),('LOG','104 26','9626'),('LOG','10427','9627'),('LOG','10428', '9628'),('LOG','10429','9629'),('LOG','10430','963 0'),('LOG','10431','9631'),('LOG','10432','9632'), ('LOG','10433','9633'),('LOG','10434','9634'),('LO G','10435','9635'),('LOG','10436','9636'),('LOG',' 10758','9637'),('LOG','10759','9638'),('LOG','1076 0','9639'),('LOG','10761','9640'),('LOG','10802',' 9641'),('LOG','11005','9642'),('LOG','11117','9643 '),('LOG','11118','9644'),('LOG','11119','9645'),( 'LOG','11131','9646'),('LOG','11135','9647'),('LOG ','11145','9648'),('LOG','11146','9649')".
- Mosh