Call Journaling to mysql in v20

[it-admin@proximitydesigns]

Hello,

We have been using call journaling to MySQL in v18 and after we upgraded to v20, it doesn't work anymore. The MySQL connection is working and we can search the contact using Select statement however, Insert into statement for call journaling is not working anymore. Are there any changes in this feature?
Below is our Insert into statement.

INSERT INTO `3CX`.`calljournal3cx` (`Number`, `CallType`, `CallDirection`, `Name`, `EntityId`, `EntityType`, `Agent`, `AgentFirstName`, `AgentLastName`, `AgentEmail`, `Duration`, `DurationTimeSpan`, `CallDateTime`, `CallStartTimeLocal`, `CallStartTimeUTC`, `CallEstablishedTimeLocal`, `CallEstablishedTimeUTC`, `CallEndTimeLocal`, `CallEndTimeUTC`, `CallStartTimeLocalMillis`, `CallStartTimeUTCMillis`, `CallEstablishedTimeLocalMillis`, `CallEstablishedTimeUTCMillis`, `CallEndTimeLocalMillis`, `CallEndTimeUTCMillis`) VALUES ('[Number]', '[CallType]', '[CallDirection]', '[Name]', '[EntityId]', '[EntityType]', '[Agent]', '[AgentFirstName]', '[AgentLastName]', '[AgentEmail]', '[Duration]', '[DurationTimeSpan]', IF('[DateTime]'='', NULL, STR_TO_DATE('[DateTime]','%m/%d/%Y %T')), IF('[CallStartTimeLocal]'='', NULL, STR_TO_DATE('[CallStartTimeLocal]','%m/%d/%Y %T')), IF('[CallStartTimeUTC]'='', NULL, STR_TO_DATE('[CallStartTimeUTC]','%m/%d/%Y %T')), IF('[CallEstablishedTimeLocal]'='', NULL, STR_TO_DATE('[CallEstablishedTimeLocal]','%m/%d/%Y %T')), IF('[CallEstablishedTimeUTC]'='', NULL, STR_TO_DATE('[CallEstablishedTimeUTC]','%m/%d/%Y %T')), IF('[CallEndTimeLocal]'='', NULL, STR_TO_DATE('[CallEndTimeLocal]','%m/%d/%Y %T')), IF('[CallEndTimeUTC]'='', NULL, STR_TO_DATE('[CallEndTimeUTC]','%m/%d/%Y %T')), '[CallStartTimeLocalMillis]', '[CallStartTimeUTCMillis]', '[CallEstablishedTimeLocalMillis]', '[CallEstablishedTimeUTCMillis]', '[CallEndTimeLocalMillis]', '[CallEndTimeUTCMillis]');

Based on the call journaling above, we are also using CFP app to check the call journals and transfer directly to a specific extension for callback feature within 24 hours of the first call. As call journaling is not working, the CFD is also not working for the call back feature.

 

[it-admin@proximitydesigns]

As an update to the above issue, we have also tried with the new Insert query based on the V20 user manual but it's still not working.

INSERT INTO 3CX.calljournal3cx (Number, CallType, CallDirection, Name, EntityId, EntityType, Agent, AgentFirstName, AgentLastName, AgentEmail, Duration, DurationTimeSpan, CallDateTime, CallStartTimeLocal, CallStartTimeUTC, CallEstablishedTimeLocal, CallEstablishedTimeUTC, CallEndTimeLocal, CallEndTimeUTC, CallStartTimeLocalMillis, CallStartTimeUTCMillis, CallEstablishedTimeLocalMillis, CallEstablishedTimeUTCMillis, CallEndTimeLocalMillis, CallEndTimeUTCMillis) VALUES (@number, @CallType, @CallDirection, @Name, @EntityId, @EntityType, @Agent, @AgentFirstName, @AgentLastName, @AgentEmail, @Duration, @DurationTimeSpan, DATE_FORMAT(@DateTime, '%Y-%m-%dT%H:%i:%s%Z'), DATE_FORMAT(@CallStartTimeLocal, '%Y-%m-%dT%H:%i:%s%Z'), DATE_FORMAT(@CallStartTimeUTC, '%Y-%m-%dT%H:%i:%s%Z'), DATE_FORMAT(@CallEstablishedTimeLocal, '%Y-%m-%dT%H:%i:%s%Z'), DATE_FORMAT(@CallEstablishedTimeUTC, '%Y-%m-%dT%H:%i:%s%Z'), DATE_FORMAT(@CallEndTimeLocal, '%Y-%m-%dT%H:%i:%s%Z'), DATE_FORMAT(@CallEndTimeUTC, '%Y-%m-%dT%H:%i:%s%Z'), @CallStartTimeLocalMillis, @CallStartTimeUTCMillis, @CallEstablishedTimeLocalMillis, @CallEstablishedTimeUTCMillis, @CallEndTimeLocalMillis, @CallEndTimeUTCMillis);

 

[edossantos_sipcaller]

In v20 you need to use parameters. Please note the case of the parameters you're using. For example, I see @number, but it should be @number. The variable names are defined here:
https://www.3cx.com/docs/crm-template-xml-description/#h.vcivldjsa1lz