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 = , form = FieldStorage(None, None, [FieldStorage('human_na... ''), FieldStorage('_createme', None, 'Submit')]), fields = ({'can_edit': 0, 'check': , 'desc': 'Your full name', 'maxlen': 50, 'name': 'human_name'}, {'can_edit': 0, 'check': , 'desc': 'Username', 'maxlen': 8, 'name': 'username'}, {'check': , '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': , 'desc': 'Postal Address', 'maxlen': 1024, 'name': 'postal_address'}, {'check': , 'desc': 'Telephone', 'maxlen': 128, 'name': 'telephone'}, {'desc': 'Facsimile', 'maxlen': 128, 'name': 'facsimile'}, {'desc': 'Affiliation', 'maxlen': 64, 'name': 'affiliation'}, {'check': , 'desc': 'GPG KeyID', 'maxlen': 16, 'name': 'gpg_keyid'}, {'check': , 'desc': 'SSHv2 Public Key (attach your ~/.ssh/id_dsa.pub file here)', 'maxlen': 2048, 'name': 'ssh_key', 'strip': 1, 'type': 'file'}, {'check': , 'desc': 'Password', 'edit_reuse': 0, 'maxlen': 20, 'name': 'password', 'type': 'password'}, {'check': , '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': , 'desc': 'Your full name', 'maxlen': 50, 'name': 'human_name'}, {'can_edit': 0, 'check': , 'desc': 'Username', 'maxlen': 8, 'name': 'username'}, {'check': , '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': , 'desc': 'Postal Address', 'maxlen': 1024, 'name': 'postal_address'}, {'check': , 'desc': 'Telephone', 'maxlen': 128, 'name': 'telephone'}, {'desc': 'Facsimile', 'maxlen': 128, 'name': 'facsimile'}, {'desc': 'Affiliation', 'maxlen': 64, 'name': 'affiliation'}, {'check': , 'desc': 'GPG KeyID', 'maxlen': 16, 'name': 'gpg_keyid'}, {'check': , 'desc': 'SSHv2 Public Key (attach your ~/.ssh/id_dsa.pub file here)', 'maxlen': 2048, 'name': 'ssh_key', 'strip': 1, 'type': 'file'}, {'check': , 'desc': 'Password', 'edit_reuse': 0, 'maxlen': 20, 'name': 'password', 'type': 'password'}, {'check': , '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 "" 133 the_desc = I['desc'] objection = None, cfunc = , form = FieldStorage(None, None, [FieldStorage('human_na... ''), FieldStorage('_createme', None, 'Submit')]), I = {'can_edit': 0, 'check': , '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': , '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 = , dbc.execute = >, value = 'vigneshm' /var/www/html/admin/accounts/pgdb.py in execute(self=, 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 = , self.executemany = >, operation = 'SELECT * FROM person WHERE username = %s', params = ('vigneshm',) /var/www/html/admin/accounts/pgdb.py in executemany(self=, 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',)