Easy fix, love the red herring though: easy_install -U sqlalchemy
On Apr 22, 2:19 pm, gazza <[email protected]> wrote: > Hello, > > I had to porte my VPS to another VPS and now I'm hitting some problems > when attempting to reconstruct the database again. Any ideas on how to > resolve this would help. > > >paster setup-app development.ini > > Running setup_config() from nofussdining.websetup > 15:13:02,589 INFO [sqlalchemy.engine.base.Engine.0x...af4c] PRAGMA > table_info("images") > 15:13:02,589 INFO [sqlalchemy.engine.base.Engine.0x...af4c] () > 15:13:02,590 INFO [sqlalchemy.engine.base.Engine.0x...af4c] ROLLBACK > Traceback (most recent call last): > File "/usr/local/bin/paster", line 8, in <module> > load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster') > () > File "/usr/local/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 "/usr/local/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 "/usr/local/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 "/usr/local/lib/python2.5/site-packages/PasteScript-1.7.3- > py2.5.egg/paste/script/command.py", line 218, in run > result = self.command() > File "/usr/local/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 "/usr/local/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 "/usr/local/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 "/root/production/NoFussDining/nofussdining/websetup.py", line > 20, in setup_app > meta.metadata.create_all() > File "/usr/local/lib/python2.5/site-packages/sqlalchemy/schema.py", > line 1765, in create_all > bind.create(self, checkfirst=checkfirst, tables=tables) > File "/usr/local/lib/python2.5/site-packages/sqlalchemy/engine/ > base.py", line 1129, in create > self._run_visitor(self.dialect.schemagenerator, entity, > connection=connection, **kwargs) > File "/usr/local/lib/python2.5/site-packages/sqlalchemy/engine/ > base.py", line 1158, in _run_visitor > visitorcallable(self.dialect, conn, **kwargs).traverse(element) > File "/usr/local/lib/python2.5/site-packages/sqlalchemy/sql/ > visitors.py", line 89, in traverse > return traverse(obj, self.__traverse_options__, > self._visitor_dict) > File "/usr/local/lib/python2.5/site-packages/sqlalchemy/sql/ > visitors.py", line 200, in traverse > return traverse_using(iterate(obj, opts), obj, visitors) > File "/usr/local/lib/python2.5/site-packages/sqlalchemy/sql/ > visitors.py", line 194, in traverse_using > meth(target) > File "/usr/local/lib/python2.5/site-packages/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 "/usr/local/lib/python2.5/site-packages/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 "/usr/local/lib/python2.5/site-packages/sqlalchemy/databases/ > sqlite.py", line 443, in has_table > row = cursor.fetchone() > File "/usr/local/lib/python2.5/site-packages/sqlalchemy/engine/ > base.py", line 1668, in fetchone > self.connection._handle_dbapi_exception(e, None, None, > self.cursor, self.context) > File "/usr/local/lib/python2.5/site-packages/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 > > -- > 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 > athttp://groups.google.com/group/pylons-discuss?hl=en. -- 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.
