Table doesn't exist in django

Question

I'm trying to send data from a form to a database using this model, but i keep getting this error:

("Table 'trades.main_SomeModel' doesn't exist")

Here is my model:

class SomeModel(models.Model):
     data = models.CharField(max_length=100)

     def save(self):
         super(SomeModel, self).save(using='dataset')

And here is my form:

 class DataForm(forms.ModelForm):

        class Meta:
            model = Trade
            fields = ("data",)

        def save(self, commit=True):
            send = super(DataForm, self).save(commit=False)
            if commit:
                send.save()
            return send

I already tried this but it's not working: when i got to step 3, in fact, i got the error table "main_SomeModel" already exists

Note: i'm using two DBs. There is a default one and a second one. The data from this model should be sent to the second DB.

What am i doing wrong? Should i migrate again?

Did you change anything (field-wise) on your model after migrating? If so, you indeed need to migrate again. — Higor Rossato, Apr 26 '19 at 11:25
I'm using two DB, there is a default one and a second one. On this model, data should be saved on the second DB, which is declared on my settings.py file — Jack022, Apr 26 '19 at 12:15
I think this `send = super(SomeModel, self).save(commit=False)` is the issue which should be `send = super(DataForm, self).save(commit=False)` within DataForm — HenryM, Apr 26 '19 at 13:14

score 1 · Accepted Answer · answered Apr 26 '19 at 18:51

1

You need to run the migrations for both of your databases but you have run it for one database.

python manage.py migrate --database dataset

Here dataset is the name of the database other than your default database.

answered Apr 26 '19 at 18:51

Khuram

1,820
1
26
33

if this is indeed your problem consider using a django database router – elad silver Nov 21 '19 at 19:30

Table doesn't exist in django

1 Answers1