Page Comparison

This is how to update type:

1. The log file shows which presentation is inconsistent. E.g. This is impossible, presentation with id: 128.
2. Use SQL to identify the presentation in the Presentations table.
3. Look the TypeId and update the TypeId to the correct type.

This is how to figure out the type a presentation has:

1. Use the below sql statement to find all TypeId.

   SELECT *  FROM [Assert4#AC].[dbo].[PresentationTypes] p left outer join dbo.TextTranslations t on t.TextId = p.NameId

   
2. Base type is defined as below.
   

           public const int CatalogueId = 1;
           public const int IllustrationId = 2;
           public const int PartModuleId = 3;
           public const int DocumentId = 4;
           public const int PartId = 5;
           public const int ContentSetId = 6;

3. The TypeId of the presentation may now be used to figure out what type the presentation has in the database.
4. Now try to find the presentation in any of the following tables: Catalogues, Illustrations, PartModules, Documents, Parts, ContentSets. If presentation is e.g. found in Parts, it is now possible to conclude that TypeId is 5.
5. Update the presentation and set TypeId to the new value.