On Fri, Mar 13, 2009 at 2:31 AM, Edel SM <[email protected]> wrote: > > for the meantime, it seems my workaround is set > meta.metadata.create_all(checkfirst=False) in setup_app function of > websetup.py.
I wonder if it would be a good idea to have an installation Troubleshooting section and FAQ somewhere? It might be nice to post common gotchas for people when they first get started somewhere... > > > 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 > > > > -- Cheers, Noah --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
