Overview

Unable to access any Wiki and getting 500 Internal Server Error

Environment

FogBugz

Root Cause

Duplicate "Favorite" items in the list of favorites or stars that were interfering with the loading of Wikis. It sometimes occurs when adding a favorite due to network hiccups or browser issues (e.g. older version of IE).

Resolution

1. Find out the user's ixPerson. You can get it from the URL in the edit user page.
2. Go to FogBugz Database and remove the duplicates by: 

   SELECT ixDocList FROM DocList WHERE ixPerson = [the person ID];
   
   SELECT ixItem FROM DocListItem WHERE ixDocList = [the doclist ID] GROUP BY ixItem HAVING COUNT(ixItem) > 1;

    

Example