Fatal Error in installing suitecrm 7.12 : MySQL error 1071: La clé est trop longue. Longueur maximale: 1000

Hello,
I am getting this problem while installing :slight_smile: suitecrm 7.12
on windows 10 and Wampserver 64.320 / MySql 5.7.28

( ! ) Fatal error: Uncaught Exception: Database error. Please check suitecrm.log for details. in C:\wamp64_320\www\suitecrm712\include\utils.php on line 1920
( ! ) Exception: Database error. Please check suitecrm.log for details. in C:\wamp64_320\www\suitecrm712\include\utils.php on line 1920
Call Stack

Time Memory Function Location

1 0.0001 434632 {main}( ) …\install.php**:0
2 0.1523 2002200 require( ‘C:\wamp64_320\www\suitecrm712\install\performSetup.php’ ) …\install.php
:827
3 5.4317 6437704 create_table_if_not_exist( ) …\performSetup.php
:281
4 5.4329 6437376 Lead->create_tables( ) …\install_utils.php
:1283
5 5.4338 6437376 MysqliManager->createTable( ) …\SugarBean.php
:2164
6 5.4362 6439992 MysqliManager->query( ) …\DBManager.php
:676
7 5.4381 6442984 MysqliManager->checkError( ) …\MysqliManager.php
:179
8 5.4381 6443080 MysqliManager->registerError( ) …\DBManager.php
:328
9 5.7815 6446152 sugar_die( ) …\DBManager.php
:**355

content of suitecrm file :
Sun Dec 5 10:50:13 2021 [18196][-none-][FATAL] Mysqli_query failed.
Sun Dec 5 10:50:13 2021 [18196][-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(80) NULL ,account_description text NULL ,contact_id char(36) NULL ,account_id char(36) NULL ,opportunity_id char(36) NULL ,opportunity_name varchar(100) NULL ,opportunity_amount varchar(50) NULL ,campaign_id char(36) NULL ,birthdate date NULL ,portal_name varchar(100) NULL ,portal_app varchar(100) NULL ,website varchar(80) 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 1071: La clé est trop longue. Longueur maximale: 1000

I found that my MySQL was configured to use by default MYISAM, I switched to INNODB.
The installation is now completed without failure.

1 Like