Hi, I think the sqlalchemy.exc.ProgrammingError: (ProgrammingError) relation "tg_group_group_id_seq" does not exist occurs because I have defined classes and tables but no mapper. If so then the error message was not very helpfull.
Thanks Ernst On Sep 7, 1:34 am, eka <[email protected]> wrote: > Hi All, > I follow the movies tutorial > athttp://www.turbogears.org/2.1/docs/main/movie_tutorial.html > I had to overcome a few installation problems with python setup.py > develop > by doing: > > $ easy_install PEAK-Rules > $ easy_install WebHelpers > > But then it fails during paster setup-app development.ini > Although I have not touched anything in t he area of user > authorization. > > I do not yet know enough to see what I need to fix. > > (movies)er...@--:~/turbo2/movies/movies$ paster setup-app > development.ini > /usr/bin/paster:5: UserWarning: Module site was already imported from / > usr/lib/python2.5/site.pyc, but /usr/lib/python2.5/site-packages is > being added to sys.path > from pkg_resources import load_entry_point > Running setup_config() from movies.websetup > Creating tables > 01:27:17,947 INFO [sqlalchemy.engine.base.Engine.0x...3cec] BEGIN > 01:27:17,952 INFO [sqlalchemy.engine.base.Engine.0x...3cec] select > nextval('"tg_group_group_id_seq"') > 01:27:17,952 INFO [sqlalchemy.engine.base.Engine.0x...3cec] None > 01:27:17,957 INFO [sqlalchemy.engine.base.Engine.0x...3cec] ROLLBACK > Traceback (most recent call last): > File "/usr/bin/paster", line 8, in <module> > load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster') > () > File "/usr/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/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/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/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/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/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/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 "/home/ernst/turbo2/movies/movies/movies/websetup.py", line 54, > in setup_app > model.DBSession.flush() > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/orm/scoping.py", line 127, in do > return getattr(self.registry(), name)(*args, **kwargs) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/orm/session.py", line 1354, in flush > self._flush(objects) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/orm/session.py", line 1432, in _flush > flush_context.execute() > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/orm/unitofwork.py", line 261, in execute > UOWExecutor().execute(self, tasks) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/orm/unitofwork.py", line 753, in execute > self.execute_save_steps(trans, task) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/orm/unitofwork.py", line 768, in execute_save_steps > self.save_objects(trans, task) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/orm/unitofwork.py", line 759, in save_objects > task.mapper._save_obj(task.polymorphic_tosave_objects, trans) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/orm/mapper.py", line 1428, in _save_obj > c = connection.execute(statement.values(value_params), params) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/engine/base.py", line 824, in execute > return Connection.executors[c](self, object, multiparams, params) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/engine/base.py", line 872, in _execute_clauseelement > parameters=params > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/engine/base.py", line 938, in __create_execution_context > return dialect.execution_ctx_cls(dialect, connection=self, > **kwargs) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/engine/default.py", line 172, in __init__ > self.__process_defaults() > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/engine/default.py", line 359, in __process_defaults > val = drunner.get_column_default(c) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/databases/postgres.py", line 907, in get_column_default > return self.execute_string(exc.encode(self.dialect.encoding)) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/engine/base.py", line 1861, in execute_string > conn._cursor_execute(self.cursor, stmt, params) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.egg/ > sqlalchemy/engine/base.py", line 950, in _cursor_execute > self._handle_dbapi_exception(e, statement, parameters, cursor, > context) > File "/usr/lib/python2.5/site-packages/SQLAlchemy-0.5.8-py2.5.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) relation > "tg_group_group_id_seq" does not exist > 'select nextval(\'"tg_group_group_id_seq"\')' None -- 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.
