On migrating in django project it shows and error

Question

` from django.db import models from .category import Category from multiselectfield import MultiSelectField

color_choices = ((1, 'red'),
                (2, 'Black'),
                (3, 'White'))


class Products(models.Model):
   image = models.ImageField(upload_to='uploads/product_images/', default='')
    category = models.ForeignKey(Category, on_delete=models.CASCADE, default=1)
    name = models.CharField(max_length=255, default="")
    price = models.FloatField(max_length=10, default=0)
    offer = models.CharField(max_length=30, default='')
    color = MultiSelectField(choices=color_choices, max_choices=3, max_length=3, 
 default=3)
    description = models.CharField(max_length=1052, default='')`

ERROR "ValueError: Field 'stock' expected a number but got 'UNAVAILABLE'." here I even removed the field 'stock ' from model but still getting error. It is not migrating..... What I do now? Please Help? models.py error admin.py

can you add your models.py file so we can see how the models are arranged — Sirwill98, Apr 27 '21 at 10:31
please copy the code using the supplied markup rather than a screenshot — Sirwill98, Apr 27 '21 at 10:34
very sorry to say I don't know how to add code but now uploaded screenshots you can see them. and please help, I am stuck for an hour. — Khaleeqain Services, Apr 27 '21 at 10:42
can you remove all the products from the db then try migrate, it seems like your db is expecting 1 value but the field stock has been given another — Sirwill98, Apr 27 '21 at 10:48
@Sirwill98 I removed all products and than migrated but still getting the error — Khaleeqain Services, Apr 27 '21 at 10:56
are you creating a product manually anywhere in the code? and is the error caused when you migrate? — Sirwill98, Apr 27 '21 at 10:58
No, I am creating products from admin panel of django and also removing from there. — Khaleeqain Services, Apr 27 '21 at 11:01
when you had stock in your model did you give it a default value? — Sirwill98, Apr 27 '21 at 11:15

score 0 · Accepted Answer · answered Apr 27 '21 at 11:20

0

The problem is from your original default being "unavailable" this cannot be used for an integer field.

You will need to delete the faulty migrations then update your model with the correct data type for the default e.g. 0 then run makemigrations and migrate

answered Apr 27 '21 at 11:20

Sirwill98

324
1
13

How can I remove faulty migrations....? – Khaleeqain Services Apr 27 '21 at 11:27
https://stackoverflow.com/questions/58000680/django-safely-remove-old-migrations you can follow this on how to remove faulty or oldmigrations – Sirwill98 Apr 27 '21 at 11:28
ok Let me try ..Thank you – Khaleeqain Services Apr 27 '21 at 11:31
if it was what you were looking for please mark it as answered so anyone in the future can use this to help them too – Sirwill98 Apr 27 '21 at 11:42

On migrating in django project it shows and error

1 Answers1