Stuff

Traceback (most recent call last):
  File "/var/www/html/admin/accounts/userbox.cgi", line 180, in do_action
    field_values)
  File "/var/www/html/admin/accounts/pgdb.py", line 184, in execute
    self.executemany(operation, (params,))
  File "/var/www/html/admin/accounts/pgdb.py", line 199, in executemany
    rows = self.__source.execute(sql)
ProgrammingError: ERROR:  duplicate key violates unique constraint "person_email_key"


SELECT * FROM person WHERE username = 'vigneshm' --> -->
Your full name: 	

 
 
ProgrammingError	Python 2.3.4: /usr/bin/python2
Mon Apr 30 19:37:31 2007

A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.

 /var/www/html/admin/accounts/userbox.cgi
  302     if action_error:
  303         print action_error
  304     do_form(form, fields, action, got_submit)
  305     if username and action=='edit':
  306         website.handle_group_mods(dbh, form, 'userbox.cgi', username,
do_form = <function do_form>, form = FieldStorage(None, None, [FieldStorage('human_na... ''), FieldStorage('_createme', None, 'Submit')]), fields = ({'can_edit': 0, 'check': <function check_notempty>, 'desc': 'Your full name', 'maxlen': 50, 'name': 'human_name'}, {'can_edit': 0, 'check': <function check_username>, 'desc': 'Username', 'maxlen': 8, 'name': 'username'}, {'check': <function check_email>, 'desc': 'E-mail address', 'maxlen': 80, 'name': 'email', 'notes': 'Your E-mail address must be the one you use for your GPG key and bugzilla account'}, {'check': <function check_notempty>, 'desc': 'Postal Address', 'maxlen': 1024, 'name': 'postal_address'}, {'check': <function check_notempty>, 'desc': 'Telephone', 'maxlen': 128, 'name': 'telephone'}, {'desc': 'Facsimile', 'maxlen': 128, 'name': 'facsimile'}, {'desc': 'Affiliation', 'maxlen': 64, 'name': 'affiliation'}, {'check': <function check_gpg_keyid>, 'desc': '<a href="http://fedoraproject.org/wiki/DocsProject/UsingGpg/CreatingKeys">GPG KeyID</a>', 'maxlen': 16, 'name': 'gpg_keyid'}, {'check': <function check_sshkey>, 'desc': 'SSHv2 Public Key (attach your ~/.ssh/id_dsa.pub file here)', 'maxlen': 2048, 'name': 'ssh_key', 'strip': 1, 'type': 'file'}, {'check': <function check_notempty_onnew>, 'desc': 'Password', 'edit_reuse': 0, 'maxlen': 20, 'name': 'password', 'type': 'password'}, {'check': <function check_double_password>, 'db_field': 0, 'desc': 'Password (again)', 'edit_reuse': 0, 'maxlen': 20, 'name': 'password_check', 'type': 'password'}, {'desc': 'IRC nickname', 'maxlen': 32, 'name': 'ircnick'}, {'desc': 'Comments', 'maxlen': 1024, 'name': 'comments', 'skip_empty': 0}), action = 'create', got_submit = 1

 /var/www/html/admin/accounts/userbox.cgi in do_form(form=FieldStorage(None, None, [FieldStorage('human_na... ''), FieldStorage('_createme', None, 'Submit')]), fields=({'can_edit': 0, 'check': <function check_notempty>, 'desc': 'Your full name', 'maxlen': 50, 'name': 'human_name'}, {'can_edit': 0, 'check': <function check_username>, 'desc': 'Username', 'maxlen': 8, 'name': 'username'}, {'check': <function check_email>, 'desc': 'E-mail address', 'maxlen': 80, 'name': 'email', 'notes': 'Your E-mail address must be the one you use for your GPG key and bugzilla account'}, {'check': <function check_notempty>, 'desc': 'Postal Address', 'maxlen': 1024, 'name': 'postal_address'}, {'check': <function check_notempty>, 'desc': 'Telephone', 'maxlen': 128, 'name': 'telephone'}, {'desc': 'Facsimile', 'maxlen': 128, 'name': 'facsimile'}, {'desc': 'Affiliation', 'maxlen': 64, 'name': 'affiliation'}, {'check': <function check_gpg_keyid>, 'desc': '<a href="http://fedoraproject.org/wiki/DocsProject/UsingGpg/CreatingKeys">GPG KeyID</a>', 'maxlen': 16, 'name': 'gpg_keyid'}, {'check': <function check_sshkey>, 'desc': 'SSHv2 Public Key (attach your ~/.ssh/id_dsa.pub file here)', 'maxlen': 2048, 'name': 'ssh_key', 'strip': 1, 'type': 'file'}, {'check': <function check_notempty_onnew>, 'desc': 'Password', 'edit_reuse': 0, 'maxlen': 20, 'name': 'password', 'type': 'password'}, {'check': <function check_double_password>, 'db_field': 0, 'desc': 'Password (again)', 'edit_reuse': 0, 'maxlen': 20, 'name': 'password_check', 'type': 'password'}, {'desc': 'IRC nickname', 'maxlen': 32, 'name': 'ircnick'}, {'desc': 'Comments', 'maxlen': 1024, 'name': 'comments', 'skip_empty': 0}), action='create', got_submit=1)
  129             cfunc = I.get('check')
  130             if cfunc:
  131                 objection = cfunc(form, I, curval, action)
  132         print "<tr><td align=left valign=top>"
  133         the_desc = I['desc']
objection = None, cfunc = <function check_username>, form = FieldStorage(None, None, [FieldStorage('human_na... ''), FieldStorage('_createme', None, 'Submit')]), I = {'can_edit': 0, 'check': <function check_username>, 'desc': 'Username', 'maxlen': 8, 'name': 'username'}, curval = 'vigneshm', action = 'create'

 /var/www/html/admin/accounts/userbox.cgi in check_username(form=FieldStorage(None, None, [FieldStorage('human_na... ''), FieldStorage('_createme', None, 'Submit')]), field_info={'can_edit': 0, 'check': <function check_username>, 'desc': 'Username', 'maxlen': 8, 'name': 'username'}, value='vigneshm', action='create')
   66         return "Invalid value"
   67     dbc = dbh.cursor()
   68     dbc.execute("SELECT * FROM person WHERE username = %s", (value,))
   69     rc = dbc.rowcount
   70     dbh.rollback()
dbc = <website.PostgresDBCursor instance>, dbc.execute = <bound method pgdbCursor.execute of <pgdb.pgdbCursor instance>>, value = 'vigneshm'

 /var/www/html/admin/accounts/pgdb.py in execute(self=<pgdb.pgdbCursor instance>, operation='SELECT * FROM person WHERE username = %s', params=('vigneshm',))
  182 
  183         def execute(self, operation, params = None):
  184                 self.executemany(operation, (params,))
  185 
  186         def executemany(self, operation, param_seq):
self = <pgdb.pgdbCursor instance>, self.executemany = <bound method pgdbCursor.executemany of <pgdb.pgdbCursor instance>>, operation = 'SELECT * FROM person WHERE username = %s', params = ('vigneshm',)

 /var/www/html/admin/accounts/pgdb.py in executemany(self=<pgdb.pgdbCursor instance>, operation='SELECT * FROM person WHERE username = %s', param_seq=(('vigneshm',),))
  202                 except _pg_error, msg:
  203                         print sql
  204                         raise
  205                         raise DatabaseError, "error '%s' in '%s'" % ( msg, sql )
  206                 except:

ProgrammingError: ERROR: current transaction is aborted, commands ignored until end of transaction block
      args = ('ERROR: current transaction is aborted, commands ignored until end of transaction block\n',)