ER_WRONG_VALUE_FOR_VAR: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

[dotnetprofessional]

I'm getting the following error when running:

source ../env.sh ;node index.js

ER_WRONG_VALUE_FOR_VAR: Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'

I'm running on Windows and your setup seem tailored to Linux.

[roryscot]

@dotnetprofessional

1. open api/index.js and

2. find
   db.query(` SET sql_mode = "STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" `);
   around line 91;

3. Delete NO_AUTO_CREATE_USER from the query value

[username7171]

@roryscot it works thanks!