Re: null value in column violates not-null constraint

On Thursday 25 May 2017 04:19:56 Ismail Sarenkapic wrote:

> Hi, I'm trying to create a digital marketplace site where users will

> be able to register and submit their products.

> I created the Product model and connected it with User with foreign

> key.Everything seems to be alright, but when I submit my product i

> get the following error:

>

> null value in column violates not-null constraint

> it looks like relation between product and user is not properly

> configured(regardless of my mixin that is suppose to handle it)

 

> class Product(models.Model):

> seller = models.ForeignKey(settings.AUTH_USER_MODEL)

> #user = models.OneToOneField(settings.AUTH_USER_MODEL)

> # user = models.ForeignKey(settings.AUTH_USER_MODEL)

> # managers = models.ManyToManyField(settings.AUTH_USER_MODEL,

> related_name="managers_products", blank=True) title =

> models.CharField(max_length=30)

> #owiuerpoajsdlfkjasd;flkiu1p3o4u134123 ewjfa;sd slug =

> models.SlugField(blank=True, unique=True)

> description = models.TextField()

> price = models.DecimalField(max_digits=100, decimal_places=2,

> default=9.99, null=True,) #100.00

 

 

> class ProductModelForm(forms.ModelForm):

> class Meta:

> model = Product

> fields = [

> "title",

> "description",

> "price",

> ]

 

seller is not in the model form and FormUserNeededMixin doesn't change that. The user field is commented out in your model so this error and the quoted code are not in sync.

 

But it could also be the slug. Without more of the error message it's hard to tell.

--

Melvyn Sopacua