Correct, the column not found is the "eft" one.
Below is the error message:
<class 'gluon.contrib.pymysql.err.InternalError'> (1050, u"Table
'auth_user' already exists")Versionweb2py™Version
2.5.1-stable+timestamp.2013.06.06.15.39.19Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
Traceback (most recent call last):
File "C:\web2py\gluon\restricted.py", line 212, in restricted
exec ccode in environment
File "C:/web2py/applications/agentpro/models/db.py"
<http://127.0.0.1:8001/admin/default/edit/agentpro/models/db.py>, line 17, in
<module>
auth.define_tables(migrate=True)
File "C:\web2py\gluon\tools.py", line 1609, in define_tables
format='%(first_name)s %(last_name)s (%(id)s)'))
File "C:\web2py\gluon\dal.py", line 7788, in define_table
table = self.lazy_define_table(tablename,*fields,**args)
File "C:\web2py\gluon\dal.py", line 7825, in lazy_define_table
polymodel=polymodel)
File "C:\web2py\gluon\dal.py", line 963, in create_table
self.create_sequence_and_triggers(query,table)
File "C:\web2py\gluon\dal.py", line 1767, in create_sequence_and_triggers
self.execute(query)
File "C:\web2py\gluon\dal.py", line 1784, in execute
return self.log_execute(*a, **b)
File "C:\web2py\gluon\dal.py", line 1778, in log_execute
ret = self.cursor.execute(command, *a[1:], **b)
File "C:\web2py\gluon\contrib\pymysql\cursors.py", line 117, in execute
self.errorhandler(self, exc, value)
File "C:\web2py\gluon\contrib\pymysql\connections.py", line 202, in
defaulterrorhandler
raise errorclass, errorvalue
InternalError: (1050, u"Table 'auth_user' already exists")
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.
