Tried step 1. I get the same 'auth_user' table already exists.
<class 'gluon.contrib.pymysql.err.InternalError'> (1050, u"Table
'auth_user' already exists")
Step 2 gave the same error. Seems like whenever migrate is set to True
when define_tables is run, I'm getting the table already exists error.
On Monday, June 10, 2013 12:18:17 PM UTC-4, Massimo Di Pierro wrote:
>
> 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.
