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

Activity

1. roryscot commented on Jan 23, 2019

   

   roryscot

   on Jan 23, 2019

   Last edited by roryscot

   More actions

   @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

   👍React with 👍1Reacted by Majid
2. username7171 commented on Apr 8, 2020

   

   username7171

   on Apr 8, 2020

   More actions

   @roryscot it works thanks!