I am encountering a strange error, and was wondering if anybody else
has seen something like it.
The code:
auth.settings.table_user = db.define_table(
auth.settings.table_user_name,
Field('username', length=32, notnull=True, unique=True,
requires = [IS_LENGTH(minsize=3), IS_NOT_IN_DB
(db,auth.settings.table_user_name+'.username')]),
Field('first_name', length=128,default=''),
Field('last_name', length=128,default=''),
Field('email', length=128,default='',
requires = [IS_EMAIL()]),
Field('firm_name', length=128),
Field('address', length=256),
Field('firm_type', length=128),
Field('contact_name', length=128),
Field('phone', length=32),
Field('discount', 'double', default=0, requires=[IS_FLOAT_IN_RANGE
(0,1)]),
Field('password', 'password', readable=False,
label='Password', requires=CRYPT()),
Field('registration_key', length=128,
writable=False, readable=False,default=''))
The traceback:
Traceback (most recent call last):
File "/home/anyapan/work/web2py/gluon/restricted.py", line 173, in
restricted
exec ccode in environment
File "/home/anyapan/work/web2py/applications/cparts/models/db.py",
line 49, in <module>
writable=False, readable=False,default=''))
File "/home/anyapan/work/web2py/gluon/sql.py", line 1252, in
define_table
t._create(migrate=migrate, fake_migrate=fake_migrate)
File "/home/anyapan/work/web2py/gluon/sql.py", line 1709, in _create
fake_migrate=fake_migrate)
File "/home/anyapan/work/web2py/gluon/sql.py", line 1763, in
_migrate
self._db._execute(sub_query)
File "/home/anyapan/work/web2py/gluon/sql.py", line 890, in <lambda>
self._execute = lambda *a, **b: self._cursor.execute(*a, **b)
OperationalError: duplicate column name: phone
When I remove the "Field('phone'..." entry everything works fine. As
you see there is no other column with that name.
Thanks!
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
