Error creating table, Query Failed, CREATE TABLE MySQL error 1064: You have an error in your SQL syntax after stage 2 of 2

📦 Install & Upgrade Help
1

MySQL error received at the end of setup configuration stage 2 of 2:

Untitled
Untitled1244×233 19.8 KB

Told to check suitecrm.log for details and here’s the full contents of that file:

Sun Sep 6 07:52:00 2020 [22983][-none-][FATAL] SugarBean::populateDefaultValues $field_defs should be an array
Sun Sep 6 07:52:00 2020 [22983][-none-][FATAL] “name” field does not exists in field definition.
Sun Sep 6 07:52:00 2020 [22983][-none-][FATAL] Mysqli_query failed.
Sun Sep 6 07:52:00 2020 [22983][-none-][FATAL] Error creating table: : Query Failed: CREATE TABLE ( NULL ) CHARACTER SET utf8 COLLATE utf8_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 ‘( NULL ) CHARACTER SET utf8 COLLATE utf8_general_ci’ at line 1

2

Hi and welcome!
which version of Suite/mysql are you using?

3

Hi diligent, thank you for the welcome and thanks for the response.

I’m running SuiteCRM 7.11.15 pulled from github as of a few hours ago and MySQL Server version: 8.0.21-0ubuntu0.20.04.4 (Ubuntu).

4

Hi,
then I would suggest downgrading your MySQL installation first:

-> Highest supported MySQL version is 5.7

1 Like
5

Excellent suggestion. That fixed the problem. Many thanks for the speedy response.