[ https://issues.apache.org/jira/browse/AIRAVATA-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17201816#comment-17201816 ]
Marcus Christie commented on AIRAVATA-3376: ------------------------------------------- I followed the upgrade process here for upgrading Wagtail to the latest LTS release: https://docs.wagtail.io/en/stable/releases/upgrading.html#upgrade-process I managed to get Django upgraded to 2.2 (latest LTS release) and Wagtail to 2.7 (it's latest LTS release). This supports Python versions 3.6, 3.7 and 3.8. I added tox (https://tox.readthedocs.io/en/latest/) to run the testsuite against virtual environments in 3.6, 3.7 and 3.8. > Wagtail: Problem installing fixtures: no such table: wagtailcore_page__old, > Python 3.7 incompatibility > ------------------------------------------------------------------------------------------------------ > > Key: AIRAVATA-3376 > URL: https://issues.apache.org/jira/browse/AIRAVATA-3376 > Project: Airavata > Issue Type: Improvement > Reporter: Marcus Christie > Assignee: Marcus Christie > Priority: Major > > The version of Django (1.11.29) and Wagtail (2.0) are not compatible with > Python 3.7+. Newer versions of Django have the fix but 1.11.x didn't get the > fix. > Workaround: > - use Python 3.6 > See also: > https://code.djangoproject.com/ticket/29182 > https://github.com/wagtail/wagtail/issues/4941 > Stack trace: > {code} > Traceback (most recent call last): > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/utils.py", > line 62, in execute > return self.cursor.execute(sql) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py", > line 326, in execute > return Database.Cursor.execute(self, query) > sqlite3.OperationalError: no such table: wagtailcore_page__old > The above exception was the direct cause of the following exception: > Traceback (most recent call last): > File "manage.py", line 22, in <module> > execute_from_command_line(sys.argv) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/__init__.py", > line 364, in execute_from_command_line > utility.execute() > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/__init__.py", > line 356, in execute > self.fetch_command(subcommand).run_from_argv(self.argv) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/base.py", > line 283, in run_from_argv > self.execute(*args, **cmd_options) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/base.py", > line 330, in execute > output = self.handle(*args, **options) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/django_airavata/wagtailapps/base/management/commands/load_cms_data.py", > line 36, in handle > call_command('loaddata', fixture_file, verbosity=0) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/__init__.py", > line 131, in call_command > return command.execute(*args, **defaults) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/base.py", > line 330, in execute > output = self.handle(*args, **options) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/commands/loaddata.py", > line 69, in handle > self.loaddata(fixture_labels) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/core/management/commands/loaddata.py", > line 115, in loaddata > connection.check_constraints(table_names=table_names) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py", > line 286, in check_constraints > column_name, referenced_column_name, > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/utils.py", > line 79, in execute > return super(CursorDebugWrapper, self).execute(sql, params) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/utils.py", > line 64, in execute > return self.cursor.execute(sql, params) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/utils.py", > line 94, in __exit__ > six.reraise(dj_exc_type, dj_exc_value, traceback) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/utils/six.py", > line 685, in reraise > raise value.with_traceback(tb) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/utils.py", > line 62, in execute > return self.cursor.execute(sql) > File > "/Users/akilaishani/Code/US/eroma/airavata-django-portal/venv/lib/python3.7/site-packages/django/db/backends/sqlite3/base.py", > line 326, in execute > return Database.Cursor.execute(self, query) > django.db.utils.OperationalError: Problem installing fixtures: no such table: > wagtailcore_page__old > {code} > h5. TODO > - [ ] integrate tox for running Python unittests against multiple Python > versions > - [ ] Upgrade to more recent and supported Django and Wagtail > - [ ] Upgrade to more recent and supported Python -- This message was sent by Atlassian Jira (v8.3.4#803005)