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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.