I altered something in the db.py file, the file contains the following custom auth_user table:
auth.settings.table_user = db.define_table('auth_user', Field('first_name',length=24,default=''), Field('last_name',length=42,default=''), Field('bedrijf_id',db.bedrijf,default='',notnull=True,ondelete='CASCADE',writable=False, readable=False), Field('email',length=72,default='',notnull=True), Field('username',length=72,default='',notnull=True,writable=False,readable=False), Field('password',type='password',default='',notnull=True,readable=False), Field('account',length=2,default='99',notnull=True,writable=False,readable=False), Field('registration_key',length=512,default='',writable=False, readable=False), Field('reset_password_key',length=512,default='',writable=False, readable=False)) auth.define_tables(fake_migrate=True) # creates all needed tables When I save the file and open the database administration I get the following ticket. Traceback (most recent call last): File "/Library/Python/2.5/site-packages/web2py/gluon/restricted.py", line 173, in restricted exec ccode in environment File "/Library/Python/2.5/site-packages/web2py/applications/cms/ models/db_01.py", line 16, in <module> Field('reset_password_key',length=512,default='',writable=False, readable=False)) File "/Library/Python/2.5/site-packages/web2py/gluon/sql.py", line 1275, in define_table t._create(migrate=migrate, fake_migrate=fake_migrate) File "/Library/Python/2.5/site-packages/web2py/gluon/sql.py", line 1694, in _create self._db._execute(query) File "/Library/Python/2.5/site-packages/web2py/gluon/sql.py", line 958, in <lambda> self._execute = lambda *a, **b: self._cursor.execute(*a, **b) ProgrammingError: relation "auth_user" already exists I thought setting fake_migrate=True would prevent me from having this problem? Kind regards, Annet.