When we send a newletter campaign, tracking URL’s bounce off our CRM and are correctly ‘translated’, forwarding the user to the correct page on our website.
All good so far.
BUT: The campaign status page only shows the number of messages sent. It shows zero opens or click-thru’s, so there is no tracking
This used to work, and I can still see the opens/click-thru’s for old campaigns.
In the log:
02/02/18 09:07:23 [2560][-none-][FATAL] Query Failed: INSERT into campaign_log (id, campaign_id, target_tracker_key, target_id, target_type, activity_type, activity_date, list_id, marketing_id, hits, deleted, related_id, related_type) VALUES (‘56c361a3-826f-7bdb-c16c-5a749a4e594a’, ‘cb645cdc-fb8a-a47c-1f9a-5a7376fde398’, ‘d1036403-1c3d-26bd-7722-5a7377e0c2e4’, ‘53d6cb5f-3690-3715-5f31-5a7373d996f9’, ‘Contacts’, ‘link’, ‘2018-02-02 17:07:23’, ‘f05fb327-7235-5738-a97a-5a736fa4a57d’, ‘247d7552-4ab7-23d7-61ee-5a7376d566dd’, 1, 0, ‘98739fa2-ef4c-eb55-d895-5a73773bcf01’, ‘CampaignTrackers’): MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '‘56c361a3-826f-7bdb-c16c-5a749a4e594a’, ‘cb645cdc-fb8a-a47c-1f9a-5a7376fde398’ at line 1
SuiteCRM 7.9.11
Windows 2012 r2
Apache 2.4.26
PHP to 5.6.30
MySQL to 5.6.36