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

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
loxawadi
Registered User
Posts: 63
Joined: Tue Jan 05, 2016 3:14 am

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

Post by loxawadi » Wed May 24, 2017 7:38 am

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

User avatar
Puchahawa
Registered User
Posts: 768
Joined: Sat Jan 01, 2011 10:33 pm
Name: Randy

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

Post by Puchahawa » Wed May 24, 2017 4:07 pm

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. :)
Avatar courtesy of artist Faith Coyotë

loxawadi
Registered User
Posts: 63
Joined: Tue Jan 05, 2016 3:14 am

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

Post by loxawadi » Thu May 25, 2017 3:26 am

Thanks mate. It's ok now.

Post Reply

Return to “[3.2.x] Support Forum”