Checking databases for errors

There are lots of checks that need to be made to ensure the accuracy of the databases.  This topic is intended to list things that are easy to check.

  • Sort by each column that is sortable and see if it is in alphabetic order. For example a sort by hike name revealed several out of order because their name began with a blank. I fixed these.
  • Some fields should never be blank, a sort reveals these. For example the hike database has 2 with a blank state field. Not yet fixed. The date field should not be blank. Many of these.Both of these fields have been fixed to be required so new ones won't be created, but that doesn't fix old ones.