can not register 1st user with mod-wsgi

[Yoichi Nakatsu]

Release Version:
Sahana Eden 0.5.4

Source of Download:
http://launchpad.net/sahana-eden/trunk/0.5.4/+download/web2py.app.eden-0.5.4.w2p

Operating System:
ubuntu 10.04
Firefox 3.6.15

Database Environment:
Database: mysql-server 5.1.41
Web Server: apache2 2.2.14
libapache2-mod-wsgi 2.8-2
Python 2.6.5-1
Web2Py 1.91.6

Steps:
1) Click ‘Map’.
2) fill columns and submit.

Result:
Internal error
Ticket issued: eden054/192.168.11.110.2011-03-11.22-53-35.7978be32-1641-4a5e-9133-80dc3e7fadd8

Traceback (most recent call last):
  File "/home/web2py/gluon/restricted.py", line 188, in restricted
    exec ccode in environment
  File "/home/web2py/applications/eden054/controllers/default.py", line 254, in <module>
  File "/home/web2py/gluon/globals.py", line 95, in <lambda>
    self._caller = lambda f: f()
  File "/home/web2py/applications/eden054/controllers/default.py", line 110, in index
    register_form = auth()
  File "/home/web2py/gluon/tools.py", line 1038, in __call__
    return self.register()
  File "applications/eden054/modules/s3/s3aaa.py", line 569, in register
    onvalidation=onvalidation):
  File "/home/web2py/gluon/sqlhtml.py", line 1180, in accepts
    self.vars.id = self.table.insert(**fields)
  File "/home/web2py/gluon/dal.py", line 3934, in insert
    return self._db._adapter.insert(self,self._listify(fields))
  File "/home/web2py/gluon/dal.py", line 707, in insert
    raise e
ProgrammingError: (1110, u"Column 'email' specified twice")

[Fran Boon (flavour)]

You say that you are using MySQL.
This looks like a database migration error.
I suggest that you:
1) Drop the 'sahana' database
2) Delete the contents of the 'databases' folder
3) Ensure that models/000_config.py has migrate=True & prepopulate=True
4) Recreate the empty Sahana database
5) Run the program to do a fresh migration/prepopulation