Correct, I do *not* have that file in the databases folder.
On Monday, June 10, 2013 3:16:42 PM UTC-4, Niphlod wrote:
>
> so probably you don't have an *_auth_user.table in the databases/* folder.
> Can you confirm ?
>
> On Monday, June 10, 2013 6:38:18 PM UTC+2, Andre Kozaczka wrote:
>>
>> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
