Can't sign user up for training

Issue #18 closed
BCCF
created an issue

The following error was encountered while attempting to sign a person up for an event.

I went to the new website, clicked in the side menu on the item "Trainings" and opened the event "working with LGBTQ Families" I tried to add the training to my cart and I was prompted to add my name. I added my name and then tried to add the training to the cart again and then received the following error.

ProgrammingError at /basket/add/128/ (1146, "Table 'bccf_shop.bccf_userprofile' doesn't exist") Request Method: POST Request URL: http://shop.bccf.ca:8001/basket/add/128/ Django Version: 1.10.7 Exception Type: ProgrammingError Exception Value:
(1146, "Table 'bccf_shop.bccf_userprofile' doesn't exist") Exception Location: /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/MySQLdb/connections.py in defaulterrorhandler, line 50 Python Executable: /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/bin/python Python Version: 2.7.12 Python Path:
['/srv/bccf-shop/project/shop', '/home/nav/.local/share/virtualenvs/project-kNr2ZCnj/lib/python2.7', '/home/nav/.local/share/virtualenvs/project-kNr2ZCnj/lib/python2.7/plat-x86_64-linux-gnu', '/home/nav/.local/share/virtualenvs/project-kNr2ZCnj/lib/python2.7/lib-tk', '/home/nav/.local/share/virtualenvs/project-kNr2ZCnj/lib/python2.7/lib-old', '/home/nav/.local/share/virtualenvs/project-kNr2ZCnj/lib/python2.7/lib-dynload', '/usr/lib/python2.7', '/usr/lib/python2.7/plat-x86_64-linux-gnu', '/usr/lib/python2.7/lib-tk', '/home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages', '/home/nav/.local/share/virtualenvs/project-kNr2ZCnj/lib/python2.7/site-packages'] Server time: Tue, 8 Aug 2017 18:20:17 +0000 Traceback Switch to copy-and-paste view

/home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/core/handlers/exception.py in inner response = get_response(request) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/core/handlers/base.py in _legacy_get_response response = self._get_response(request) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/core/handlers/base.py in _get_response response = self.process_exception_by_middleware(e, request) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/core/handlers/base.py in _get_response response = wrapped_callback(request, callback_args, callback_kwargs) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/utils/decorators.py in inner return func(*args, kwargs) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/utils/decorators.py in inner return func(args, kwargs) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/views/generic/base.py in view return self.dispatch(request, *args, kwargs) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/views/generic/base.py in dispatch return handler(request, args, kwargs) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/oscar/apps/basket/views.py in post return super(BasketAddView, self).post(request, *args, kwargs) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/views/generic/edit.py in post return self.form_valid(form) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/oscar/apps/basket/views.py in form_valid BasketMessageGenerator().apply_messages(self.request, offers_before) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/oscar/apps/basket/utils.py in apply_messages Applicator().apply(request.basket, request.user, request) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/oscar/apps/offer/applicator.py in apply self.apply_offers(basket, offers) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/oscar/apps/offer/applicator.py in apply_offers result = offer.apply_benefit(basket) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/oscar/apps/offer/abstract_models.py in apply_benefit if not self.is_condition_satisfied(basket): ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/oscar/apps/offer/abstract_models.py in is_condition_satisfied return self.condition.proxy().is_satisfied(self, basket) ... ▶ Local vars /srv/bccf-shop/project/shop/apps/offer/conditions.py in is_satisfied membership_type = basket.owner.profile.membership_type ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/utils/functional.py in inner return func(self._wrapped, args) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/models/fields/related_descriptors.py in get rel_obj = self.get_queryset(instance=instance).get(**filter_args) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/models/query.py in get num = len(clone) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/models/query.py in len self._fetch_all() ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/models/query.py in _fetch_all self._result_cache = list(self.iterator()) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/models/query.py in iter results = compiler.execute_sql() ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/models/sql/compiler.py in execute_sql cursor.execute(sql, params) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/backends/utils.py in execute return super(CursorDebugWrapper, self).execute(sql, params) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/backends/utils.py in execute return self.cursor.execute(sql, params) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/utils.py in exit six.reraise(dj_exc_type, dj_exc_value, traceback) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/backends/utils.py in execute return self.cursor.execute(sql, params) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/django/db/backends/mysql/base.py in execute return self.cursor.execute(query, args) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/MySQLdb/cursors.py in execute self.errorhandler(self, exc, value) ... ▶ Local vars /home/nav/.local/share/virtualenvs/project-kNr2ZCnj/local/lib/python2.7/site-packages/MySQLdb/connections.py in defaulterrorhandler raise errorvalue ... ▶ Local vars

Comments (4)

  1. Nav A repo owner

    Currently, the attendee box is expecting a user id. However, when we launch the site it will be pre-filled and hidden.

    To find out the user id, you can use the existing shop and go to Users.

    Screen Shot 2017-08-08 at 11.48.31 AM.png

  2. Log in to comment