I am posting this in case anyone else runs into the same problem.
It looks the error occurs when you have a from address with a trailing semicolon. It is not possible to enter an address with this format in Checkbox, validation prevents. I had to set up the scenario by altering the data directly in the database. I have added this issue to our bug tracker and am working on resolving the issue in our 4.5 release. In the meantime the following queries may be helpful if you decide to clean up the from addresses.
If you are comfortable making changes directly in the database you can use the first query to find the email addresses that need to be changed.
--Returns the list of email items with invalid from addresses
--BEGIN
SELECT
*
FROM
[ckbx_ItemData_Email]
WHERE
FromAddress like '%;'
--END
If you would prefer to make the change through Checkbox the following query should return the names of the survey that need to be edited.
--BEGIN
SELECT
TemplateName
FROM
ckbx_ResponseTemplate as rt
INNER JOIN ckbx_Template_Items as ti
ON rt.ResponseTemplateID = ti.TemplateID
INNER JOIN ckbx_ItemData_Email as ie
ON ti.ItemID = ie.ItemID
WHERE
ie.FromAddress like '%;'
--END
|