Page 1 of 1

Field 'user_id' doesn't have a default value [1364]

Posted: Wed May 24, 2017 7:38 am
by loxawadi
Hi guy

I uploaded phpbb from local host to my host. Everything is OK now but admin can not login and new member cannot register. it shows error:

SQL ERROR [ mysqli ]

Field 'user_id' doesn't have a default value [1364]

Plz help
Tks

Re: Field 'user_id' doesn't have a default value [1364]

Posted: Wed May 24, 2017 4:07 pm
by Puchahawa
This article deals with the 1364 error. It has the info for 3.0x the same info applies to 3.1x but a different php file.

You can find the php file referenced in the article for 3.1x here.

Hopefully some of the helpful members here can fill in any details you may need. :)

Re: Field 'user_id' doesn't have a default value [1364]

Posted: Thu May 25, 2017 3:26 am
by loxawadi
Thanks mate. It's ok now.