Comment 1 for bug 330896

Revision history for this message
David Robert Lewis (afrodeity) wrote :

got this anomoly trying to setup

ibid@afrodeity-desktop:~/Kubrick$ ibid-setup
INFO:core.config:Loaded configuration from ibid.ini
INFO:core.config:Loaded configuration from local.ini
Loading plugins...
INFO:core.databases:Loaded ibid database
Database tables created

Now we need to create an account for you in the bot so it knows who its
master is. This account will be given full admin permissions.
Please enter the details for your account.
Your IRC Nick/Jabber ID: afrodeity
Source name: freenode
Password to identify yourself to the bot:
Confirm password:
Traceback (most recent call last):
  File "/usr/bin/ibid-setup", line 171, in <module>
    session.commit()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 673, in commit
    self.transaction.commit()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 378, in commit
    self._prepare_impl()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 362, in _prepare_impl
    self.session.flush()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 1354, in flush
    self._flush(objects)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/session.py", line 1432, in _flush
    flush_context.execute()
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 257, in execute
    UOWExecutor().execute(self, tasks)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 720, in execute
    self.execute_save_steps(trans, task)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 735, in execute_save_steps
    self.save_objects(trans, task)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/unitofwork.py", line 726, in save_objects
    task.mapper._save_obj(task.polymorphic_tosave_objects, trans)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/orm/mapper.py", line 1387, in _save_obj
    c = connection.execute(statement.values(value_params), params)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 824, in execute
    return Connection.executors[c](self, object, multiparams, params)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 874, in _execute_clauseelement
    return self.__execute_context(context)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 896, in __execute_context
    self._cursor_execute(context.cursor, context.statement, context.parameters[0], context=context)
  File "/usr/lib/pymodules/python2.6/sqlalchemy/engine/base.py", line 950, in _cursor_execute
    self._handle_dbapi_exception(e, statement, parameters, cursor, context)
  File "/usr/lib/pymodules/python2.6/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 username is not unique u'INSERT INTO accounts (username) VALUES (?)' [u'afrodeity']
ibid@afrodeity-desktop:~/Kubrick$