Try, in order:
1)
db = DAL(...,fake_migrate=True)
...
# auth.settings.extra_fields['auth_user'] = [Field('eft', 'integer')]
auth.define_tables(migrate=True)
run appadmin.
2)
db = DAL(...)
...
auth.settings.extra_fields['auth_user'] = [Field('eft', 'integer')]
auth.define_tables(migrate=True)
run appadmin again.
On Monday, 10 June 2013 10:52:26 UTC-5, Andre Kozaczka wrote:
>
> Also, to clarify.... I'm trying to add this column after I've done some
> development and already had an auth_user table created... don't think this
> should matter, but wanted to throw this out there. Maybe I need to
> manually drop the MySQL table and then see if the migration works with the
> added column...?
>
> On Friday, June 7, 2013 3:12:29 PM UTC-4, Niphlod wrote:
>>
>> The "column not found" is your "eft" one ?
>> You code seems legit (setting migrate=True on the define_tables()
>> function). We need to see the errors and the definition that causes them.
>>
>> On Friday, June 7, 2013 7:29:12 PM UTC+2, Andre Kozaczka wrote:
>>>
>>> I'm trying to modify the auth_user table and I keep either getting a
>>> Table 'auth_user' already exist error (when migrate=True) OR a 'Column not
>>> found' (when migrate=False). Not sure what I need to do.
>>>
>>> I've also tried experimenting with fake_migrate but I'm still getting
>>> either one of those errors.
>>>
>>> Here is my code:
>>> db = DAL(settings.db_uri, pool_size=20)
>>>
>>>
>>> crud = Crud(globals(), db)
>>> auth = Auth(globals(), db)
>>>
>>> auth.settings.actions_disabled.append('register')
>>> auth.settings.extra_fields['auth_user'] = [Field('eft', 'integer')]
>>>
>>> auth.define_tables(migrate=True)
>>>
>>>
>>>
--
---
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.
For more options, visit https://groups.google.com/groups/opt_out.
