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 at
http://groups.google.com/group/pylons-discuss?hl=en.
