[solved] Setup stuck on Create database…?

[Anonymous]

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.

[Anonymous]

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)

[Michał Nowacki – Mint Team]

Hi, sorry, but your MySQL and PHP versions are not supported. We support only MySQL 5.7 and PHP 7.1.
Best regards!

[Author]

Posts