Fatal error : Database error

[Mohamet2s]

what do you think about this could someone help me solve this suitecrm installation problem on windows 10 server wamp64: (suitecrm.log)

Wed Jun 9 16:12:50 2021 [2432][-none-][FATAL] Mysqli_query failed.
Wed Jun 9 16:12:50 2021 [2432][-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: La clé est trop longue. Longueur maximale: 1000

[geofreygachie]

I am experiencing the same issue . I have tried quick rebuild and repair i am getting a database error .Please advsie if you got a solution .

SQL error 1932: Table ‘suitecrm.schedulers’ doesn’t exist in engine
Mon Jun 14 07:29:02 2021 [39502][1][FATAL] Mysqli_query failed.
Mon Jun 14 07:29:02 2021 [39502][1][FATAL] Query Failed: SELECT id FROM job_queue WHERE execute_time <= ‘2021-06-14 07:29:02’ AND status = ‘queued’ ORDER BY date_entered ASC LIMIT 0,1: MySQL error 1712: Index job_queue is corrupted
Mon Jun 14 07:29:02 2021 [39502][1][FATAL] Get One Failed:SELECT id FROM job_queue WHERE execute_time <= ‘2021-06-14 07:29:02’ AND status = ‘queued’ ORDER BY date_entered ASC: MySQL error 1712: Index job_queue is corrupted
Mon Jun 14 07:30:01 2021 [39519][1][FATAL] Mysqli_query failed.
Mon Jun 14 07:30:01 2021 [39519][1][FATAL] Query Failed: SELECT id FROM job_queue WHERE status=‘running’ AND date_modified <= ‘2021-06-13 07:30:01’: MySQL error 1712: Index job_queue is corrupted
Mon Jun 14 07:30:01 2021 [39519][1][FATAL] Mysqli_query failed.
Mon Jun 14 07:30:01 2021 [39519][1][FATAL] Query Failed: SELECT schedulers.* , jt0.user_name created_by_name , jt0.created_by created_by_name_owner , ‘Users’ created_by_name_mod , jt1.user_name modified_by_name , jt1.created_by modified_by_name_owner , ‘Users’ modified_by_name_mod FROM schedulers LEFT JOIN users jt0 ON jt0.id=schedulers.created_by AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON schedulers.modified_user_id=jt1.id AND jt1.deleted=0

[Mohamet2s]

Hi, I had proceeded to the same solution while trying to repair the code. but nothing to do with error, finally I downloaded an older version of wamp64 server and everything is back to normal, I believe this error is due to the compatibility problem between the new version of MSQL of wamp64 and that of SuiteCRM

[Moin_189]

Hello, I Phase fatal error using Xampp server… Kindly help me to solve this problem…

!