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

Drop Trigger IF Exists fatals if custom table too long

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 4.3.0
    • Fix Version/s: 4.4.0
    • Component/s: None
    • Labels:
      None

      Description

      I fixed some tests that were failing by reducing the length of the custom group title when creating custom groups (via api) - however, I don't think there is something to prevent this occurring in the wild.

      Basically the trigger is called civicrm_value_title_on_insert & there is a length limit on the trigger (I read 18 but that doesn't make sense as I haven't hit it in the wild. Anyway, when you go to delete the custom group now there is a 'delete trigger if exists' (even without logging on) & it was fataling everytime on the tests until I imposed a length limit

        Attachments

          Activity

            People

            • Assignee:
              deepak Deepak Srivastava
              Reporter:
              eileen Eileen McNaughton
            • Votes:
              1 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: