Wiki: Fresh install with MySQL 8 on setup page cannot continue You have an error in your SQL syntax;

Created on 14 Nov 2019  路  1Comment  路  Source: Requarks/wiki

Describe the bug
Fresh install of 2b. RC.17
On the setup screen after entering email and desired password I get:

ALTER TABLE groups AUTO_INCREMENT = 1 - 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 'groups AUTO_INCREMENT = 1' at line 1

and setup does not continue or complete.

2019-11-14_09-25-18

To Reproduce
Steps to reproduce the behavior:

  1. Fresh install and 1st step - complete setup.

Expected behavior
To complete setup

Screenshots
If applicable, add screenshots to help explain your problem.

Host Info (please complete the following information):

  • OS: CentOS
  • Wiki.js version: 2.0.0-beta.rc17
  • Database engine: MySQL v.8.0.18

Additional context

  • No issues or error messagges during starting the node server - Successfully connected to the database.
  • Using "mysql_native_password"
  • Tried with 2 fresh different databases and users

Most helpful comment

This is fixed in 2.0.1

>All comments

This is fixed in 2.0.1

Was this page helpful?
0 / 5 - 0 ratings

Related issues

sleepadru picture sleepadru  路  4Comments

SharkProgramming picture SharkProgramming  路  4Comments

sbonaime picture sbonaime  路  3Comments

ramirahikkala picture ramirahikkala  路  3Comments

LionNatsu picture LionNatsu  路  3Comments