Hey guys,
When i try to run "paster setup-app deployment.ini" i get the following:
Traceback (most recent call last):
File "/var/www/python/mediacore_env/bin/paster", line 8, in <module>
load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster')()
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/command.py", line 84, in run
invoke(command, command_name, options, args[1:])
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/command.py", line 123, in invoke
exit_code = runner.run(args)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/appinstall.py", line 68, in run
return super(AbstractInstallCommand, self).run(new_args)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/command.py", line 218, in run
result = self.command()
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/appinstall.py", line 456, in command
self, config_file, section, self.sysconfig_install_vars(installer))
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/appinstall.py", line 598, in setup_config
mod.setup_app, command, filename, section, vars)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/PasteScript-1.7.3-py2.6.egg/paste/script/appinstall.py", line 612, in _call_setup_app
func(command, conf, vars)
File "/var/www/python/tubetube_mc/mediacore/websetup.py", line 111, in setup_app
metadata.create_all(bind=DBSession.bind, checkfirst=True)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/schema.py", line 2147, in create_all
bind.create(self, checkfirst=checkfirst, tables=tables)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/base.py", line 1698, in create
connection=connection, **kwargs)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/base.py", line 1740, in _run_visitor
**kwargs).traverse_single(element)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/sql/visitors.py", line 77, in traverse_single
return meth(obj, **kw)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/ddl.py", line 42, in visit_metadata
self.traverse_single(table, create_ok=True)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/sql/visitors.py", line 77, in traverse_single
return meth(obj, **kw)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/ddl.py", line 58, in visit_table
self.connection.execute(schema.CreateTable(table))
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/base.py", line 1191, in execute
params)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/base.py", line 1244, in _execute_ddl
return self.__execute_context(context)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/base.py", line 1302, in __execute_context
context.parameters[0], context=context)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/base.py", line 1401, in _cursor_execute
context)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/base.py", line 1394, in _cursor_execute
context)
File "/var/www/python/mediacore_env/lib/python2.6/site-packages/SQLAlchemy-0.6.5-py2.6.egg/sqlalchemy/engine/default.py", line 299, in do_execute
cursor.execute(statement, parameters)
File "build/bdist.linux-x86_64/egg/MySQLdb/cursors.py", line 174, in execute
File "build/bdist.linux-x86_64/egg/MySQLdb/connections.py", line 36, in defaulterrorhandler
sqlalchemy.exc.OperationalError: (OperationalError) (1005, "Can't create table 'tubetube_mc.media_meta' (errno: 150)") '\nCREATE TABLE media_meta (\n\tid INTEGER NOT NULL AUTO_INCREMENT, \n\tmedia_id INTEGER NOT NULL, \n\tkey VARCHAR(64) NOT NULL, \n\tvalue TEXT, \n\tPRIMARY KEY (id), \n\tFOREIGN KEY(media_id) REFERENCES media (id) ON DELETE CASCADE ON UPDATE CASCADE\n)ENGINE=InnoDB CHARSET=utf8\n\n' ()
I tried setting my default table type to inno-db but that didnt seem to make any difference.