#1 by URLG93
Hello! I am facing the following bugs list when creating a session.
Although it gives me a user link when I press the link the attached error message appears.
How can I solve this issue?
Thank you!
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) (psycopg2.errors.UndefinedColumn) column "i_achieve1" of relation "SL_player" does not exist LINE 1: ...in_group, _payoff, round_number, _role, nickname, i_achieve1... ^ [SQL: INSERT INTO "SL_player" (id_in_group, _payoff, round_number, _role, nickname, i_achieve1, cp_achieve1, i_achieve2, cp_achieve2, "IQ1", "IQ2", "IQ3", "IQ4", offer_0_accept, offer_0_counteroffer, offer_0_end_negotiation, message_offer_0, price_offer_0, license_offer_0, storage_offer_0, offer_1_accept, offer_1_counteroffer, offer_1_end_negotiation, message_offer_1, price_offer_1, license_offer_1, storage_offer_1, offer_2_accept, offer_2_counteroffer, offer_2_end_negotiation, message_offer_2, price_offer_2, license_offer_2, storage_offer_2, offer_3_accept, offer_3_counteroffer, offer_3_end_negotiation, message_offer_3, price_offer_3, license_offer_3, storage_offer_3, offer_4_accept, offer_4_counteroffer, offer_4_end_negotiation, message_offer_4, price_offer_4, license_offer_4, storage_offer_4, own_achievement, counterpart_achievement, "Coop_Slider", "Fair_Slider", "Trust_Slider", "Weak_Slider", "Satisfy_Slider", "LongT_Slider", offer_5_accept, offer_5_counteroffer, offer_5_end_negotiation, message_offer_5, price_offer_5, license_offer_5, storage_offer_5, offer_6_accept, offer_6_counteroffer, offer_6_end_negotiation, message_offer_6, price_offer_6, license_offer_6, storage_offer_6, "FinalMessageS", age, sex, discipline, degree, payoff_0, payoff_1, payoff_2, payoff_3, payoff_4, payoff_5, payoff_6, total_payoff, "Coop", "Agree", "Compr", "Accomm", "Oblig", "Fair", "Reason", "Just", "Self", "Soft", "Weak", "Compl", "Yield", "Honest", "Real", "Plaus", "Sinc", q1, q2, q3, q4, q5, q6, q7, q8, q9, q10, q11, q12, q13, q14, q15, q16, subsession_id, group_id, participant_id, session_id) VALUES (%(id_in_group)s, %(_payoff)s, %(round_number)s, %(_role)s, %(nickname)s, %(i_achieve1)s, %(cp_achieve1)s, %(i_achieve2)s, %(cp_achieve2)s, %(IQ1)s, %(IQ2)s, %(IQ3)s, %(IQ4)s, %(offer_0_accept)s, %(offer_0_counteroffer)s, %(offer_0_end_negotiation)s, %(message_offer_0)s, %(price_offer_0)s, %(license_offer_0)s, %(storage_offer_0)s, %(offer_1_accept)s, %(offer_1_counteroffer)s, %(offer_1_end_negotiation)s, %(message_offer_1)s, %(price_offer_1)s, %(license_offer_1)s, %(storage_offer_1)s, %(offer_2_accept)s, %(offer_2_counteroffer)s, %(offer_2_end_negotiation)s, %(message_offer_2)s, %(price_offer_2)s, %(license_offer_2)s, %(storage_offer_2)s, %(offer_3_accept)s, %(offer_3_counteroffer)s, %(offer_3_end_negotiation)s, %(message_offer_3)s, %(price_offer_3)s, %(license_offer_3)s, %(storage_offer_3)s, %(offer_4_accept)s, %(offer_4_counteroffer)s, %(offer_4_end_negotiation)s, %(message_offer_4)s, %(price_offer_4)s, %(license_offer_4)s, %(storage_offer_4)s, %(own_achievement)s, %(counterpart_achievement)s, %(Coop_Slider)s, %(Fair_Slider)s, %(Trust_Slider)s, %(Weak_Slider)s, %(Satisfy_Slider)s, %(LongT_Slider)s, %(offer_5_accept)s, %(offer_5_counteroffer)s, %(offer_5_end_negotiation)s, %(message_offer_5)s, %(price_offer_5)s, %(license_offer_5)s, %(storage_offer_5)s, %(offer_6_accept)s, %(offer_6_counteroffer)s, %(offer_6_end_negotiation)s, %(message_offer_6)s, %(price_offer_6)s, %(license_offer_6)s, %(storage_offer_6)s, %(FinalMessageS)s, %(age)s, %(sex)s, %(discipline)s, %(degree)s, %(payoff_0)s, %(payoff_1)s, %(payoff_2)s, %(payoff_3)s, %(payoff_4)s, %(payoff_5)s, %(payoff_6)s, %(total_payoff)s, %(Coop)s, %(Agree)s, %(Compr)s, %(Accomm)s, %(Oblig)s, %(Fair)s, %(Reason)s, %(Just)s, %(Self)s, %(Soft)s, %(Weak)s, %(Compl)s, %(Yield)s, %(Honest)s, %(Real)s, %(Plaus)s, %(Sinc)s, %(q1)s, %(q2)s, %(q3)s, %(q4)s, %(q5)s, %(q6)s, %(q7)s, %(q8)s, %(q9)s, %(q10)s, %(q11)s, %(q12)s, %(q13)s, %(q14)s, %(q15)s, %(q16)s, %(subsession_id)s, %(group_id)s, %(participant_id)s, %(session_id)s) RETURNING "SL_player".id] [parameters: {'id_in_group': 1, '_payoff': '0', 'round_number': 1, '_role': '', 'nickname': None, 'i_achieve1': None, 'cp_achieve1': None, 'i_achieve2': None, 'cp_achieve2': None, 'IQ1': None, 'IQ2': None, 'IQ3': None, 'IQ4': None, 'offer_0_accept': False, 'offer_0_counteroffer': False, 'offer_0_end_negotiation': False, 'message_offer_0': None, 'price_offer_0': None, 'license_offer_0': None, 'storage_offer_0': None, 'offer_1_accept': False, 'offer_1_counteroffer': False, 'offer_1_end_negotiation': False, 'message_offer_1': None, 'price_offer_1': None, 'license_offer_1': None, 'storage_offer_1': None, 'offer_2_accept': False, 'offer_2_counteroffer': False, 'offer_2_end_negotiation': False, 'message_offer_2': None, 'price_offer_2': None, 'license_offer_2': None, 'storage_offer_2': None, 'offer_3_accept': False, 'offer_3_counteroffer': False, 'offer_3_end_negotiation': False, 'message_offer_3': None, 'price_offer_3': None, 'license_offer_3': None, 'storage_offer_3': None, 'offer_4_accept': False, 'offer_4_counteroffer': False, 'offer_4_end_negotiation': False, 'message_offer_4': None, 'price_offer_4': None, 'license_offer_4': None, 'storage_offer_4': None, 'own_achievement': None, 'counterpart_achievement': None, 'Coop_Slider': None, 'Fair_Slider': None, 'Trust_Slider': None, 'Weak_Slider': None, 'Satisfy_Slider': None, 'LongT_Slider': None, 'offer_5_accept': False, 'offer_5_counteroffer': False, 'offer_5_end_negotiation': False, 'message_offer_5': None, 'price_offer_5': None, 'license_offer_5': None, 'storage_offer_5': None, 'offer_6_accept': False, 'offer_6_counteroffer': False, 'offer_6_end_negotiation': False, 'message_offer_6': None, 'price_offer_6': None, 'license_offer_6': None, 'storage_offer_6': None, 'FinalMessageS': None, 'age': None, 'sex': None, 'discipline': None, 'degree': None, 'payoff_0': 10, 'payoff_1': 0, 'payoff_2': 0, 'payoff_3': 0, 'payoff_4': 0, 'payoff_5': 0, 'payoff_6': 0, 'total_payoff': None, 'Coop': None, 'Agree': None, 'Compr': None, 'Accomm': None, 'Oblig': None, 'Fair': None, 'Reason': None, 'Just': None, 'Self': None, 'Soft': None, 'Weak': None, 'Compl': None, 'Yield': None, 'Honest': None, 'Real': None, 'Plaus': None, 'Sinc': None, 'q1': None, 'q2': None, 'q3': None, 'q4': None, 'q5': None, 'q6': None, 'q7': None, 'q8': None, 'q9': None, 'q10': None, 'q11': None, 'q12': None, 'q13': None, 'q14': None, 'q15': None, 'q16': None, 'subsession_id': 5, 'group_id': 5, 'participant_id': 107, 'session_id': 5}] (Background on this error at: http://sqlalche.me/e/13/f405)
Traceback (most recent call last):
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
psycopg2.errors.UndefinedColumn: column "i_achieve1" of relation "SL_player" does not exist
LINE 1: ...in_group, _payoff, round_number, _role, nickname, i_achieve1...
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/app/.heroku/python/lib/python3.9/site-packages/otree/session.py", line 447, in create_session_traceback_wrapper
return create_session(**kwargs)
File "/app/.heroku/python/lib/python3.9/site-packages/otree/session.py", line 410, in create_session
dbq(Participant).filter_by(session=session).update(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/query.py", line 4063, in update
update_op.exec_()
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1695, in exec_
self._do_pre()
File "", line 1, in
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1741, in _do_pre
session._autoflush()
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1633, in _autoflush
util.raise_(e, with_traceback=sys.exc_info()[2])
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 1622, in _autoflush
self.flush()
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2540, in flush
self._flush(objects)
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2682, in _flush
transaction.rollback(_capture_exception=True)
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/util/langhelpers.py", line 68, in __exit__
compat.raise_(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/session.py", line 2642, in _flush
flush_context.execute()
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 422, in execute
rec.execute(self)
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/unitofwork.py", line 586, in execute
persistence.save_obj(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 239, in save_obj
_emit_insert_statements(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/orm/persistence.py", line 1135, in _emit_insert_statements
result = cached_connections[connection].execute(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1011, in execute
return meth(self, multiparams, params)
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/sql/elements.py", line 298, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1124, in _execute_clauseelement
ret = self._execute_context(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1316, in _execute_context
self._handle_dbapi_exception(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1510, in _handle_dbapi_exception
util.raise_(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/util/compat.py", line 182, in raise_
raise exception
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/base.py", line 1276, in _execute_context
self.dialect.do_execute(
File "/app/.heroku/python/lib/python3.9/site-packages/sqlalchemy/engine/default.py", line 609, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (raised as a result of Query-invoked autoflush; consider using a session.no_autoflush block if this flush is occurring prematurely)
(psycopg2.errors.UndefinedColumn) column "i_achieve1" of relation "SL_player" does not exist
LINE 1: ...in_group, _payoff, round_number, _role, nickname, i_achieve1...
^
[SQL: INSERT INTO "SL_player" (id_in_group, _payoff, round_number, _role, nickname, i_achieve1, cp_achieve1, i_achieve2, cp_achieve2, "IQ1", "IQ2", "IQ3", "IQ4", offer_0_accept, offer_0_counteroffer, offer_0_end_negotiation, message_offer_0, price_offer_0, license_offer_0, storage_offer_0, offer_1_accept, offer_1_counteroffer, offer_1_end_negotiation, message_offer_1, price_offer_1, license_offer_1, storage_offer_1, offer_2_accept, offer_2_counteroffer, offer_2_end_negotiation, message_offer_2, price_offer_2, license_offer_2, storage_offer_2, offer_3_accept, offer_3_counteroffer, offer_3_end_negotiation, message_offer_3, price_offer_3, license_offer_3, storage_offer_3, offer_4_accept, offer_4_counteroffer, offer_4_end_negotiation, message_offer_4, price_offer_4, license_offer_4, storage_offer_4, own_achievement, counterpart_achievement, "Coop_Slider", "Fair_Slider", "Trust_Slider", "Weak_Slider", "Satisfy_Slider", "LongT_Slider", offer_5_accept, offer_5_counteroffer, offer_5_end_negotiation, message_offer_5, price_offer_5, license_offer_5, storage_offer_5, offer_6_accept, offer_6_counteroffer, offer_6_end_negotiation, message_offer_6, price_offer_6, license_offer_6, storage_offer_6, "FinalMessageS", age, sex, discipline, degree, payoff_0, payoff_1, payoff_2, payoff_3, payoff_4, payoff_5, payoff_6, total_payoff, "Coop", "Agree", "Compr", "Accomm", "Oblig", "Fair", "Reason", "Just", "Self", "Soft", "Weak", "Compl", "Yield", "Honest", "Real", "Plaus", "Sinc", q1, q2, q3, q4, q5, q6, q7, q8, q9, q10, q11, q12, q13, q14, q15, q16, subsession_id, group_id, participant_id, session_id) VALUES (%(id_in_group)s, %(_payoff)s, %(round_number)s, %(_role)s, %(nickname)s, %(i_achieve1)s, %(cp_achieve1)s, %(i_achieve2)s, %(cp_achieve2)s, %(IQ1)s, %(IQ2)s, %(IQ3)s, %(IQ4)s, %(offer_0_accept)s, %(offer_0_counteroffer)s, %(offer_0_end_negotiation)s, %(message_offer_0)s, %(price_offer_0)s, %(license_offer_0)s, %(storage_offer_0)s, %(offer_1_accept)s, %(offer_1_counteroffer)s, %(offer_1_end_negotiation)s, %(message_offer_1)s, %(price_offer_1)s, %(license_offer_1)s, %(storage_offer_1)s, %(offer_2_accept)s, %(offer_2_counteroffer)s, %(offer_2_end_negotiation)s, %(message_offer_2)s, %(price_offer_2)s, %(license_offer_2)s, %(storage_offer_2)s, %(offer_3_accept)s, %(offer_3_counteroffer)s, %(offer_3_end_negotiation)s, %(message_offer_3)s, %(price_offer_3)s, %(license_offer_3)s, %(storage_offer_3)s, %(offer_4_accept)s, %(offer_4_counteroffer)s, %(offer_4_end_negotiation)s, %(message_offer_4)s, %(price_offer_4)s, %(license_offer_4)s, %(storage_offer_4)s, %(own_achievement)s, %(counterpart_achievement)s, %(Coop_Slider)s, %(Fair_Slider)s, %(Trust_Slider)s, %(Weak_Slider)s, %(Satisfy_Slider)s, %(LongT_Slider)s, %(offer_5_accept)s, %(offer_5_counteroffer)s, %(offer_5_end_negotiation)s, %(message_offer_5)s, %(price_offer_5)s, %(license_offer_5)s, %(storage_offer_5)s, %(offer_6_accept)s, %(offer_6_counteroffer)s, %(offer_6_end_negotiation)s, %(message_offer_6)s, %(price_offer_6)s, %(license_offer_6)s, %(storage_offer_6)s, %(FinalMessageS)s, %(age)s, %(sex)s, %(discipline)s, %(degree)s, %(payoff_0)s, %(payoff_1)s, %(payoff_2)s, %(payoff_3)s, %(payoff_4)s, %(payoff_5)s, %(payoff_6)s, %(total_payoff)s, %(Coop)s, %(Agree)s, %(Compr)s, %(Accomm)s, %(Oblig)s, %(Fair)s, %(Reason)s, %(Just)s, %(Self)s, %(Soft)s, %(Weak)s, %(Compl)s, %(Yield)s, %(Honest)s, %(Real)s, %(Plaus)s, %(Sinc)s, %(q1)s, %(q2)s, %(q3)s, %(q4)s, %(q5)s, %(q6)s, %(q7)s, %(q8)s, %(q9)s, %(q10)s, %(q11)s, %(q12)s, %(q13)s, %(q14)s, %(q15)s, %(q16)s, %(subsession_id)s, %(group_id)s, %(participant_id)s, %(session_id)s) RETURNING "SL_player".id]
[parameters: {'id_in_group': 1, '_payoff': '0', 'round_number': 1, '_role': '', 'nickname': None, 'i_achieve1': None, 'cp_achieve1': None, 'i_achieve2': None, 'cp_achieve2': None, 'IQ1': None, 'IQ2': None, 'IQ3': None, 'IQ4': None, 'offer_0_accept': False, 'offer_0_counteroffer': False, 'offer_0_end_negotiation': False, 'message_offer_0': None, 'price_offer_0': None, 'license_offer_0': None, 'storage_offer_0': None, 'offer_1_accept': False, 'offer_1_counteroffer': False, 'offer_1_end_negotiation': False, 'message_offer_1': None, 'price_offer_1': None, 'license_offer_1': None, 'storage_offer_1': None, 'offer_2_accept': False, 'offer_2_counteroffer': False, 'offer_2_end_negotiation': False, 'message_offer_2': None, 'price_offer_2': None, 'license_offer_2': None, 'storage_offer_2': None, 'offer_3_accept': False, 'offer_3_counteroffer': False, 'offer_3_end_negotiation': False, 'message_offer_3': None, 'price_offer_3': None, 'license_offer_3': None, 'storage_offer_3': None, 'offer_4_accept': False, 'offer_4_counteroffer': False, 'offer_4_end_negotiation': False, 'message_offer_4': None, 'price_offer_4': None, 'license_offer_4': None, 'storage_offer_4': None, 'own_achievement': None, 'counterpart_achievement': None, 'Coop_Slider': None, 'Fair_Slider': None, 'Trust_Slider': None, 'Weak_Slider': None, 'Satisfy_Slider': None, 'LongT_Slider': None, 'offer_5_accept': False, 'offer_5_counteroffer': False, 'offer_5_end_negotiation': False, 'message_offer_5': None, 'price_offer_5': None, 'license_offer_5': None, 'storage_offer_5': None, 'offer_6_accept': False, 'offer_6_counteroffer': False, 'offer_6_end_negotiation': False, 'message_offer_6': None, 'price_offer_6': None, 'license_offer_6': None, 'storage_offer_6': None, 'FinalMessageS': None, 'age': None, 'sex': None, 'discipline': None, 'degree': None, 'payoff_0': 10, 'payoff_1': 0, 'payoff_2': 0, 'payoff_3': 0, 'payoff_4': 0, 'payoff_5': 0, 'payoff_6': 0, 'total_payoff': None, 'Coop': None, 'Agree': None, 'Compr': None, 'Accomm': None, 'Oblig': None, 'Fair': None, 'Reason': None, 'Just': None, 'Self': None, 'Soft': None, 'Weak': None, 'Compl': None, 'Yield': None, 'Honest': None, 'Real': None, 'Plaus': None, 'Sinc': None, 'q1': None, 'q2': None, 'q3': None, 'q4': None, 'q5': None, 'q6': None, 'q7': None, 'q8': None, 'q9': None, 'q10': None, 'q11': None, 'q12': None, 'q13': None, 'q14': None, 'q15': None, 'q16': None, 'subsession_id': 5, 'group_id': 5, 'participant_id': 107, 'session_id': 5}]
(Background on this error at: http://sqlalche.me/e/13/f405)
#2 by URLG93
Issue resolved: Make sure you have only one database in Heroku; having multiple messes up with the connection between server and your code.
