[solved] Setup stuck on Create database…?
- This topic has 2 replies, 2 voices, and was last updated 5 years, 4 months ago by .
- The topic ‘[solved] Setup stuck on Create database…?’ is closed to new replies.
Home / Forums / Installing MintHCM / [solved] Setup stuck on Create database…?
Tagged: installation
I can get a login screen; in MySQL Workbench I see it has created tables. But it won’t accept my username/password. Reset won’t be able to email me because… I didn’t set that up beforehand! Should I just start the install all over again…?
Log file mentions “Error creating table: users_feeds Query Failed: CREATE TABLE users_feeds MySQL error 1064: error in SQL syntax near ‘rank int NULL,date_modified datetime
Sorry, stuck at work but can paste the log file in later. Thanks.
Wed Jun 9 19:01:35 2021 [17352][-none-][FATAL] Error creating table: users_feeds Query Failed: CREATE TABLE users_feeds (user_id varchar(36) NULL ,feed_id varchar(36) NULL ,rank int NULL ,date_modified datetime NULL ,deleted bool DEFAULT ‘0’ NULL , KEY idx_ud_user_id (user_id, feed_id)) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘rank int NULL ,date_modified datetime NULL ,deleted bool DEFAULT ‘0’ NULL , ‘ at line 1
(Apache 2.4.46, MySQL 8.0.22, PHP 7.4.15 running on Windows 10)
Hi, sorry, but your MySQL and PHP versions are not supported. We support only MySQL 5.7 and PHP 7.1.
Best regards!