Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-12175

Database errors could be more user friendly

    Details

    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Won't Fix
    • Affects Version/s: 4.3.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      This is a little pedantic, but I ran an update and get the following error…

      "Sorry but we are not able to provide this at the moment.
      There is a data integrity issue with this CiviCRM database. It contains 2 contribution records which are linked to contact records that have been deleted. You will need to correct this manually before you can run the upgrade. Use the following MySQL query to identify the problem records: SELECT ct.* FROM civicrm_contribution ct LEFT JOIN civicrm_contact c ON ct.contact_id = c.id WHERE c.id IS NULL; These records will need to be deleted or linked to an existing contact record."

      OK, I get it and know what to do about it, but is there any way these could be more helpful or even just look less 'scary'?

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              chrischinchilla Chris Chinchilla
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: