I have latest version of Tutor 10.2.0 and I have a problem with Course Creator requests from CMS, I don’t have this section
/admin/course_creators/coursecreator/
in Django admin console and I can’t accept requests for Course Creator. When I delete user I have error:
lms_1 | 2020-08-19 08:24:41,084 ERROR 68 [root] [user None] signals.py:23 - Uncaught exception from None
lms_1 | Traceback (most recent call last):
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 84, in _execute
lms_1 | return self.cursor.execute(sql, params)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 71, in execute
lms_1 | return self.cursor.execute(query, args)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/cursors.py", line 209, in execute
lms_1 | res = self._query(query)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/cursors.py", line 315, in _query
lms_1 | db.query(q)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/connections.py", line 239, in query
lms_1 | _mysql.connection.query(self, query)
lms_1 | MySQLdb._exceptions.IntegrityError: (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`openedx`.`course_creators_coursecreator`, CONSTRAINT `course_creators_coursecreator_user_id_e4da548d_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))')
lms_1 |
lms_1 | The above exception was the direct cause of the following exception:
lms_1 |
lms_1 | Traceback (most recent call last):
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/core/handlers/exception.py", line 34, in inner
lms_1 | response = get_response(request)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/core/handlers/base.py", line 115, in _get_response
lms_1 | response = self.process_exception_by_middleware(e, request)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/core/handlers/base.py", line 113, in _get_response
lms_1 | response = wrapped_callback(request, *callback_args, **callback_kwargs)
lms_1 | File "/opt/pyenv/versions/3.5.9/lib/python3.5/contextlib.py", line 30, in inner
lms_1 | return func(*args, **kwds)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/options.py", line 606, in wrapper
lms_1 | return self.admin_site.admin_view(view)(*args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/utils/decorators.py", line 142, in _wrapped_view
lms_1 | response = view_func(request, *args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/views/decorators/cache.py", line 44, in _wrapped_view_func
lms_1 | response = view_func(request, *args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/sites.py", line 223, in inner
lms_1 | return view(request, *args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/utils/decorators.py", line 45, in _wrapper
lms_1 | return bound_method(*args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/utils/decorators.py", line 142, in _wrapped_view
lms_1 | response = view_func(request, *args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/options.py", line 1838, in delete_view
lms_1 | return self._delete_view(request, object_id, extra_context)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/options.py", line 1868, in _delete_view
lms_1 | self.delete_model(request, obj)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/options.py", line 1094, in delete_model
lms_1 | obj.delete()
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/base.py", line 919, in delete
lms_1 | return collector.delete()
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/deletion.py", line 312, in delete
lms_1 | count = query.delete_batch(pk_list, self.using)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/sql/subqueries.py", line 41, in delete_batch
lms_1 | num_deleted += self.do_query(self.get_meta().db_table, self.where, using=using)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/sql/subqueries.py", line 24, in do_query
lms_1 | cursor = self.get_compiler(using).execute_sql(CURSOR)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 1140, in execute_sql
lms_1 | cursor.execute(sql, params)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 67, in execute
lms_1 | return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
lms_1 | return executor(sql, params, many, context)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 84, in _execute
lms_1 | return self.cursor.execute(sql, params)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/utils.py", line 89, in __exit__
lms_1 | raise dj_exc_value.with_traceback(traceback) from exc_value
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 84, in _execute
lms_1 | return self.cursor.execute(sql, params)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 71, in execute
lms_1 | return self.cursor.execute(query, args)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/cursors.py", line 209, in execute
lms_1 | res = self._query(query)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/cursors.py", line 315, in _query
lms_1 | db.query(q)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/connections.py", line 239, in query
lms_1 | _mysql.connection.query(self, query)
lms_1 | django.db.utils.IntegrityError: (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`openedx`.`course_creators_coursecreator`, CONSTRAINT `course_creators_coursecreator_user_id_e4da548d_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))')
lms_1 | 2020-08-19 08:24:41,137 ERROR 68 [django.request] [user 4] log.py:228 - Internal Server Error: /admin/auth/user/33/delete/
lms_1 | Traceback (most recent call last):
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 84, in _execute
lms_1 | return self.cursor.execute(sql, params)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 71, in execute
lms_1 | return self.cursor.execute(query, args)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/cursors.py", line 209, in execute
lms_1 | res = self._query(query)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/cursors.py", line 315, in _query
lms_1 | db.query(q)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/connections.py", line 239, in query
lms_1 | _mysql.connection.query(self, query)
lms_1 | MySQLdb._exceptions.IntegrityError: (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`openedx`.`course_creators_coursecreator`, CONSTRAINT `course_creators_coursecreator_user_id_e4da548d_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))')
lms_1 |
lms_1 | The above exception was the direct cause of the following exception:
lms_1 |
lms_1 | Traceback (most recent call last):
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/core/handlers/exception.py", line 34, in inner
lms_1 | response = get_response(request)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/core/handlers/base.py", line 115, in _get_response
lms_1 | response = self.process_exception_by_middleware(e, request)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/core/handlers/base.py", line 113, in _get_response
lms_1 | response = wrapped_callback(request, *callback_args, **callback_kwargs)
lms_1 | File "/opt/pyenv/versions/3.5.9/lib/python3.5/contextlib.py", line 30, in inner
lms_1 | return func(*args, **kwds)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/options.py", line 606, in wrapper
lms_1 | return self.admin_site.admin_view(view)(*args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/utils/decorators.py", line 142, in _wrapped_view
lms_1 | response = view_func(request, *args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/views/decorators/cache.py", line 44, in _wrapped_view_func
lms_1 | response = view_func(request, *args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/sites.py", line 223, in inner
lms_1 | return view(request, *args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/utils/decorators.py", line 45, in _wrapper
lms_1 | return bound_method(*args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/utils/decorators.py", line 142, in _wrapped_view
lms_1 | response = view_func(request, *args, **kwargs)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/options.py", line 1838, in delete_view
lms_1 | return self._delete_view(request, object_id, extra_context)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/options.py", line 1868, in _delete_view
lms_1 | self.delete_model(request, obj)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/contrib/admin/options.py", line 1094, in delete_model
lms_1 | obj.delete()
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/base.py", line 919, in delete
lms_1 | return collector.delete()
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/deletion.py", line 312, in delete
lms_1 | count = query.delete_batch(pk_list, self.using)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/sql/subqueries.py", line 41, in delete_batch
lms_1 | num_deleted += self.do_query(self.get_meta().db_table, self.where, using=using)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/sql/subqueries.py", line 24, in do_query
lms_1 | cursor = self.get_compiler(using).execute_sql(CURSOR)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/models/sql/compiler.py", line 1140, in execute_sql
lms_1 | cursor.execute(sql, params)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 67, in execute
lms_1 | return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 76, in _execute_with_wrappers
lms_1 | return executor(sql, params, many, context)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 84, in _execute
lms_1 | return self.cursor.execute(sql, params)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/utils.py", line 89, in __exit__
lms_1 | raise dj_exc_value.with_traceback(traceback) from exc_value
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/utils.py", line 84, in _execute
lms_1 | return self.cursor.execute(sql, params)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/django/db/backends/mysql/base.py", line 71, in execute
lms_1 | return self.cursor.execute(query, args)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/cursors.py", line 209, in execute
lms_1 | res = self._query(query)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/cursors.py", line 315, in _query
lms_1 | db.query(q)
lms_1 | File "/openedx/venv/lib/python3.5/site-packages/MySQLdb/connections.py", line 239, in query
lms_1 | _mysql.connection.query(self, query)
lms_1 | django.db.utils.IntegrityError: (1451, 'Cannot delete or update a parent row: a foreign key constraint fails (`openedx`.`course_creators_coursecreator`, CONSTRAINT `course_creators_coursecreator_user_id_e4da548d_fk_auth_user_id` FOREIGN KEY (`user_id`) REFERENCES `auth_user` (`id`))')
Is that the problem with DB after upgrade Tutor? What is the solution of the problem?