Corrupt v1 database

[Martin Wright]

Sorry, here's the Report:





Problems found!

************************************************************************
* BaseObject: "sysItemDescription"
************************************************************************
All right.

-----> Field: "Kind' of type Long
All right.

-----> Field: "ParentPtr' of type ObjectPtr
All right.

-----> Field: "ColumnName' of type VarChar
All right.

-----> Field: "ColumnType' of type Byte
All right.



************************************************************************
* BaseObject: "sysItem"
************************************************************************
All right.

-----> Field: "ItemDescrPtr' of type ObjectPtr
All right.

-----> Field: "Value' of type VarChar
All right.

-----> Field: "TextValue' of type Text
All right.

-----> Field: "ParentPtr' of type ObjectPtr
All right.



************************************************************************
* BaseObject: "Questions"
************************************************************************
All right.

-----> Field: "QuestionNumber' of type UShort
All right.

-----> Field: "Subject' of type VarChar
All right.

-----> Field: "Year' of type UShort
All right.

-----> Field: "Unit' of type VarChar
All right.

-----> Field: "TestNumber' of type UShort
All right.

-----> Field: "Artwork' of type VarChar
All right.

-----> Field: "Question' of type VarChar
All right.

-----> Field: "Answer_A' of type VarChar
All right.

-----> Field: "Answer_B' of type VarChar
All right.

-----> Field: "Answer_C' of type VarChar
All right.

-----> Field: "Answer_D' of type VarChar
All right.

-----> Field: "CorrectAnswer' of type VarChar
All right.

-----> Field: "PageRef' of type VarChar
All right.

-----> Field: "Level' of type UShort
All right.



************************************************************************
* BaseObject: "UserScores"
************************************************************************
Problems found.

-----> Field: "Username' of type VarChar
Problems found!

...........Page 5
(!) Length of deleted 257 record is NOT zero
(!) Length of deleted 258 record is NOT zero
(!) Length of deleted 259 record is NOT zero
(!) Length of deleted 260 record is NOT zero
(!) Length of deleted 261 record is NOT zero
(!) Length of deleted 262 record is NOT zero
(!) Length of deleted 263 record is NOT zero
(!) Length of deleted 264 record is NOT zero
(!) Length of deleted 265 record is NOT zero
(!) Length of deleted 266 record is NOT zero
(!) Length of deleted 267 record is NOT zero
(!) Length of deleted 268 record is NOT zero
(!) Length of deleted 269 record is NOT zero
(!) Length of deleted 270 record is NOT zero
(!) Length of deleted 271 record is NOT zero


-----> Field: "Year' of type UShort
Problems found!

(!) Table has 270 physical records but field has 271


-----> Field: "Unit' of type VarChar
All right.

-----> Field: "Subject' of type VarChar
All right.

-----> Field: "Score' of type UShort
Problems found!

(!) Table has 270 physical records but field has 256


-----> Field: "Completed' of type UShort
Problems found!

(!) Table has 270 physical records but field has 256


-----> Field: "Date' of type Date
Problems found!

(!) Table has 270 physical records but field has 256


-----> Field: "Classname' of type VarChar
All right.

-----> Field: "Classyear' of type UShort
Problems found!

(!) Table has 270 physical records but field has 256


-----> Field: "Level' of type UShort
Problems found!

(!) Table has 270 physical records but field has 256


-----> Field: "SavedResults' of type Text
Problems found!

(!) Minor problem: exists 30 orphan segments.(indicate mistake in algorithm.)