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

Installation procedure relies on contiguous auto increment ids

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 3.4.0
    • Fix Version/s: Unscheduled
    • Component/s: Core CiviCRM
    • Labels:
      None

      Description

      The installation procedure, with sample data turned off, was observed for 4.0b3-drupal attempts to specify contiguous ids in auto-increment fields, which fails when using auto-increment offsets as required for some database replication methods (see http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html). This was tested on dual master-master replication configuration where one server is allocated odd auto-increments, and the other is allocated even auto-increments.

      eg INSERT INTO civicrm_uf_field (id, uf_group_id, field_name, is_required, is_reserved, weight, visibility, in_selector, is_searchable, location_type_id, label, field_type, help_post, phone_type_id ) VALUES (1, 1.. etc

      It is highly likely this bug is present in other releases

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              stefan Stefan
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: