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.

Reply via email to