CiviCRM Community Forums (archive)

Oops, table civicrm_contribution_soft is in the database but not the schema
Oops, table civicrm_mail_settings is in the database but not the schema
Oops, table civicrm_pcp is in the database but not the schema
Oops, table civicrm_pcp_block is in the database but not the schema

These tables are new in 2.2.  The upgrade process in CiviCRM 2.2 adds these tables.  But if the tables already exist, that's a fatal error and the upgrade aborts.  You need to restore from a backup of the database made before your first attempt to upgrade.  It is currently impossible to restart a failed upgrade.

When you restore from backup, remember that the only way to get rid of the unwanted tables is to delete them.  The safest course is to delete the entire database, create an empty database then restore into the empty database.  I don't know how you make your database dump.  If you use mysqldump, there is a command line option --add-drop-database that will put the necessary commands to delete and recreate the database at the beginning of the dump.

Oops, in civicrm_option_value, option_group_id 77 value 120 has multiple
    definitions. Labels are: 'Player (Colt)' 'Player (Student)' 'Non-Playing (Full Member)'
Oops, in civicrm_option_value, option_group_id 77 value 75 has multiple
    definitions. Labels are: 'Player (Junior)' 'Junior Parent'

The repair tool can't repair this because it is necessary to choose among the multiple definitions then reorganize the data based on that choice.  In the first instance, the CiviCRM administrator will see the three labels and assign one to the data being entered.  When the activity is displayed from the database, a different label might be shown.  This is because what is actually stored in the database is the number 120, not the text of the label.  When the relevant record is fetched, CiviCRM will display one of the three labels associated with 120 but not necessarily the label that was originally chosen when the data was entered.  To correct the problem, you need to assign a different value for two of the labels, then go through the recorded data by hand and decide which of the three labels was intended.

-- Walt