On our test server we found that we have a few CommentReportLog records whose rid is not a valid index into the SubPostCommentReport table. The foreign key constraint on the rid was broken until recently which permitted the invalid entries to be inserted. I haven't been able to figure out where in current or past versions of the code an invalid rid could be inserted.
Our production database does not contain any invalid rids.
The invalid rids caused the migration from #247 to fail when run on our test server. This change fixes the failing migration by dropping any records from the CommentReportLog table with an invalid rid.
On our test server we found that we have a few
CommentReportLogrecords whoseridis not a valid index into theSubPostCommentReporttable. The foreign key constraint on theridwas broken until recently which permitted the invalid entries to be inserted. I haven't been able to figure out where in current or past versions of the code an invalidridcould be inserted.Our production database does not contain any invalid
rids.The invalid
rids caused the migration from #247 to fail when run on our test server. This change fixes the failing migration by dropping any records from theCommentReportLogtable with an invalidrid.