Hi,
We developed a custom module with a simple list/recordview. Nothing to fancy. We would like to install it on a customer's site but for some reason when we install it the installation failes with 'database failure'. When looking in the logs we can see the following:
[10226][1][ALERT] Query Failed: ALTER TABLE af_configurator_audit ADD CONSTRAINT PRIMARY KEY (id), ADD INDEX idx_af_configurator_audit_parent_id (parent_id), ADD INDEX idx_af_configurator_audit_event_id (event_id), ADD INDEX idx_af_configurator_audit_pa_ev_id (parent_id,event_id), ADD INDEX idx_af_configurator_audit_after_value (after_value_string): MySQL error 1068: Multiple primary key defined
So checked the database and the table was indeed created with the specified keys. So I tried it again on a clean database where these tables don't exist and we get the exact same error.
Has anyone seen this behaviour before? and if so what can we do about it? This module installed perfectly on other instances (cloud or onpremise).