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.