Error Code: 1231

Question

I get an error with the NO_AUTO_CREATE_USER in the parameters. It works fine without that parameter.

Some Google sleuthing leads me to think that parameter is not valid/accepted in newer versions of SQL and should be removed.

Answer 1

Hi Zachary!
Thanks for reaching out!

This error relates to the settings of MySQL that may project in different errors when trying to run some of the queries.
Hence, please just execute the following query, and then retry. Thank you.
SET @@session.sql_mode = 'NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

If yes, then do you still get this Error Code: 1231?

Looking forward to your answer.
Best,
Tsvetelin

Answer 2

I execcute the following
SET SESSION sql_mode = 'STRICT_TRANS_TABLES, NO_ZERO_DATE, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION' ;
and I got
Error Code: 1231. Variable 'sql_mode' can't be set to the value of ' NO_ZERO_DATE'
Error Code: 1231. Variable 'sql_mode' can't be set to the value of ' NO_AUTO_CREATE_USER'

Then I try to execute the following query, and then retry.
SET @@session.sql_mode = 'NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
I still get this Error Code: 1231

Answer 3

Hi, I get the same error after executing:

SET @@session.sql_mode = 'NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

/*here I get a warning */

SET SESSION sql_mode='STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

/*Error Code: 1231. Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
*/

I'll appreciate your assistance

Answer 4

I also get the error when trying:

SET GLOBAL sql_mode='STRICT_TRANS_TABLES,NO_ZERO_DATE,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';

/*Error Code: 1231. Variable 'sql_mode' can't be set to the value of 'NO_AUTO_CREATE_USER'
*/

Thanks for your help

Error Code: 1231

Submit an answer

related questions