I had a problem where comments weren't saving. The postback to /createcomment/ was throwing an exception.
The exception was:
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> MySql.Data.MySqlClient.MySqlException: Out of range value for column 'MAINID' at row 1
I noticed in the Base.cs class that "-1" was being written to the field "mainid" for every insert based on this line:
SqlHelper.CreateParameter("@mainid", -1),
I changed "-1" to "0" and the error went away and comments would save. I'm not sure if this will negatively impact something until I test some more, but I wanted to let you know about this issue.
Bug found with MySQL
I had a problem where comments weren't saving. The postback to /createcomment/ was throwing an exception.
The exception was:
umbraco.DataLayer.SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteNonQuery ---> MySql.Data.MySqlClient.MySqlException: Out of range value for column 'MAINID' at row 1
I noticed in the Base.cs class that "-1" was being written to the field "mainid" for every insert based on this line:
SqlHelper.CreateParameter("@mainid", -1),
I changed "-1" to "0" and the error went away and comments would save. I'm not sure if this will negatively impact something until I test some more, but I wanted to let you know about this issue.
Regards,
Ben
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.