#1 Error due to constraint violation in userpics table

[Anonymous]

My girlfriend had trouble archiving a greatest journal that somehow had 2 userpics with duplicate keywords.

The following patch adds a check to make certain that a userpic with non-unique keyword will not be added to the archive (thus breaking the constraint and causing a crash).

The patch is made in the Journal.cs file in the Engine.
Lines 1706-1808 (or thereabouts)

public UserPicsRow AddUserPicsRow(string PicKeyword, string PicURL) {
if (this.FindByPicKeyword(PicKeyword) == null)
{
UserPicsRow rowUserPicsRow = ((UserPicsRow)(this.NewRow()));
rowUserPicsRow.ItemArray = new object[] {
PicKeyword,
PicURL};
this.Rows.Add(rowUserPicsRow);
return rowUserPicsRow;
}
else
return null;
}