Hi, was too optimistic. After defining the mappers there is again an error: paster setup-app development.ini ... raise exc.DBAPIError.instance(statement, parameters, e, connection_invalidated=is_disconnect) sqlalchemy.exc.ProgrammingError: (ProgrammingError) relation "tg_permission_permission_id_seq" does not exist 'select nextval(\'"tg_permission_permission_id_seq"\')' None
setup-app creates my new tables in the db, but NOT anymore the authorization and permission tables. Regards Ernst On Sep 7, 1:30 pm, eka <[email protected]> wrote: > 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.
