OperationalError: foreign key mismatch

[Wai Yeung]

Hello,

I'm getting the following error whenever I attempt to save to the table in a SQLite database:

foreign key mismatch - "procedure_tbl" referencing "filename_tbl"

In models.py, these are the tables that the error is refering to:

class FilenameTbl(models.Model):

    rowid = models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='FileID', db_column='rowid')

    filename = models.TextField(blank=True, null=True)

    creation_datetime = models.TextField(blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'filename_tbl'

        ordering = ['rowid']

class ProcedureTbl(models.Model):

    rowid = models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ProcedureID', db_column='rowid')

    ...

    filename_id = models.ForeignKey(FilenameTbl,db_column='filename_id', to_field='rowid',null=True,blank=True,on_delete=models.SET_NULL)

    class Meta:

        managed = False

        db_table = 'procedure_tbl'

        ordering = ['rowid']

Data can be read from the tables and querysets like the following return the correct data:

    queryset = FilenameTbl.objects.values(

        'rowid', 'filename',

        'proceduretbl__rowid')

Raw SQLite commands to write/update to the ProcedureTbl table function properly.

If I removed filename_id from the ProcedureTbl, then data can be saved to the table.

Any insight into the issue would be much appreciated.

Cheers,

Wai

[DJANGO DEVELOPER]

can you please  change your object from this:

filename_id = models.ForeignKey(FilenameTbl,db_column='filename_id', to_field='rowid',null=True,blank=True,on_delete=models.SET_NULL)

to :

filename_id = models.ForeignKey(FilenameTbl,db_column='filename', to_field='rowid',null=True,blank=True,on_delete=models.SET_NULL)

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/b90d237f-8c29-42ef-897a-34221704699dn%40googlegroups.com.

[Wai Yeung]

Hello,

Thanks for the suggestion.  I actually changed it to the following to as to not have the "_id" suffix:

filename_number = models.ForeignKey(FilenameTbl,db_column='filename_number', to_field='rowid',null=True,blank=True,on_delete=models.SET_NULL)

This is what eventually worked for me:

https://stackoverflow.com/questions/68537031/how-do-i-resolve-the-following-error-in-django-operationalerror-foreign-key-m

Cheers,

Wai

You received this message because you are subscribed to a topic in the Google Groups "Django users" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/django-users/nqYRTN3m6Bg/unsubscribe.
To unsubscribe from this group and all its topics, send an email to django-users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9pkH2pp3bkARsviqUdmn007Hc30ckrVOPH4yTBakJqXjDw%40mail.gmail.com.

[DJANGO DEVELOPER]

so issue resolved now?

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKDLG%3DTx_oX5o7fhW9aaeMcyXsqhB2GsqRujLAxy1HVi3QjBPg%40mail.gmail.com.

[Wai Yeung]

Yes.  Thank you.

To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAKPY9p%3D-zeLdKNLg990KO%3D9PczU0WNEG2H7j9jfs9xis2ZLrOg%40mail.gmail.com.