1

Closed

SQL Error when post moderated by Admin or Host User Not Assigned As Moderator

description

The admin or host user may moderate posts without having previously been assigned as a moderator. When so doing, the post is successfully moderated but the following SQL Error occurs since the admin or host user does not exist in the WESNet_EPrayer_Moderators table:
 
"Cannot insert the value NULL into column 'PostsModerated', table 'DNN5Source.dbo.DNN_WESNet_EPrayer_Moderators'; column does not allow nulls. UPDATE fails. The statement has been terminated."
 
Fixed WHERE condition in stored procedure WESNet_EPrayer_UpdateModeratorStats.
Closed Jun 18, 2012 at 9:58 PM by imagemaker
Closed all issues fixed in v 5.00.01

comments