[DeaMaree]

I would really like to use MintHCM, but I obviously cannot without the styling loading. Please advise.

[DeaMaree]

I tried what you suggested – first cleared cache directory contents and opened in private window – no change.
Deleted and reinstalled MintHCM. Still no styling. You can visit https://epdb.portal.argenttech.net/MintHCM to see.

[DeaMaree]

Is there a solution to this? I am having the same problem. PHP 7.1, MySQL 5.7

[DeaMaree]

Changed mySQL default engine to innodb. Still fails, but new errors.
“Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘argentte_mintdb.currencies’ doesn’t exist
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=’Users’ AND deleted = 0: MySQL error 1146: Table ‘argentte_mintdb.fields_meta_data’ doesn’t exist
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=’Employees’ AND deleted = 0: MySQL error 1146: Table ‘argentte_mintdb.fields_meta_data’ doesn’t exist
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=’UserPreferences’ AND deleted = 0: MySQL error 1146: Table ‘argentte_mintdb.fields_meta_data’ doesn’t exist
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Query Failed: SELECT * FROM fields_meta_data WHERE custom_module=’Administration’ AND deleted = 0: MySQL error 1146: Table ‘argentte_mintdb.fields_meta_data’ doesn’t exist
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:15 2022 [22064][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘argentte_mintdb.config’ doesn’t exist
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘argentte_mintdb.currencies’ doesn’t exist
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘argentte_mintdb.config’ doesn’t exist
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘argentte_mintdb.currencies’ doesn’t exist
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘argentte_mintdb.config’ doesn’t exist
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Query Failed: SELECT id, name, symbol, conversion_rate FROM currencies WHERE status = ‘Active’ and deleted = 0: MySQL error 1146: Table ‘argentte_mintdb.currencies’ doesn’t exist
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Mysqli_query failed.
Sat Mar 12 02:34:16 2022 [22064][-none-][FATAL] Unable to retrieve system settings Query Failed: SELECT category, name, value FROM config: MySQL error 1146: Table ‘argentte_mintdb.config’ doesn’t exist”

[DeaMaree]

Turned error reporting back on to see where the hangup is, get the following:
“Sat Mar 12 01:57:31 2022 [19099][-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(190), 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: Specified key was too long; max key length is 1000 bytes”

[DeaMaree]

Attempting to install version 3.1.1. Site PHP is 7.1. MySQL is Database client version: libmysql – 5.6.43. Even on 3.1.1 I have this same issue. Setup configures relationships ok, then hangs on “Create Database…” I let it run for several hours today and it never moved forward. It creates 3 tables in the database, then stalls. I have turned on zlib. I have turned off printing of the “notice” and “warning” errors. Please advise.

[Author]

Posts