oTree Forum >

issue when switching from otree versions

#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.

Write a reply

Set forum username