MyBB Community Forums

Dear sir when any user try to register "SQL Error:1364 - Field 'newpoints_items' doesn't have a default value
" got this error msg.
before 10may2017 forum working fine and user can register without any problem.

I disabled some plugins but its not working

forum software up to date.

Apache Version - 2.4.25
PHP Version - 5.5.38
MySQL Version - 5.6.35

Okay, Try this Search Reults

the error might be caused by your newpoints plugin, maybe if you remove the newpoints.php file, that will fix the error? See if that works, then Try reinstalling the newpoints php file.
Maybe, it is worth a try.

Try deleting the whole plugin and re-download it and install it.

https://community.mybb.com/mods.php?action=view&pid=94

basically the error is caused by strict mode of MySQL. you may ask web host to disable it.

(2017-05-21, 02:51 AM).m. Wrote: [ -> ]basically the error is caused by strict mode of MySQL. you may ask web host to disable it.

Thanks for the help and fast reply.
At this time I fixed the issue.
Changed plugin default value none to null in  phpmyadmin.
Thanks again all of you.

(2017-05-21, 05:59 AM)Tim0n Wrote: [ -> ]

(2017-05-21, 02:51 AM).m. Wrote: [ -> ]basically the error is caused by strict mode of MySQL. you may ask web host to disable it.

Thanks for the help and fast reply.
At this time I fixed the issue.
Changed plugin default value none to null in  phpmyadmin.
Thanks again all of you.

How do I change that?

(2017-05-21, 02:12 AM)Brian. Wrote: [ -> ]Try deleting the whole plugin and re-download it and install it.

https://community.mybb.com/mods.php?action=view&pid=94

Too old reply but even so, this isn't the best advice.

(2019-01-30, 11:58 AM)xics Wrote: [ -> ]

(2017-05-21, 05:59 AM)Tim0n Wrote: [ -> ]

(2017-05-21, 02:51 AM).m. Wrote: [ -> ]basically the error is caused by strict mode of MySQL. you may ask web host to disable it.

Thanks for the help and fast reply.
At this time I fixed the issue.
Changed plugin default value none to null in  phpmyadmin.
Thanks again all of you.

How do I change that?

Based on your knowledge, you can find useful information using the search feature or search engines.
https://www.oreilly.com/library/view/mys...08s05.html
https://stackoverflow.com/questions/3023...phpmyadmin

MyBB forum:
https://community.mybb.com/thread-44380.html
https://community.mybb.com/thread-154553...pid1078933

Remove the newpoints shop plugin and fixed