I tried to install for test purposes a clean 7.11.18 version by using utf8mb4 collation and the install stopped creating the fourth database table with the following error message
…Database error. Please check suitecrm.log for details.
suitecrm.log says:
Tue Apr 27 13:07:07 2021 [116044][-none-][FATAL] Mysqli_query failed.
Tue Apr 27 13:07:07 2021 [116044][-none-][FATAL] Error creating table: leads: Query Failed: CREATE TABLE leads (id
char(36) NOT NULL ,date_entered
datetime NULL ,date_modified
datetime NULL ,modified_user_id
char(36) NULL ,created_by
char(36) NULL ,description
text NULL ,deleted
bool DEFAULT ‘0’ NULL ,assigned_user_id
char(36) NULL ,salutation
varchar(255) NULL ,first_name
varchar(100) NULL ,last_name
varchar(100) NULL ,title
varchar(100) NULL ,photo
varchar(255) NULL ,department
varchar(100) NULL ,do_not_call
bool DEFAULT ‘0’ NULL ,phone_home
varchar(100) NULL ,phone_mobile
varchar(100) NULL ,phone_work
varchar(100) NULL ,phone_other
varchar(100) NULL ,phone_fax
varchar(100) NULL ,lawful_basis
text(100) NULL ,date_reviewed
date NULL ,lawful_basis_source
varchar(100) NULL ,primary_address_street
varchar(150) NULL ,primary_address_city
varchar(100) NULL ,primary_address_state
varchar(100) NULL ,primary_address_postalcode
varchar(20) NULL ,primary_address_country
varchar(255) NULL ,alt_address_street
varchar(150) NULL ,alt_address_city
varchar(100) NULL ,alt_address_state
varchar(100) NULL ,alt_address_postalcode
varchar(20) NULL ,alt_address_country
varchar(255) NULL ,assistant
varchar(75) NULL ,assistant_phone
varchar(100) NULL ,converted
bool DEFAULT ‘0’ NULL ,refered_by
varchar(100) NULL ,lead_source
varchar(100) NULL ,lead_source_description
text NULL ,status
varchar(100) NULL ,status_description
text NULL ,reports_to_id
char(36) NULL ,account_name
varchar(255) NULL ,account_description
text NULL ,contact_id
char(36) NULL ,account_id
char(36) NULL ,opportunity_id
char(36) NULL ,opportunity_name
varchar(255) NULL ,opportunity_amount
varchar(50) NULL ,campaign_id
char(36) NULL ,birthdate
date NULL ,portal_name
varchar(255) NULL ,portal_app
varchar(255) NULL ,website
varchar(255) NULL , PRIMARY KEY (id), KEY idx_lead_acct_name_first (account_name, deleted), KEY idx_lead_last_first (last_name, first_name, deleted), KEY idx_lead_del_stat (last_name, status, deleted, first_name), KEY idx_lead_opp_del (opportunity_id, deleted), KEY idx_leads_acct_del (account_id, deleted), KEY idx_del_user (deleted, assigned_user_id), KEY idx_lead_assigned (assigned_user_id), KEY idx_lead_contact (contact_id), KEY idx_reports_to (reports_to_id), KEY idx_lead_phone_work (phone_work), KEY idx_leads_id_del (id, deleted)) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: MySQL error 1709: Index column size too large. The maximum column size is 767 bytes.
Is this problem caused by the ISP?