We are using Contour 3.0.6 on Umbraco 4.9.0 and have come across a strange bug when using CheckBoxList fields in our forms. The problem only occurs when more than one checkbox is selected, which causes the following error when the form is submitted:
"Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery"
Could it be that the Contour version was upgraded from an earlier v3 version? That reintroduces the following bug http://issues.umbraco.org/issue/CON-98 (due to a bad merge)
To fix on your install simly run the following sql script
Umbraco exception when using checkbox lists
We are using Contour 3.0.6 on Umbraco 4.9.0 and have come across a strange bug when using CheckBoxList fields in our forms. The problem only occurs when more than one checkbox is selected, which causes the following error when the form is submitted:
"Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery"
Looking into the logs it seems to be a similar error as reported in this issue - http://issues.umbraco.org/issue/CON-118
Comment author was deleted
Could it be that the Contour version was upgraded from an earlier v3 version? That reintroduces the following bug http://issues.umbraco.org/issue/CON-98 (due to a bad merge)
To fix on your install simly run the following sql script
Yes it was an upgraded version of Contour & your script has worked a treat - thanks Tim! #h5yr
is working on a reply...