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 »

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 »

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 »

Thanks mate. It's ok now.

Post Reply

Return to “[3.2.x] Support Forum”