for the meantime, it seems my workaround is set meta.metadata.create_all(checkfirst=False) in setup_app function of websetup.py.
thanks. On Thu, Mar 12, 2009 at 7:24 PM, Edel SM <[email protected]> wrote: > hi to all, > > im new to pylons and python in general. > > i encoutered error while running 'paster setup-app development.ini'. > this is working fine before i did easyinstall -U <packages> (Pylons, > pysqlite, sqlalchemy, etc) last night. > > im using activepython 2.5.2 on hardy x86_64. google is not helping me. > thank you. > > here's the traceback: > > (apy)$ rm -f development.db; paster setup-app development.ini > Running setup_config() from plrepo.websetup > 19:15:25,351 INFO [sqlalchemy.engine.base.Engine.0x...7890] PRAGMA > table_info("_organizations") > 19:15:25,351 INFO [sqlalchemy.engine.base.Engine.0x...7890] () > 19:15:25,351 INFO [sqlalchemy.engine.base.Engine.0x...7890] ROLLBACK > Traceback (most recent call last): > File "/opt/apps/ubuntu/x64/hardy/apy/bin/paster", line 8, in <module> > load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster')() > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/command.py", > line 84, in run > invoke(command, command_name, options, args[1:]) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/command.py", > line 123, in invoke > exit_code = runner.run(args) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/appinstall.py", > line 68, in run > return super(AbstractInstallCommand, self).run(new_args) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/command.py", > line 218, in run > result = self.command() > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/appinstall.py", > line 456, in command > self, config_file, section, self.sysconfig_install_vars(installer)) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/appinstall.py", > line 598, in setup_config > mod.setup_app, command, filename, section, vars) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/appinstall.py", > line 612, in _call_setup_app > func(command, conf, vars) > File > "/disks/mx80-home/edel.ubuntu/kuti.kuti/icdm/prj/pl-repo/plrepo/websetup.py", > line 23, in setup_app > meta.metadata.create_all(checkfirst=True) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/schema.py", > line 1765, in create_all > bind.create(self, checkfirst=checkfirst, tables=tables) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", > line 1129, in create > self._run_visitor(self.dialect.schemagenerator, entity, > connection=connection, **kwargs) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", > line 1158, in _run_visitor > visitorcallable(self.dialect, conn, **kwargs).traverse(element) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/sql/visitors.py", > line 89, in traverse > return traverse(obj, self.__traverse_options__, self._visitor_dict) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/sql/visitors.py", > line 200, in traverse > return traverse_using(iterate(obj, opts), obj, visitors) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/sql/visitors.py", > line 194, in traverse_using > meth(target) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/sql/compiler.py", > line 795, in visit_metadata > collection = [t for t in sql_util.sort_tables(tables) if > self._can_create(t)] > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/sql/compiler.py", > line 788, in _can_create > return not self.checkfirst or not > self.dialect.has_table(self.connection, table.name, > schema=table.schema) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/databases/sqlite.py", > line 443, in has_table > row = cursor.fetchone() > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", > line 1668, in fetchone > self.connection._handle_dbapi_exception(e, None, None, > self.cursor, self.context) > File > "/opt/apps/ubuntu/x64/hardy/apy/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", > line 931, in _handle_dbapi_exception > raise exc.DBAPIError.instance(statement, parameters, e, > connection_invalidated=is_disconnect) > sqlalchemy.exc.ProgrammingError: (ProgrammingError) Cannot operate on > a closed cursor. None None > (apy)$ > > -- > edel > -- edel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "pylons-discuss" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/pylons-discuss?hl=en -~----------~----~----~----~------~----~------~--~---
