You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@airavata.apache.org by "Marcus Christie (Jira)" <ji...@apache.org> on 2020/09/24 21:12:00 UTC
[jira] [Updated] (AIRAVATA-3376) Wagtail: Problem installing
fixtures: no such table: wagtailcore_page__old, Python 3.7 incompatibility
[ https://issues.apache.org/jira/browse/AIRAVATA-3376?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Marcus Christie updated AIRAVATA-3376:
--------------------------------------
Description:
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
was:
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}
> 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)