Hello,
I've just setup a new server with a virtualenv containing TG1.0.8, SA,
MySQL... and I try to install one of my existing application already
running on another server.
When I issue
tg-admin --config=prod.cfg sql create
I get an error looking like if tg-admin tries to update the DB tables
before actually creating them...
If, within tg-admin shell, I do a metadata.tables['a_table'].create(),
the table is created, so it is not a db connection problem.
The problem does not exist with SQLite.
Any idea ?
TG 1.0.8
SA 0.4.6
Elixir 0.5.2
Here is the traceback :
(tg1.0env)r...@ns360028:/home/app01_user/app01# tg-admin
--config=prod.cfg sql create
Creating tables at mysql://xxx:x...@localhost/app01
Traceback (most recent call last):
File "/home/virtualenvs/tg1.0env/bin/tg-admin", line 8, in <module>
load_entry_point('TurboGears==1.0.8', 'console_scripts', 'tg-admin')()
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/TurboGears-1.0.8-py2.5.egg/turbogears/command/base.py",
line 400, in main
command.run()
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/TurboGears-1.0.8-py2.5.egg/turbogears/command/base.py",
line 103, in run
sacommand(command, sys.argv)
File "<string>", line 5, in sacommand
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/TurboGears-1.0.8-py2.5.egg/turbogears/command/sacommand.py",
line 42, in create
metadata.create_all()
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/schema.py",
line 1582, in create_all
bind.create(self, checkfirst=checkfirst, tables=tables)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/engine/base.py",
line 1139, in create
self._run_visitor(self.dialect.schemagenerator, entity,
connection=connection, **kwargs)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/engine/base.py",
line 1168, in _run_visitor
visitorcallable(self.dialect, conn, **kwargs).traverse(element)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/sql/visitors.py",
line 75, in traverse
return self._non_cloned_traversal(obj)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/sql/visitors.py",
line 134, in _non_cloned_traversal
self.traverse_single(target)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/sql/visitors.py",
line 35, in traverse_single
return meth(obj, **kwargs)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/sql/compiler.py",
line 756, in visit_metadata
collection = [t for t in metadata.table_iterator(reverse=False,
tables=self.tables) if (not self.checkfirst or not
self.dialect.has_table(self.connection, t.name, schema=t.schema))]
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/databases/mysql.py",
line 1587, in has_table
rs = connection.execute(st)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/engine/base.py",
line 844, in execute
return Connection.executors[c](self, object, multiparams, params)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/engine/base.py",
line 854, in _execute_text
self.__execute_raw(context)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/engine/base.py",
line 916, in __execute_raw
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/engine/base.py",
line 960, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor)
File
"/home/virtualenvs/tg1.0env/lib/python2.5/site-packages/SQLAlchemy-0.4.6-py2.5.egg/sqlalchemy/engine/base.py",
line 942, in _handle_dbapi_exception
raise exceptions.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
sqlalchemy.exceptions.ProgrammingError: (ProgrammingError) (1146, "Table
'app01.prospect_history' doesn't exist") 'DESCRIBE `prospect_history`' {}
(tg1.0env)r...@ns360028:/home/app01_user/app01#
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" 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/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
