Skip to content

Instantly share code, notes, and snippets.

@fakedrake
Created August 14, 2012 22:44
Show Gist options
  • Save fakedrake/3353661 to your computer and use it in GitHub Desktop.
Save fakedrake/3353661 to your computer and use it in GitHub Desktop.
Error initializing database
[fakedrake@Keep ~/Projects/python/webdev/pyramid/pyramida/belogeh/FooDooBlog]$ ../bin/initialize_FooDooBlog_db development.ini
2012-08-15 01:42:09,086 INFO [sqlalchemy.engine.base.Engine][MainThread] PRAGMA table_info("posts")
2012-08-15 01:42:09,086 INFO [sqlalchemy.engine.base.Engine][MainThread] ()
2012-08-15 01:42:09,087 INFO [sqlalchemy.engine.base.Engine][MainThread] BEGIN (implicit)
2012-08-15 01:42:09,088 INFO [sqlalchemy.engine.base.Engine][MainThread] INSERT INTO posts (name, title, body, view_count) VALUES (?, ?, ?, ?)
2012-08-15 01:42:09,088 INFO [sqlalchemy.engine.base.Engine][MainThread] ('one', 'The One', '"One Ring to rule them all, One Ring to find them,\nOne Ring to bring them all and in the darkness bind them', 0)
2012-08-15 01:42:09,088 INFO [sqlalchemy.engine.base.Engine][MainThread] ROLLBACK
Traceback (most recent call last):
File "../bin/initialize_FooDooBlog_db", line 8, in <module>
load_entry_point('FooDooBlog==0.0', 'console_scripts', 'initialize_FooDooBlog_db')()
File "/home/fakedrake/Projects/python/webdev/pyramid/pyramida/belogeh/FooDooBlog/foodooblog/scripts/initializedb.py", line 39, in main
DBSession.add(post)
File "/home/fakedrake/Projects/python/webdev/pyramid/pyramida/belogeh/lib/python2.7/site-packages/transaction-1.3.0-py2.7.egg/transaction/_manager.py", line 116, in __exit__
self.commit()
File "/home/fakedrake/Projects/python/webdev/pyramid/pyramida/belogeh/lib/python2.7/site-packages/transaction-1.3.0-py2.7.egg/transaction/_manager.py", line 107, in commit
return self.get().commit()
File "/home/fakedrake/Projects/python/webdev/pyramid/pyramida/belogeh/lib/python2.7/site-packages/transaction-1.3.0-py2.7.egg/transaction/_transaction.py", line 354, in commit
reraise(t, v, tb)
File "/home/fakedrake/Projects/python/webdev/pyramid/pyramida/belogeh/lib/python2.7/site-packages/transaction-1.3.0-py2.7.egg/transaction/_transaction.py", line 345, in commit
self._commitResources()
File "/home/fakedrake/Projects/python/webdev/pyramid/pyramida/belogeh/lib/python2.7/site-packages/transaction-1.3.0-py2.7.egg/transaction/_transaction.py", line 493, in _commitResources
reraise(t, v, tb)
File "/home/fakedrake/Projects/python/webdev/pyramid/pyramida/belogeh/lib/python2.7/site-packages/transaction-1.3.0-py2.7.egg/transaction/_transaction.py", line 465, in _commitResources
rm.tpc_begin(self)
File "/home/fakedrake/Projects/python/webdev/pyramid/pyramida/belogeh/lib/python2.7/site-packages/zope.sqlalchemy-0.7.1-py2.7.egg/zope/sqlalchemy/datamanager.py", line 86, in tpc_begin
self.session.flush()
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/session.py", line 1583, in flush
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/session.py", line 1654, in _flush
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/unitofwork.py", line 331, in execute
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/unitofwork.py", line 475, in execute
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/persistence.py", line 64, in save_obj
File "build/bdist.linux-x86_64/egg/sqlalchemy/orm/persistence.py", line 558, in _emit_insert_statements
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1449, in execute
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1584, in _execute_clauseelement
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1698, in _execute_context
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/base.py", line 1691, in _execute_context
File "build/bdist.linux-x86_64/egg/sqlalchemy/engine/default.py", line 331, in do_execute
sqlalchemy.exc.OperationalError: (OperationalError) table posts has no column named view_count u'INSERT INTO posts (name, title, body, view_count) VALUES (?, ?, ?, ?)' ('one', 'The One', '"One Ring to rule them all, One Ring to find them,\nOne Ring to bring them all and in the darkness bind them', 0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment