OperationalError: foreign key mismatch

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

--
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+unsubscribe@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.