Author Topic: multi-site civicrm_add_domain.mysql fails on civicrm_payment_processor_type (Read 2590 times)

karunadave · August 30, 2007, 10:05:07 pm

The feature that allows multiple instances CiviCRM in one database using the domain attribute is broken for 1.8.

This is because the civicrm_add_domain.mysql query attempts to repeat values in 'civicrm_payment_processor_type.name', for each domain added, however this column has a unique constraint ( UNIQUE KEY `UI_name` (`name`),).

Piotr Szotkowski · August 31, 2007, 03:30:21 am

Thanks for catching this. I filed CRM-2245 and fixed this on the v1.9 branch.

For CiviCRM 1.8, the best solution is to drop the existing UNIQUE INDEX and create the new one (consisting of name and domain_id):

Code: [Select]

DROP INDEX UI_name ON civicrm_payment_processor_type;
CREATE UNIQUE INDEX UI_name_domain_id ON civicrm_payment_processor_type (name, domain_id);

CiviCRM Community Forums (archive)

News:

Author Topic: multi-site civicrm_add_domain.mysql fails on civicrm_payment_processor_type (Read 2590 times)

karunadave

multi-site civicrm_add_domain.mysql fails on civicrm_payment_processor_type

Piotr Szotkowski

Re: multi-site civicrm_add_domain.mysql fails on civicrm_payment_processor_type