MySQL Error
#6

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
Disable NO_ZERO_DATE sql mode in my.ini/my.cnf
Quote:
Originally Posted by ikkentim
Посмотреть сообщение
It might be "NO_ZERO_IN_DATE" is set in your config, not allowing zero date values. You could change your config, use the default value of NULL (if the column is nullable) or use the unix epoch instead.



Please don't do this
I still have the same problem. I'm not sure if I disabled NO_ZERO_DATE.

This is how I disabled it. I entered my.ini, then found line with
PHP код:
;sql-mode="ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
And changed it to
PHP код:
;sql-mode="" 
Is that the correct way to disable it?
Reply


Messages In This Thread
MySQL Error - by SelfiMaster - 27.03.2017, 12:16
Re: MySQL Error - by SelfiMaster - 27.03.2017, 13:49
Re: MySQL Error - by Konstantinos - 27.03.2017, 13:53
Re: MySQL Error - by iLearner - 27.03.2017, 13:54
Re: MySQL Error - by ikkentim - 27.03.2017, 13:57
Re: MySQL Error - by SelfiMaster - 27.03.2017, 14:38
Re: MySQL Error - by SelfiMaster - 27.03.2017, 15:09
Re: MySQL Error - by Unte99 - 27.03.2017, 15:54

Forum Jump:


Users browsing this thread: 1 Guest(s)