[Fixed]-How to fix "InternalError: variable not found in subplan target list"

by

9👍

It appears postgres has shipped something broken into all their minor versions:

https://www.postgresql.org/message-id/2121219.1644607692%40sss.pgh.pa.us

For example, the postgres:12 dockerhub is now the same as the postgres:12.10 dockerhub image rather than 12.9. If you explicitly specify postgres:12.9 (or the previous minor release for any of the other versions), I believe it will start working.

👤james.haggerty

2👍

To temporarily fix the Issue – for me a VACUUM FULL; helped.

To really resolve the issue you have to update Postgresql to a newer version I guess.

👤icyerasor

1👍

I had the same issue. Temporary fix but what I did was modify the query performed by the admin.

Try this in your admin.py

class ProblemAdmin(admin.ModelAdmin):
    def get_queryset(self, request):
        return Problem.objects.filter(id__gte=0)

Edit: This only fixes issues you may have with your django admin

👤Enzo Vergara

Leave a comment