Hi everyone,
I have a website in production. I have an app, with a model. It contained a markdown_file attribute: |markdown_file=models.FileField(upload_to='/media/')| But since the number of file is limited, I decided to make it a markdown_filename attribute with a choices selection box: |markdown_filename=models.CharField(max_length=30,null=True,blank=True,choices=MENU_MARKDOWN_FILE_CHOICES)| Therefore, I modified this model and made migrations locally. I pushed the code in production and run: |python manage.py migrate| After I checked with showmigrations and sqlmigrate, that the modification I made were there. Then, I checked in the database, that the fields were correctly modified. But, I still get this error, when trying to access the website: |ERROR:django.request:InternalServerError:/Traceback(most recent call last):File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/backends/utils.py",line 84,in_execute returnself.cursor.execute(sql,params)psycopg2.errors.UndefinedColumn:column showcase_subpage.markdown_file does notexist LINE 1:...bpage"."slug", "showcase_subpage"."html_content", "showcase_...^Theabove exception was the direct cause of the following exception:Traceback(most recent call last):File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/core/handlers/exception.py",line 34,ininner response =get_response(request)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/core/handlers/base.py",line 115,in_get_response response =self.process_exception_by_middleware(e,request)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/core/handlers/base.py",line 113,in_get_response response =wrapped_callback(request,*callback_args,**callback_kwargs)File"./showcase/views.py",line 10,inhome returnrender(request,'showcase/home.html',context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/shortcuts.py",line 36,inrender content =loader.render_to_string(template_name,context,request,using=using)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/loader.py",line 62,inrender_to_string returntemplate.render(context,request)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/backends/django.py",line 61,inrender returnself.template.render(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/base.py",line 171,inrender returnself._render(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/base.py",line 163,in_render returnself.nodelist.render(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/base.py",line 937,inrender bit =node.render_annotated(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/base.py",line 904,inrender_annotated returnself.render(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/loader_tags.py",line 150,inrender returncompiled_parent._render(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/base.py",line 163,in_render returnself.nodelist.render(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/base.py",line 937,inrender bit =node.render_annotated(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/base.py",line 904,inrender_annotated returnself.render(context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/template/defaulttags.py",line 166,inrender len_values =len(values)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/models/query.py",line 256,in__len__ self._fetch_all()File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/models/query.py",line 1242,in_fetch_all self._result_cache =list(self._iterable_class(self))File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/models/query.py",line 55,in__iter__ results =compiler.execute_sql(chunked_fetch=self.chunked_fetch,chunk_size=self.chunk_size)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/models/sql/compiler.py",line 1100,inexecute_sql cursor.execute(sql,params)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/backends/utils.py",line 67,inexecute returnself._execute_with_wrappers(sql,params,many=False,executor=self._execute)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/backends/utils.py",line 76,in_execute_with_wrappers returnexecutor(sql,params,many,context)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/backends/utils.py",line 84,in_execute returnself.cursor.execute(sql,params)File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/utils.py",line 89,in__exit__ raisedj_exc_value.with_traceback(traceback)fromexc_value File"/srv/data/web/vhosts/default/local/lib/python3.7/site-packages/django/db/backends/utils.py",line 84,in_execute returnself.cursor.execute(sql,params)django.db.utils.ProgrammingError:column showcase_subpage.markdown_file does notexist LINE 1:...bpage"."slug", "showcase_subpage"."html_content", "showcase_...^| The markdown_file field has been modified and renamed as markdown_filename. It has been correctly specified in the migrations. The modification is effective in the database. I tested locally (it works fine locally), to make sure, I don’t have anymore code calling markdown_file attribute. I also tried clearing the migrations history and the database, to rebuilt it as new, but, the problem is still there. I can’t see why, this former attributes is still queried, though the migrations went OK, without any error. -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/4ff82558-df2a-85a7-e10c-fd567c768862%40riseup.net.
