Django - matching query does not exist

Question

I'm working on a Django project and I'm getting this error, "State matching query does not exist." why is this happening? the state is in the model store, can you explain me this error and how to solve it? Thanks. Views: ``` def Test(request): stores = Store.objects.all() data = [] for store in stores: data.append({ 'id': store.id, 'name': store.name, 'address': store.address, 'state': store.state, }) return HttpResponse(json.dumps(data), 'application/json') ``` Models: ``` class State(models.Model): name = models.CharField(max_length=255) shortname = models.CharField(max_length=100) def __unicode__(self): return self.name class City(models.Model): name = models.CharField(max_length=255) state = models.ForeignKey(State) def __unicode__(self): return self.name class Store(models.Model): name = models.CharField(max_length=255, null=True, blank=True) address = models.CharField(max_length=255, blank=True, null=True) lon = models.FloatField(blank=True, null=True) lat = models.FloatField(bl…

Accepted Answer

It looks like you have a Store model in your database that does not have a `state`. When you try to access `state` here:

```
data.append({
    'id': store.id,
    'name': store.name,
    'address': store.address,
    'state': store.state,
})
```

Django throws an error because `state` is a `ForeignKey` on `Store` and it has to look it up when you access it with `store.state`. If `state` is empty and you haven't set your `ForeignKey` to allow `None` values with `null=True`, Django will raise a `DoesNotExist` exception.

Django - matching query does not exist

Solution

Problem