I having an error when connecting to database by using houdini. Nuke and maya have no this problem!!
Here is the error.
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "\anima\anima\ui\scripts\houdini.py", line 50, in version_creator
do_db_setup()
File "\anima\anima\utils\__init__.py", line 253, in do_db_setup
db.setup(settings)
File "\python_lib\stalker\db\__init__.py", line 78, in setup
update_defaults_with_studio()
File "\anima_pipe\python_lib\stalker\db\__init__.py", line 93, in update_defaults_with_studio
studio = DBSession.query(Studio).first()
File \anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2755, in first
ret = list(self[0:1])
File "\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2547, in __getitem__
return list(res)
File "\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2855, in __iter__
return self._execute_and_instances(context)
File "\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 945, in execute
return meth(self, multiparams, params)
File "\anima_pipe\python_lib\sqlalchemy\sql\elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1189, in _execute_context
context)
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1402, in _handle_dbapi_exception
exc_info
File "\anima_pipe\python_lib\sqlalchemy\util\compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1182, in _execute_context
context)
File "\anima_pipe\python_lib\sqlalchemy\engine\default.py", line 470, in do_execute
cursor.execute(statement, parameters)
OperationalError: (sqlite3.OperationalError) no such table: SimpleEntities [SQL: u'SELECT "Studios".id AS "Studios_id", "Studios".timing_resolution AS "Studios_timing_resolution", "Studios".start AS "Studios_start", "Studios".duration AS "Studios_duration", "Studios"."end" AS "Studios_end", "Entities".id AS "E
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "\anima\anima\ui\scripts\houdini.py", line 61, in version_creator
h = houdini.Houdini()
File "\anima\anima\env\houdini.py", line 23, in __init__
for repo in Repository.query.all():
File "\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2703, in all
return list(self)
File "\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2855, in __iter__
return self._execute_and_instances(context)
File "\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 945, in execute
return meth(self, multiparams, params)
File "\anima_pipe\python_lib\sqlalchemy\sql\elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1189, in _execute_context
context)
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1402, in _handle_dbapi_exception
exc_info
File "\anima_pipe\python_lib\sqlalchemy\util\compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1182, in _execute_context
context)
File "\anima_pipe\python_lib\sqlalchemy\engine\default.py", line 470, in do_execute
cursor.execute(statement, parameters)
OperationalError: (sqlite3.OperationalError) no such table: SimpleEntities [SQL: u'SELECT "Repositories".id AS "Repositories_id", "Entities".id AS "Entities_id", "SimpleEntities".stalker_version AS "SimpleEntities_stalker_version", "SimpleEntities".id AS "SimpleEntities_id", "SimpleEntities".entity_type AS "SimpleEntitie
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "K:\SES\Library\anima_pipe\anima\anima\ui\scripts\houdini.py", line 61, in version_creator
h = houdini.Houdini()
File "K:\SES\Library\anima_pipe\anima\anima\env\houdini.py", line 23, in __init__
for repo in Repository.query.all():
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2703, in all
return list(self)
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2855, in __iter__
return self._execute_and_instances(context)
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\orm\query.py", line 2878, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 945, in execute
return meth(self, multiparams, params)
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\sql\elements.py", line 263, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1053, in _execute_clauseelement
compiled_sql, distilled_params
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1189, in _execute_context
context)
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1402, in _handle_dbapi_exception
exc_info
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\util\compat.py", line 203, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\engine\base.py", line 1182, in _execute_context
context)
File "K:\SES\Library\anima_pipe\python_lib\sqlalchemy\engine\default.py", line 470, in do_execute
cursor.execute(statement, parameters)
OperationalError: (sqlite3.OperationalError) no such table: SimpleEntities [SQL: u'SELECT "Repositories".id AS "Repositories_id", "Entities".id AS "Entities_id", "SimpleEntities".stalker_version AS "SimpleEntities_stalker_version", "SimpleEntities".id AS "SimpleEntities_id", "SimpleEntities".entity_type AS "SimpleEntitie
in houdini python shell
>>> from stalker import db
>>> db.init()
Traceback (most recent call last):
File "<console>", line 1, in <module>
File \python_lib\stalker\db\__init__.py", line 124, in i
nit
register(class_)
File "\python_lib\stalker\db\__init__.py", line 525, in r
egister
permissions_db = Permission.query.all()
File "\python_lib\sqlalchemy\orm\query.py", line 2703, in
all
return list(self)
File "\python_lib\sqlalchemy\orm\query.py", line 2855, in
__iter__
return self._execute_and_instances(context)
File "\python_lib\sqlalchemy\orm\query.py", line 2876, in
_execute_and_instances
close_with_result=True)
File "\python_lib\sqlalchemy\orm\query.py", line 2885, in
_get_bind_args
**kw
File "\python_lib\sqlalchemy\orm\query.py", line 2867, in
_connection_from_session
conn = self.session.connection(**kw)
File "\python_lib\sqlalchemy\orm\session.py", line 994, i
n connection
bind = self.get_bind(mapper, clause=clause, **kw)
File "\python_lib\sqlalchemy\orm\session.py", line 1356,
in get_bind
', '.join(context)))
UnboundExecutionError: Could not locate a bind configured on mapper Mapper|Permissio
n|Permissions, SQL expression or this Session
HI,
I having an error when connecting to database by using houdini. Nuke and maya have no this problem!!
Here is the error.
in houdini python shell