Campaign tracking not working

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

I’m not sure it’s the same issue, but can you try this change to see if it improves things?

https://github.com/salesagility/SuiteCRM/pull/5068/files

Please report back on your findings.

3 Likes

That fixed it - Thank you!

I don’t really know how to comment on GitHub - do I need to alert anyone else?

I already left a comment there earlier.

https://github.com/salesagility/SuiteCRM/pull/5068

You can keep an eye on that and if nothing happens after a couple of days after the weekend, post a new comment there (or here!) as a reminder.

Thanks

I had the same problem. replaced the code of the utils.php file and the problem is solved.
Thanks for your information.

This is already merged, so it’s probably easier to just upgrade to the newest version on your branch (7.8.15 or 7.9.14)