#1 by arroycal
Hello, I got the following issue, I believe, after swapping from otree=2.3.2 (or so) to otree lite. I have tried reinstalling the earlier and then the latter, deleting the sqlite file manually, resetting the db. None of these worked and I don't know what else to do. Any suggestions? Thank you! Failed to create session: (sqlite3.InterfaceError) Error binding parameter 1 - probably unsupported type. [SQL: UPDATE payment2_player SET ranking_paid=?, item1=?, item2=? WHERE payment2_player.id = ?] [parameters: (1, [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], 10, 4)] (Background on this error at: http://sqlalche.me/e/13/rvf5) Traceback (most recent call last): File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\engine\default.py", line 609, in do_execute cursor.execute(statement, parameters) sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type. The above exception was the direct cause of the following exception: Traceback (most recent call last): File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\otree\session.py", line 439, in create_session_traceback_wrapper return create_session(**kwargs) File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\otree\session.py", line 423, in create_session db.commit() File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\otree\database.py", line 167, in commit return self._db.commit() File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\session.py", line 1046, in commit self.transaction.commit() File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\session.py", line 504, in commit self._prepare_impl() File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\session.py", line 483, in _prepare_impl self.session.flush() File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\session.py", line 2540, in flush self._flush(objects) File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\session.py", line 2682, in _flush transaction.rollback(_capture_exception=True) File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\util\langhelpers.py", line 70, in __exit__ with_traceback=exc_tb, File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\session.py", line 2642, in _flush flush_context.execute() File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 422, in execute rec.execute(self) File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\unitofwork.py", line 589, in execute uow, File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\persistence.py", line 236, in save_obj update, File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\orm\persistence.py", line 995, in _emit_update_statements statement, multiparams File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\engine\base.py", line 1011, in execute return meth(self, multiparams, params) File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\sql\elements.py", line 298, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\engine\base.py", line 1130, in _execute_clauseelement distilled_params, File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\engine\base.py", line 1317, in _execute_context e, statement, parameters, cursor, context File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\engine\base.py", line 1511, in _handle_dbapi_exception sqlalchemy_exception, with_traceback=exc_info[2], from_=e File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\util\compat.py", line 182, in raise_ raise exception File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\engine\base.py", line 1277, in _execute_context cursor, statement, parameters, context File "c:\users\arroyosd\appdata\local\programs\python\python37\lib\site-packages\sqlalchemy\engine\default.py", line 609, in do_execute cursor.execute(statement, parameters) sqlalchemy.exc.InterfaceError: (sqlite3.InterfaceError) Error binding parameter 1 - probably unsupported type. [SQL: UPDATE payment2_player SET ranking_paid=?, item1=?, item2=? WHERE payment2_player.id = ?] [parameters: (1, [1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11], 10, 4)] (Background on this error at: http://sqlalche.me/e/13/rvf5)
#2 by arroycal
I sorted this - not sure how as I tried a few different things. Feel free to delete this post.