Hello,
I am getting this problem while installing 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