The alerts described in this link:
Getting MACRO SQL ERRORS
This error is a result of a typo in the two alerts mentioned in my post near the bottom.
I give a step by step remediation for this issue (See step 3)
This typo is still in version 10.7.
The fix is to remove the "doubled" single quotes (there are two of them) and replacing them with a "single" single quote.
There are two alerts that are affected by this typo.
This typo is so old that it has crust on it's ears.
Thanks!
Kirk