The 'Call Journaling' does not write all calls to the MySQL database

[MaRu]

The contact-creation and the tests of the contact-creation works fine.

Our Mysql-Statement for the 3CX-Call Journaling sounds like:

INSERT INTO tblcall (calltype, contactnumber, agentextension, calldatetime1, calldatetime2) VALUES ('[CallType]', '[Number]', '[Agent]', STR_TO_DATE('[CallStartTimeLocal]', '%m/%d/%Y %h:%i:%s %p'), STR_TO_DATE('[CallEndTimeLocal]', '%m/%d/%Y %h:%i:%s %p'));

OR

INSERT INTO tblcall (calltype, contactnumber, agentextension, calldatetime1, calldatetime2) VALUES ('[CallType]', '[Number]', '[Agent]', STR_TO_DATE('[CallStartTimeLocal]', '%m/%d/%Y %h:%i:%s %p'), STR_TO_DATE('[CallEndTimeLocal]', '%m/%d/%Y %r'));

Sometimes it works and sometimes it does not work. We are missing some calls!

We have found no plausible reason why he does not always write to the database.

Table structure for table `tblcall` :

CREATE TABLE `tblcall` (
`callid` int(10) UNSIGNED NOT NULL,
`calltype` tinytext NOT NULL,
`contactnumber` tinytext NOT NULL,
`agentextension` tinytext NOT NULL,
`calldatetime1` datetime NOT NULL,
`calldatetime2` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `tblcall`
ADD PRIMARY KEY (`callid`);

ALTER TABLE `tblcall`
MODIFY `callid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
COMMIT;

Our Mysql server is always online without forced interruption and restarts. Where can I find the error message when a command fails.