#2296: sqlite db creation error in wiki20 tutorial
------------------------+---------------------------------------------------
Reporter: xpixelz | Owner:
Type: defect | Status: new
Priority: normal | Milestone: 2.1a1
Component: TurboGears | Version: 2.0b7
Severity: normal | Resolution:
Keywords: |
------------------------+---------------------------------------------------
Comment (by Twey):
To reproduce:
1) Quickstart a project.
2) Edit the models to create a table with DeclarativeBase as described in
the tutorial.
3) Run paster setup-app development.ini.
Trace:
(tg2env)[@ twey peordh ] % paster setup-app development.ini % [P
~/Development/Web/tcc/turbo/twey.co.uk ] [J 3 ] [L 772 ]
/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/tw/core/view.py:202: DeprecationWarning: object.__new__() takes
no parameters
obj = object.__new__(cls, *args, **kw)
/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/peak/rules/indexing.py:220: DeprecationWarning: object.__new__()
takes no parameters
return super(BitmapIndex, cls).__new__(cls, engine, expr)
Running setup_config() from tcc.websetup
Creating tables
06:59:30,506 INFO [sqlalchemy.engine.base.Engine.0x...7610] PRAGMA
table_info("pages")
06:59:30,510 INFO [sqlalchemy.engine.base.Engine.0x...7610] ()
06:59:30,511 INFO [sqlalchemy.engine.base.Engine.0x...7610] ROLLBACK
Traceback (most recent call last):
File "/home/twey/Development/Web/tcc/turbo/tg2env/bin/paster", line 8,
in <module>
load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster')()
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/paste/script/command.py", line 84, in run
invoke(command, command_name, options, args[1:])
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/paste/script/command.py", line 123, in invoke
exit_code = runner.run(args)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/paste/script/appinstall.py", line 68, in run
return super(AbstractInstallCommand, self).run(new_args)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/paste/script/command.py", line 218, in run
result = self.command()
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/paste/script/appinstall.py", line 456, in command
self, config_file, section, self.sysconfig_install_vars(installer))
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/paste/script/appinstall.py", line 598, in setup_config
mod.setup_app, command, filename, section, vars)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/paste/script/appinstall.py", line 612, in _call_setup_app
func(command, conf, vars)
File "/home/twey/Development/Web/tcc/turbo/twey.co.uk/tcc/websetup.py",
line 22, in setup_app
model.metadata.create_all(bind=config['pylons.app_globals'].sa_engine)#,
checkfirst=False)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/schema.py", line 1765, in
create_all
bind.create(self, checkfirst=checkfirst, tables=tables)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py", line 1129,
in create
self._run_visitor(self.dialect.schemagenerator, entity,
connection=connection, **kwargs)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py", line 1158,
in _run_visitor
visitorcallable(self.dialect, conn, **kwargs).traverse(element)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/sql/visitors.py", line 89,
in traverse
return traverse(obj, self.__traverse_options__, self._visitor_dict)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/sql/visitors.py", line 200,
in traverse
return traverse_using(iterate(obj, opts), obj, visitors)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/sql/visitors.py", line 194,
in traverse_using
meth(target)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.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 "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.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 "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/databases/sqlite.py", line
443, in has_table
row = cursor.fetchone()
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.egg/sqlalchemy/engine/base.py", line 1668,
in fetchone
self.connection._handle_dbapi_exception(e, None, None, self.cursor,
self.context)
File "/home/twey/Development/Web/tcc/turbo/tg2env/lib/python2.6/site-
packages/SQLAlchemy-0.5.2-py2.6.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
Platform information:
Linux peordh 2.6.30-ARCH #1 SMP PREEMPT Fri Jul 31 07:30:28 CEST 2009
x86_64 AMD Athlon(tm) 64 X2 Dual Core Processor 5000+ AuthenticAMD
GNU/Linux
--
Ticket URL: <http://trac.turbogears.org/ticket/2296#comment:2>
TurboGears <http://www.turbogears.org/>
TurboGears front-to-back web development
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "TurboGears Tickets" group.
This group is read-only. No posting by normal members allowed.
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/turbogears-tickets?hl=en?hl=en
-~----------~----~----~----~------~----~------~--~---
