#1 by Shawn
Hi, I've been trying to launch my study on Heroku, but I keep running into this issue (attached below). I have tried resetting the database several times, but does not appear to do anything. Could someone please point out what I might be doing wrong here? Please let me know if any additional information I can provide that may be helpful! Thank you, Shawn Failed to create session: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely) (decimal.InvalidOperation) [<class 'decimal.ConversionSyntax'>] [SQL: INSERT INTO pgg_group (id_in_subsession, round_number, n_players, has_dropout, bp_contribution, p1_nationrace, p2_nationrace, p1_age, p2_age, dyadicntl, dyadictype, total_contribution, individual_share, subsession_id, session_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)] [parameters: [{'round_number': 1, 'session_id': 2, 'id_in_subsession': 1, 'subsession_id': 2, 'p1_age': None, 'p2_nationrace': None, 'total_contribution': None, 'individual_share': None, 'p2_age': None, 'dyadicntl': None, 'dyadictype': None, 'p1_nationrace': None, 'n_players': None}]] Traceback (most recent call last): File "/app/.heroku/python/lib/python3.10/site-packages/sqlalchemy/engine/base.py", line 1204, in _execute_context context = constructor(dialect, self, conn, *args) File "/app/.heroku/python/lib/python3.10/site-packages/sqlalchemy/engine/default.py", line 855, in _init_compiled param.append(processors[key](compiled_params[key])) File "/app/.heroku/python/lib/python3.10/site-packages/sqlalchemy/sql/type_api.py", line 1232, in process return process_param(value, dialect) File "/app/.heroku/python/lib/python3.10/site-packages/otree/database.py", line 426, in process_bind_param return str(Decimal(value)) decimal.InvalidOperation: [] The above exception was the direct cause of the following exception:
#2 by Shawn
Issue resolved. It was actually a blunder (typo)!
#3 by Trontatuma
Where was the blunder?