Le portail francophone de la géomatique

Bonsoir tout le monde,

Avec la nouvelle realease de Mapfish, je cherchais a experimenter la variante Studio en l'installant sur Ubuntu 9.10 tout en suivant pas a pas le tutorial. Je dois vous dire que tout se passe tres bien jus qu'a ce que je voitune erreur apres l'execution de la commande

paster setup-app development.ini .



pour etre precis, en dessous est le message:



(env)dener@ubuntu:~/mapfish_v2/Studio$ paster setup-app development.ini
Running setup_config() from studio.websetup
14:24:13,556 INFO  [studio.websetup] JavaScript successfully merged and minified in /home/dener/mapfish_v2/Studio/studio/public/js/Studio/studio-all.js
14:24:13,559 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("user")
14:24:13,559 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,560 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("layertemplate")
14:24:13,560 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,561 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("map")
14:24:13,561 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,562 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("mapfish")
14:24:13,562 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,562 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("datastore")
14:24:13,565 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,566 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("group")
14:24:13,566 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,566 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("usergroup")
14:24:13,566 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,567 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("permission")
14:24:13,567 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,567 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("grouppermission")
14:24:13,567 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,568 INFO  [sqlalchemy.engine.base.Engine.0x...962c] PRAGMA table_info("availport")
14:24:13,568 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ()
14:24:13,673 INFO  [sqlalchemy.engine.base.Engine.0x...962c] BEGIN
14:24:13,674 INFO  [sqlalchemy.engine.base.Engine.0x...962c] INSERT INTO "group" (name) VALUES (?)
14:24:13,674 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ['admin']
14:24:13,675 INFO  [sqlalchemy.engine.base.Engine.0x...962c] ROLLBACK
Traceback (most recent call last):
  File "/home/dener/mapfish_v2/env/bin/paster", line 8, in <module>
    load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster')()
  File "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/command.py", line 218, in run
    result = self.command()
  File "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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/dener/mapfish_v2/Studio/studio/websetup.py", line 154, in setup_app
    meta.Session.flush()
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/scoping.py", line 121, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py", line 1347, in flush
    self._flush(objects)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py", line 1417, in _flush
    flush_context.execute()
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 244, in execute
    UOWExecutor().execute(self, tasks)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 707, in execute
    self.execute_save_steps(trans, task)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 722, in execute_save_steps
    self.save_objects(trans, task)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 713, in save_objects
    task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/mapper.py", line 1352, in _save_obj
    c = connection.execute(statement.values(value_params), params)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 824, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 874, in _execute_clauseelement
    return self.__execute_context(context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 896, in __execute_context
    self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 950, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor, context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-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.IntegrityError: (IntegrityError) column name is not unique u'INSERT INTO "group" (name) VALUES (?)' ['admin']
(env)dener@ubuntu:~/mapfish_v2/Studio$ paster setup-app development.ini
Running setup_config() from studio.websetup
14:24:35,087 INFO  [studio.websetup] JavaScript successfully merged and minified in /home/dener/mapfish_v2/Studio/studio/public/js/Studio/studio-all.js
14:24:35,089 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("user")
14:24:35,090 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,091 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("layertemplate")
14:24:35,091 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,091 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("map")
14:24:35,091 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,092 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("mapfish")
14:24:35,092 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,092 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("datastore")
14:24:35,095 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,096 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("permission")
14:24:35,096 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,096 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("availport")
14:24:35,097 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,097 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("group")
14:24:35,097 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,097 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("grouppermission")
14:24:35,098 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,098 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] PRAGMA table_info("usergroup")
14:24:35,098 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ()
14:24:35,205 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] BEGIN
14:24:35,206 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] INSERT INTO "group" (name) VALUES (?)
14:24:35,207 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ['admin']
14:24:35,207 INFO  [sqlalchemy.engine.base.Engine.0x...e62c] ROLLBACK
Traceback (most recent call last):
  File "/home/dener/mapfish_v2/env/bin/paster", line 8, in <module>
    load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster')()
  File "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/command.py", line 218, in run
    result = self.command()
  File "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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/dener/mapfish_v2/Studio/studio/websetup.py", line 154, in setup_app
    meta.Session.flush()
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/scoping.py", line 121, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py", line 1347, in flush
    self._flush(objects)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py", line 1417, in _flush
    flush_context.execute()
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 244, in execute
    UOWExecutor().execute(self, tasks)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 707, in execute
    self.execute_save_steps(trans, task)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 722, in execute_save_steps
    self.save_objects(trans, task)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 713, in save_objects
    task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/mapper.py", line 1352, in _save_obj
    c = connection.execute(statement.values(value_params), params)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 824, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 874, in _execute_clauseelement
    return self.__execute_context(context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 896, in __execute_context
    self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 950, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor, context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-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.IntegrityError: (IntegrityError) column name is not unique u'INSERT INTO "group" (name) VALUES (?)' ['admin']
(env)dener@ubuntu:~/mapfish_v2/Studio$ paster setup-app development.ini
Running setup_config() from studio.websetup
14:26:30,795 INFO  [studio.websetup] JavaScript successfully merged and minified in /home/dener/mapfish_v2/Studio/studio/public/js/Studio/studio-all.js
14:26:30,798 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("user")
14:26:30,798 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,799 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("layertemplate")
14:26:30,799 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,800 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("map")
14:26:30,800 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,800 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("mapfish")
14:26:30,800 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,801 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("group")
14:26:30,804 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,804 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("usergroup")
14:26:30,804 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,805 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("datastore")
14:26:30,805 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,805 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("permission")
14:26:30,806 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,806 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("grouppermission")
14:26:30,806 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,807 INFO  [sqlalchemy.engine.base.Engine.0x...462c] PRAGMA table_info("availport")
14:26:30,807 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ()
14:26:30,921 INFO  [sqlalchemy.engine.base.Engine.0x...462c] BEGIN
14:26:30,922 INFO  [sqlalchemy.engine.base.Engine.0x...462c] INSERT INTO "group" (name) VALUES (?)
14:26:30,922 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ['admin']
14:26:30,923 INFO  [sqlalchemy.engine.base.Engine.0x...462c] ROLLBACK
Traceback (most recent call last):
  File "/home/dener/mapfish_v2/env/bin/paster", line 8, in <module>
    load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster')()
  File "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/command.py", line 218, in run
    result = self.command()
  File "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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/dener/mapfish_v2/Studio/studio/websetup.py", line 154, in setup_app
    meta.Session.flush()
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/scoping.py", line 121, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py", line 1347, in flush
    self._flush(objects)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py", line 1417, in _flush
    flush_context.execute()
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 244, in execute
    UOWExecutor().execute(self, tasks)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 707, in execute
    self.execute_save_steps(trans, task)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 722, in execute_save_steps
    self.save_objects(trans, task)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 713, in save_objects
    task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/mapper.py", line 1352, in _save_obj
    c = connection.execute(statement.values(value_params), params)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 824, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 874, in _execute_clauseelement
    return self.__execute_context(context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 896, in __execute_context
    self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 950, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor, context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-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.IntegrityError: (IntegrityError) column name is not unique u'INSERT INTO "group" (name) VALUES (?)' ['admin']
(env)dener@ubuntu:~/mapfish_v2/Studio$ paster setup-app development.ini
Running setup_config() from studio.websetup
14:26:44,789 INFO  [studio.websetup] JavaScript successfully merged and minified in /home/dener/mapfish_v2/Studio/studio/public/js/Studio/studio-all.js
14:26:44,791 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("user")
14:26:44,792 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,793 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("layertemplate")
14:26:44,793 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,793 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("map")
14:26:44,793 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,794 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("mapfish")
14:26:44,794 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,794 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("datastore")
14:26:44,797 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,798 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("availport")
14:26:44,798 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,798 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("permission")
14:26:44,799 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,799 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("group")
14:26:44,799 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,799 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("grouppermission")
14:26:44,800 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,800 INFO  [sqlalchemy.engine.base.Engine.0x...762c] PRAGMA table_info("usergroup")
14:26:44,800 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ()
14:26:44,907 INFO  [sqlalchemy.engine.base.Engine.0x...762c] BEGIN
14:26:44,908 INFO  [sqlalchemy.engine.base.Engine.0x...762c] INSERT INTO "group" (name) VALUES (?)
14:26:44,908 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ['admin']
14:26:44,908 INFO  [sqlalchemy.engine.base.Engine.0x...762c] ROLLBACK
Traceback (most recent call last):
  File "/home/dener/mapfish_v2/env/bin/paster", line 8, in <module>
    load_entry_point('PasteScript==1.7.3', 'console_scripts', 'paster')()
  File "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/PasteScript-1.7.3-py2.5.egg/paste/script/command.py", line 218, in run
    result = self.command()
  File "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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 "/home/dener/mapfish_v2/env/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/dener/mapfish_v2/Studio/studio/websetup.py", line 154, in setup_app
    meta.Session.flush()
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/scoping.py", line 121, in do
    return getattr(self.registry(), name)(*args, **kwargs)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py", line 1347, in flush
    self._flush(objects)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/session.py", line 1417, in _flush
    flush_context.execute()
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 244, in execute
    UOWExecutor().execute(self, tasks)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 707, in execute
    self.execute_save_steps(trans, task)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 722, in execute_save_steps
    self.save_objects(trans, task)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/unitofwork.py", line 713, in save_objects
    task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/orm/mapper.py", line 1352, in _save_obj
    c = connection.execute(statement.values(value_params), params)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 824, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 874, in _execute_clauseelement
    return self.__execute_context(context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 896, in __execute_context
    self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-py2.5.egg/sqlalchemy/engine/base.py", line 950, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor, context)
  File "/home/dener/mapfish_v2/env/lib/python2.5/site-packages/SQLAlchemy-0.5.2-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.IntegrityError: (IntegrityError) column name is not unique u'INSERT INTO "group" (name) VALUES (?)' ['admin']



Merci de penser a me depanner

FD

Dernière modification par Francois Dener (Thu 18 March 2010 21:01)