I am trying to pay my mturk workers. I launched HITS and the data is all showing up in my mysql+pymysql table when I view it in my jupyter notebook. However, when I go to approve workers in my terminal screen session is says there are no workers, no hits, etc.
When I run the command "worker list", it says "KeyError('assignments')".
When I run the command "hit list", it says "*** no hits retrieved".
When I run the command "worker approve --all", it says "Approving all submissions for the current study... Response(Operation: approve_all_assignments | Status: error | Exception: (sqlalchemy.exc.InvalidRequestError) Can't reconnect until invalid transaction is rolled back [SQL: SELECT orderedrecallvaried_3.uniqueid AS orderedrecallvaried_3_uniqueid, orderedrecallvaried_3.assignmentid AS orderedrecallvaried_3_assignmentid, orderedrecallvaried_3.workerid AS orderedrecallvaried_3_workerid, orderedrecallvaried_3.hitid AS orderedrecallvaried_3_hitid, orderedrecallvaried_3.ipaddress AS orderedrecallvaried_3_ipaddress, orderedrecallvaried_3.browser AS orderedrecallvaried_3_browser, orderedrecallvaried_3.platform AS orderedrecallvaried_3_platform, orderedrecallvaried_3.language AS orderedrecallvaried_3_language, orderedrecallvaried_3.cond AS orderedrecallvaried_3_cond, orderedrecallvaried_3.counterbalance AS orderedrecallvaried_3_counterbalance, orderedrecallvaried_3.codeversion AS orderedrecallvaried_3_codeversion, orderedrecallvaried_3.beginhit AS orderedrecallvaried_3_beginhit, orderedrecallvaried_3.beginexp AS orderedrecallvaried_3_beginexp, orderedrecallvaried_3.endhit AS orderedrecallvaried_3_endhit, orderedrecallvaried_3.bonus AS orderedrecallvaried_3_bonus, orderedrecallvaried_3.`status` AS orderedrecallvaried_3_status, orderedrecallvaried_3.`mode` AS orderedrecallvaried_3_mode
FROM orderedrecallvaried_3
WHERE orderedrecallvaried_3.`status` = %(status_1)s]
[parameters: [immutabledict({})]])