And the solution is to add fake_migrate=True into the DAL statement and the auth.define_tables statement.
On Saturday, April 17, 2021 at 6:35:05 PM UTC-7 james c. wrote: > db = DAL(myconf.get('db.uri'), > auto_import = True, > ignore_field_case = True, > entity_quoting = False, > pool_size = 10 > migrate = True, > migrate_enabled = True, > check_reserved = ['common'], > lazy_tables = False) > > . . . > > auth = Auth(db, host_names=myconf.get('host.names')) > > auth.settings.extra_fields['auth_user'] = [ > Field('organization', length=128, label=T('Organization')), > Field('address', length=128, label=T('Street Address'), > requires=[IS_NOT_EMPTY()]), > Field('city', length=64, label=T('City'), requires=[IS_NOT_EMPTY()]), > Field('statename', length=64, label=T('State'), requires=[IS_NOT_EMPTY()]), > Field('zip', length=8, label=T('Zip Code'), > requires=[IS_MATCH(r'^\d{5}(-\d{4})?$', error_message='not a zip code')]), > Field('phone', length=16, label=T('Phone Number'), requires=[IS_LENGTH(16, > 10)])] > > > auth.define_tables(username=True, signature=True) <--- fails here > > """ > This application was developed on windows, The application is now on > ubuntu 16.04. The database exist and this code, as it is above, is trying > to create a table, auth_user, that already exists. When migrate=True, this > is not suppose to happen - but it is. The table auth_user" already exists > and the code fails at auth.define_tables(username=True, signature=True), > with the following message: > DuplicateTable: relation "auth_user" already exists > > Thanks in advance, any recommendations appreciated, James > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/76358c98-d5da-4305-b26f-35b84d4f0dc5n%40googlegroups.com.