MySQL Error - Printable Version

MySQL Error - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Server (https://sampforum.blast.hk/forumdisplay.php?fid=6)
+--- Forum: Server Support (https://sampforum.blast.hk/forumdisplay.php?fid=19)
+--- Thread: MySQL Error (/showthread.php?tid=653620)

MySQL Error - Error1337 - 08.05.2018

HTML Code:

[17:13:24] [ERROR] CMySQLQuery::Execute - (error #1364) Field 'Spoiler' doesn't have a default value
[17:14:36] [ERROR] CMySQLQuery::Execute[OnPlayerRegisterMysql] - (error #1364) Field 'Exp' doesn't have a default value
[17:14:36] [ERROR] CMySQLQuery::Execute[] - (error #1364) Field 'City' doesn't have a default value
[17:14:37] [ERROR] CMySQLQuery::Execute[] - (error #1364) Field 'Data' doesn't have a default value

-_-

Re: MySQL Error - StefaNO [ITA] - 08.05.2018

Hello, https://www.w3schools.com/sql/sql_default.asp

Re: MySQL Error - GTLS - 15.05.2018

Just click a little tick mark in PhpMyadmin along with those columns, saying, NULL. This will allow a value to be NULL. Currently you are having that error cuz you probably has Not Null Ticked and as Default Value nothing.