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

Logging setup stumbles over views in the civicrm_% namespace

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Trivial
    • Resolution: Fixed/Completed
    • Affects Version/s: 3.4.1
    • Fix Version/s: 3.4.2
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      For some unknown reason i had a view called civicrm_contact_view in my database.

      CRM/Logging/Schema.php iterates over all rows returned from

      SHOW TABLES LIKE 'civicrm_%';

      , which not only returns tables but also views, and then tries to rewrite
      the "Create_Table" column result returned from

      SHOW CREATE TABLE ...

      for each of the SHOW result rows. For views there is no "Create_Table"
      result column now but "Create_View" instead

        Attachments

        1. CRM-8135.patch
          2 kB
          Donald A. Lobo
        2. patch-b.txt
          0.9 kB
          Hartmut Holzgraefe

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              hholzgra Hartmut Holzgraefe
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: