Need help, error on instalation

SuiteCRM Forum - English Language
1

Hi, I’m new and as it’s new I have trouble. You will help me with the installation. I come to the moment of connecting to the base and I get this error, what is it about because I do not understand it completely. Thank you in advance for your help.

Fatal error: Uncaught exception ‘Exception’ with message ‘Database error. Please check suitecrm.log for details.’ in D:\Inetpub\webs\5015_web\www\CRM\include\utils.php:1892 Stack trace: #0 D:\Inetpub\webs\5015_web\www\CRM\include\database\DBManager.php(355): sugar_die(‘Database error…’) #1 D:\Inetpub\webs\5015_web\www\CRM\include\database\DBManager.php(328): DBManager->registerError(‘Error creating …’, ‘MySQL error 107…’, true) #2 D:\Inetpub\webs\5015_web\www\CRM\include\database\MysqliManager.php(179): DBManager->checkError(‘Error creating …’, true) #3 D:\Inetpub\webs\5015_web\www\CRM\include\database\DBManager.php(676): MysqliManager->query(‘CREATE TABLE us…’, true, ‘Error creating …’) #4 D:\Inetpub\webs\5015_web\www\CRM\data\SugarBean.php(2171): DBManager->createTable(Object(Group)) #5 D:\Inetpub\webs\5015_web\www\CRM\install\install_utils.php(1283): SugarBean->create_tables() #6 D:\Inetpub\webs\5015_web\www\CRM\install\performSetup.php(281): create_table_if_not_exist(Object(Group)) #7 D:\Inetpub\webs\5015 in D:\Inetpub\webs\5015_web\www\CRM\include\utils.php on line 1892

2

Hi,
the message states where additional details can be found:

You find this file in the suite directory directly. Pls copy the respective error message and post it here, maybe you can also add which crm version you’re about to install and which php/mysql-versions you use.

3

Hi. Unfortunately, my PHP version is 5.6.40, I can’t have another one. Mysql database version 8.0.23-14
My first problem was this - Can't continue install--must set fastcgi.logging to 0 but managed to move on. The suitcrm log probably contains more data because I tried to install the program 2-3 times more.
Log suitcrm

09/23/21 15:44:50 [33072][-none-][FATAL] Mysqli_query failed.
09/23/21 15:44:50 [33072][-none-][FATAL] Error creating table: users: Query Failed: CREATE TABLE users (id char(36) NOT NULL ,user_name varchar(60) NULL ,user_hash varchar(255) NULL ,system_generated_password bool NULL ,pwd_last_changed datetime NULL ,authenticate_id varchar(100) NULL ,sugar_login bool DEFAULT ‘1’ NULL ,first_name varchar(255) NULL ,last_name varchar(255) NULL ,is_admin bool DEFAULT ‘0’ NULL ,external_auth_only bool DEFAULT ‘0’ NULL ,receive_notifications bool DEFAULT ‘1’ NULL ,description text NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,title varchar(50) NULL ,photo varchar(255) NULL ,department varchar(50) NULL ,phone_home varchar(50) NULL ,phone_mobile varchar(50) NULL ,phone_work varchar(50) NULL ,phone_other varchar(50) NULL ,phone_fax varchar(50) NULL ,status varchar(100) NULL ,address_street varchar(150) NULL ,address_city varchar(100) NULL ,address_state varchar(100) NULL ,address_country varchar(100) NULL ,address_postalcode varchar(20) NULL ,deleted bool NULL ,portal_only bool DEFAULT ‘0’ NULL ,show_on_employees bool DEFAULT ‘1’ NULL ,employee_status varchar(100) NULL ,messenger_id varchar(100) NULL ,messenger_type varchar(100) NULL ,reports_to_id char(36) NULL ,is_group bool NULL ,factor_auth bool NULL ,factor_auth_interface varchar(255) NULL , PRIMARY KEY (id), KEY idx_user_name (user_name, is_group, status, last_name, first_name, id)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1071: Specified key was too long; max key length is 1000 bytes
09/23/21 15:48:08 [33072][-none-][FATAL] Mysqli_query failed.
09/23/21 15:48:08 [33072][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘a4961.currencies’ doesn’t exist
09/23/21 15:48:08 [33072][-none-][FATAL] Mysqli_query failed.
09/23/21 15:48:08 [33072][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Users’ AND deleted = 0: MySQL error 1146: Table ‘a4961.fields_meta_data’ doesn’t exist
09/23/21 15:48:08 [33072][-none-][FATAL] Mysqli_query failed.
09/23/21 15:48:08 [33072][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Employees’ AND deleted = 0: MySQL error 1146: Table ‘a4961.fields_meta_data’ doesn’t exist
09/23/21 15:48:08 [33072][-none-][FATAL] Mysqli_query failed.
09/23/21 15:48:08 [33072][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘UserPreferences’ AND deleted = 0: MySQL error 1146: Table ‘a4961.fields_meta_data’ doesn’t exist
09/23/21 15:48:08 [33072][-none-][FATAL] Mysqli_query failed.
09/23/21 15:48:08 [33072][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Administration’ AND deleted = 0: MySQL error 1146: Table ‘a4961.fields_meta_data’ doesn’t exist
09/23/21 15:48:08 [33072][-none-][FATAL] Mysqli_query failed.
09/23/21 15:48:08 [33072][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘a4961.config’ doesn’t exist
09/23/21 16:44:23 [26980][-none-][FATAL] Mysqli_query failed.
09/23/21 16:44:23 [26980][-none-][FATAL] Error creating table: users: Query Failed: CREATE TABLE users (id char(36) NOT NULL ,user_name varchar(60) NULL ,user_hash varchar(255) NULL ,system_generated_password bool NULL ,pwd_last_changed datetime NULL ,authenticate_id varchar(100) NULL ,sugar_login bool DEFAULT ‘1’ NULL ,first_name varchar(255) NULL ,last_name varchar(255) NULL ,is_admin bool DEFAULT ‘0’ NULL ,external_auth_only bool DEFAULT ‘0’ NULL ,receive_notifications bool DEFAULT ‘1’ NULL ,description text NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,title varchar(50) NULL ,photo varchar(255) NULL ,department varchar(50) NULL ,phone_home varchar(50) NULL ,phone_mobile varchar(50) NULL ,phone_work varchar(50) NULL ,phone_other varchar(50) NULL ,phone_fax varchar(50) NULL ,status varchar(100) NULL ,address_street varchar(150) NULL ,address_city varchar(100) NULL ,address_state varchar(100) NULL ,address_country varchar(100) NULL ,address_postalcode varchar(20) NULL ,deleted bool NULL ,portal_only bool DEFAULT ‘0’ NULL ,show_on_employees bool DEFAULT ‘1’ NULL ,employee_status varchar(100) NULL ,messenger_id varchar(100) NULL ,messenger_type varchar(100) NULL ,reports_to_id char(36) NULL ,is_group bool NULL ,factor_auth bool NULL ,factor_auth_interface varchar(255) NULL , PRIMARY KEY (id), KEY idx_user_name (user_name, is_group, status, last_name, first_name, id)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1071: Specified key was too long; max key length is 1000 bytes
09/23/21 16:50:40 [26980][-none-][FATAL] Could not connect to DB server localhost as a4961. port : No connection could be made because the target machine actively refused it.

09/23/21 16:52:31 [26980][-none-][FATAL] Mysqli_query failed.
09/23/21 16:52:31 [26980][-none-][FATAL] Error creating table: users: Query Failed: CREATE TABLE users (id char(36) NOT NULL ,user_name varchar(60) NULL ,user_hash varchar(255) NULL ,system_generated_password bool NULL ,pwd_last_changed datetime NULL ,authenticate_id varchar(100) NULL ,sugar_login bool DEFAULT ‘1’ NULL ,first_name varchar(255) NULL ,last_name varchar(255) NULL ,is_admin bool DEFAULT ‘0’ NULL ,external_auth_only bool DEFAULT ‘0’ NULL ,receive_notifications bool DEFAULT ‘1’ NULL ,description text NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,title varchar(50) NULL ,photo varchar(255) NULL ,department varchar(50) NULL ,phone_home varchar(50) NULL ,phone_mobile varchar(50) NULL ,phone_work varchar(50) NULL ,phone_other varchar(50) NULL ,phone_fax varchar(50) NULL ,status varchar(100) NULL ,address_street varchar(150) NULL ,address_city varchar(100) NULL ,address_state varchar(100) NULL ,address_country varchar(100) NULL ,address_postalcode varchar(20) NULL ,deleted bool NULL ,portal_only bool DEFAULT ‘0’ NULL ,show_on_employees bool DEFAULT ‘1’ NULL ,employee_status varchar(100) NULL ,messenger_id varchar(100) NULL ,messenger_type varchar(100) NULL ,reports_to_id char(36) NULL ,is_group bool NULL ,factor_auth bool NULL ,factor_auth_interface varchar(255) NULL , PRIMARY KEY (id), KEY idx_user_name (user_name, is_group, status, last_name, first_name, id)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1071: Specified key was too long; max key length is 1000 bytes
09/23/21 17:42:23 [28244][-none-][FATAL] Mysqli_query failed.
09/23/21 17:42:23 [28244][-none-][FATAL] Error creating table: users: Query Failed: CREATE TABLE users (id char(36) NOT NULL ,user_name varchar(60) NULL ,user_hash varchar(255) NULL ,system_generated_password bool NULL ,pwd_last_changed datetime NULL ,authenticate_id varchar(100) NULL ,sugar_login bool DEFAULT ‘1’ NULL ,first_name varchar(255) NULL ,last_name varchar(255) NULL ,is_admin bool DEFAULT ‘0’ NULL ,external_auth_only bool DEFAULT ‘0’ NULL ,receive_notifications bool DEFAULT ‘1’ NULL ,description text NULL ,date_entered datetime NULL ,date_modified datetime NULL ,modified_user_id char(36) NULL ,created_by char(36) NULL ,title varchar(50) NULL ,photo varchar(255) NULL ,department varchar(50) NULL ,phone_home varchar(50) NULL ,phone_mobile varchar(50) NULL ,phone_work varchar(50) NULL ,phone_other varchar(50) NULL ,phone_fax varchar(50) NULL ,status varchar(100) NULL ,address_street varchar(150) NULL ,address_city varchar(100) NULL ,address_state varchar(100) NULL ,address_country varchar(100) NULL ,address_postalcode varchar(20) NULL ,deleted bool NULL ,portal_only bool DEFAULT ‘0’ NULL ,show_on_employees bool DEFAULT ‘1’ NULL ,employee_status varchar(100) NULL ,messenger_id varchar(100) NULL ,messenger_type varchar(100) NULL ,reports_to_id char(36) NULL ,is_group bool NULL ,factor_auth bool NULL ,factor_auth_interface varchar(255) NULL , PRIMARY KEY (id), KEY idx_user_name (user_name, is_group, status, last_name, first_name, id)) CHARACTER SET utf8 COLLATE utf8_general_ci: MySQL error 1071: Specified key was too long; max key length is 1000 bytes
09/23/21 17:51:06 [28244][-none-][FATAL] Mysqli_query failed.
09/23/21 17:51:06 [28244][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘a4961.currencies’ doesn’t exist
09/23/21 17:51:06 [28244][-none-][FATAL] Mysqli_query failed.
09/23/21 17:51:06 [28244][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Users’ AND deleted = 0: MySQL error 1146: Table ‘a4961.fields_meta_data’ doesn’t exist
09/23/21 17:51:06 [28244][-none-][FATAL] Mysqli_query failed.
09/23/21 17:51:06 [28244][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Employees’ AND deleted = 0: MySQL error 1146: Table ‘a4961.fields_meta_data’ doesn’t exist
09/23/21 17:51:06 [28244][-none-][FATAL] Mysqli_query failed.
09/23/21 17:51:06 [28244][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘UserPreferences’ AND deleted = 0: MySQL error 1146: Table ‘a4961.fields_meta_data’ doesn’t exist
09/23/21 17:51:06 [28244][-none-][FATAL] Mysqli_query failed.
09/23/21 17:51:06 [28244][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=‘Administration’ AND deleted = 0: MySQL error 1146: Table ‘a4961.fields_meta_data’ doesn’t exist
09/23/21 17:51:06 [28244][-none-][FATAL] Mysqli_query failed.
09/23/21 17:51:06 [28244][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘a4961.config’ doesn’t exist

4

And what version of Suite are you using? Mysql v8 is only supported for Suite 7.11.16 and above (maybe therefore the many sql errors?).

5

My version to 7.11.21
Where can I download then 7.11.16

6

Hey, you can find here:

7

your version is higher than the mentioned one, so the current version should be compatible.

8

Thank you very much for your help, I will let you know if everything went well.

9

Fatal error: Call to undefined function check_php_version() in D:\Inetpub\webs\5015_web\www\CRM\install.php on line 64
Now is that when im start proces instalation

11

This is the problem. It creates an index of username,firstname,lastname and user hash. They are way too large and go beyond 1000 bytes.

I don’t know how you deal with this on a new install, but I just had this problem on a couple of my installs when doing upgrades. I had to change the field lengths in PHPMYAdmin to way less. Firstname =30 lastname = 30 username=30 and user hash to 100 (from 256). That allowed the index to get created at less than 1000 bytes. Oh I also had to change the Vardefs to match.