Install fails: Can not create table
On install get this error. Civi 5.24.4 Drupal 7.70 PHP 7.2
#0 /home//public_html/sites/all/modules/civicrm/CRM/Admin/Form/Extensions.php(173): civicrm_api3("Extension", "install", (Array:2)) #1 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Core/Form.php(479): CRM_Admin_Form_Extensions->postProcess() #2 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Core/StateMachine.php(144): CRM_Core_Form->mainProcess() #3 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php(45): CRM_Core_StateMachine->perform(Object(CRM_Admin_Form_Extensions), "next", "Next") #4 (closed) /home//public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php(203): CRM_Core_QuickForm_Action_Next->perform(Object(CRM_Admin_Form_Extensions), "next") #5 (closed) /home//public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php(103): HTML_QuickForm_Controller->handle(Object(CRM_Admin_Form_Extensions), "next") #6 /home//public_html/sites/all/modules/civicrm/CRM/Core/Controller.php(335): HTML_QuickForm_Page->handle("next") #7 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Core/Page/Basic.php(395): CRM_Core_Controller->run() #8 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Core/Page/Basic.php(140): CRM_Core_Page_Basic->edit(1, NULL) #9 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Admin/Page/Extensions.php(105): CRM_Core_Page_Basic->run() #10 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(311): CRM_Admin_Page_Extensions->run((Array:3), NULL) #11 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(68): CRM_Core_Invoke::runItem((Array:16)) #12 (closed) /home//public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php(36): CRM_Core_Invoke::_invoke((Array:3)) #13 (closed) /home//public_html/sites/all/modules/civicrm/drupal/civicrm.module(456): CRM_Core_Invoke::invoke((Array:3)) #14 /home//public_html/includes/menu.inc(527): civicrm_invoke("admin", "extensions") #15 (closed) /home//public_html/index.php(21): menu_execute_active_handler() #16 (closed) {main}
May 28 14:33:09 [error] $Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler )
[code] => -15
[message] => DB Error: can not create
[mode] => 16
[debug_info] => CREATE TABLE `civicrm_data_processor_output` (
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique DataProcessorOutput ID',
`data_processor_id` int unsigned NOT NULL COMMENT 'FK to Data Processor',
`type` varchar(255) NOT NULL ,
`configuration` text NULL ,
`permission` varchar(255) NULL ,
`api_entity` varchar(255) NULL ,
`api_action` varchar(255) NULL ,
`api_count_action` varchar(255) NULL
,
PRIMARY KEY (id
)
, CONSTRAINT FK_civicrm_data_processor_output_data_processor_id FOREIGN KEY (data_processor_id
) REFERENCES civicrm_data_processor
(id
) ON DELETE CASCADE
) ENGINE=InnoDB [nativecode=1005 ** Can't create table XXXXXXXXXX_civicrm
.civicrm_data_processor_output
(errno: 150 "Foreign key constraint is incorrectly formed")]
[type] => DB_Error
[user_info] => CREATE TABLE civicrm_data_processor_output
(
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique DataProcessorOutput ID',
`data_processor_id` int unsigned NOT NULL COMMENT 'FK to Data Processor',
`type` varchar(255) NOT NULL ,
`configuration` text NULL ,
`permission` varchar(255) NULL ,
`api_entity` varchar(255) NULL ,
`api_action` varchar(255) NULL ,
`api_count_action` varchar(255) NULL
,
PRIMARY KEY (id
)
, CONSTRAINT FK_civicrm_data_processor_output_data_processor_id FOREIGN KEY (data_processor_id
) REFERENCES civicrm_data_processor
(id
) ON DELETE CASCADE
) ENGINE=InnoDB [nativecode=1005 ** Can't create table XXXXX_civicrm
.civicrm_data_processor_output
(errno: 150 "Foreign key constraint is incorrectly formed")]
[to_string] => [db_error: message="DB Error: can not create" code=-15 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="CREATE TABLE civicrm_data_processor_output
(
`id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Unique DataProcessorOutput ID',
`data_processor_id` int unsigned NOT NULL COMMENT 'FK to Data Processor',
`type` varchar(255) NOT NULL ,
`configuration` text NULL ,
`permission` varchar(255) NULL ,
`api_entity` varchar(255) NULL ,
`api_action` varchar(255) NULL ,
`api_count_action` varchar(255) NULL
,
PRIMARY KEY (id
)
, CONSTRAINT FK_civicrm_data_processor_output_data_processor_id FOREIGN KEY (data_processor_id
) REFERENCES civicrm_data_processor
(id
) ON DELETE CASCADE
) ENGINE=InnoDB [nativecode=1005 ** Can't create table XXXXXXXXX_civicrm
.civicrm_data_processor_output
(errno: 150 "Foreign key constraint is incorrectly formed")]"]
)