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