I finally got my other experiment up and running. However, now I am trying to compensate some participants from a few errors that occurred during my first live attempts.
I have everything set up with whoops yall. Everything is configured with heroku. the app seems to be working fine. I go to the dashboard and add a worker id (e.g. my worker id for testing purposes: A2XKUSIPUCMIUL) to compensate and I am given the secret code. However, when I create a hit in sandbox and got plug in the secret code I am given this error:
Error: This code is not correct. Please try again. If you continue to have
difficulty please contact the requester.
021-07-06 20:49:56,309 Exception on /whoopsyall_dashboard [POST]
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one
ret = self.one_or_none()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3467, in one_or_none
raise orm_exc.MultipleResultsFound(
sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one_or_none()
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.9/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/local/lib/python3.9/site-packages/psiturk/user_utils.py", line 74, in decorated
return func(*args, **kwargs)
File "/Users/JMJ/whoops_yall/custom.py", line 80, in dashboard
user = Participant.query.filter(Participant.workerid == lw.amt_worker_id).one()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3492, in one
util.raise_(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one()
2021-07-06 20:50:04,727 Exception on /whoopsyall_dashboard [POST]
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one
ret = self.one_or_none()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3467, in one_or_none
raise orm_exc.MultipleResultsFound(
sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one_or_none()
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.9/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/local/lib/python3.9/site-packages/psiturk/user_utils.py", line 74, in decorated
return func(*args, **kwargs)
File "/Users/JMJ/whoops_yall/custom.py", line 80, in dashboard
user = Participant.query.filter(Participant.workerid == lw.amt_worker_id).one()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3492, in one
util.raise_(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one()
2021-07-06 20:50:11,733 Exception on /whoopsyall_dashboard [POST]
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one
ret = self.one_or_none()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3467, in one_or_none
raise orm_exc.MultipleResultsFound(
sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one_or_none()
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.9/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/local/lib/python3.9/site-packages/psiturk/user_utils.py", line 74, in decorated
return func(*args, **kwargs)
File "/Users/JMJ/whoops_yall/custom.py", line 80, in dashboard
user = Participant.query.filter(Participant.workerid == lw.amt_worker_id).one()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3492, in one
util.raise_(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one()
2021-07-06 20:50:16,395 Exception on /whoopsyall_dashboard [POST]
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3490, in one
ret = self.one_or_none()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3467, in one_or_none
raise orm_exc.MultipleResultsFound(
sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one_or_none()
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 2447, in wsgi_app
response = self.full_dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1952, in full_dispatch_request
rv = self.handle_user_exception(e)
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1821, in handle_user_exception
reraise(exc_type, exc_value, tb)
File "/usr/local/lib/python3.9/site-packages/flask/_compat.py", line 39, in reraise
raise value
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1950, in full_dispatch_request
rv = self.dispatch_request()
File "/usr/local/lib/python3.9/site-packages/flask/app.py", line 1936, in dispatch_request
return self.view_functions[rule.endpoint](**req.view_args)
File "/usr/local/lib/python3.9/site-packages/psiturk/user_utils.py", line 74, in decorated
return func(*args, **kwargs)
File "/Users/JMJ/whoops_yall/custom.py", line 80, in dashboard
user = Participant.query.filter(Participant.workerid == lw.amt_worker_id).one()
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 3492, in one
util.raise_(
File "/usr/local/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
sqlalchemy.orm.exc.MultipleResultsFound: Multiple rows were found for one()
I am not given any errors in the heroku logs. I am given the following errors in the server log but I am not quite sure what it means and can't find any examples that are helpful: