We have a news functionality in SP2013 based on the blog site template. The problem occurs when a post receives more than 10 comments: SharePoint adds a paging button (the left and right arrows) in the comments web part. What happens is that, for some users, when they click the "next page" arrow, it results in an error message that says: Exception from HRESULT: 0x80131904 Correlatie-id:f8de479d-0dd1-90e3-bd66-57a04683f7f9
I already researched the issue and problem seems to be that at the end of the url "%23comments" is being appended, resulting in the error.
Looking through the log I notice at least three error messages that might be related to the cause?
1) System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value '31525#comments' to data type int. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
2) Error while executing web part: Microsoft.SharePoint.SPException: Exception from HRESULT: 0x80131904 ---> System.Runtime.InteropServices.COMException: Exception from HRESULT: 0x80131904
3) Type mismatch with field PostTitle and value 31525#comments. f8de479d-0dd1-90e3-bd66-57a04683f7f9
Some other people seem to have the same issue:
ps: we do have a custom branding solution that's activated as a site collection feature. I doubt if this is a real cause though, because for some users it works fine, but others do get the error. Could it be a permissions issue? Maybe caching related?
Does anyone know why this occurs and what the solution is?
Is it possible to change the Comments web part to show more than 10 items at once, to avoid the paging button?
Lastly, is it possible to change the sorting of the comments to have the most recent comment show at the top? I tried without luck (changing the view breaks the web part).
Would be great to hear your experience and feedback on these blog issues.