I did in fact inspect the database and there was a yearstring field. I
think what happened is when i defined the field year i forgot the comma
between year and string so 'year' 'string became yearstring. Then when i
noticed and fixed the issue it added year field but left yearstring in the
db. However i since erased the db(since i am only working on a test right
now) and used fake_migrate to replace the tables. I now am getting this
error:
<type 'exceptions.TypeError'>('str' object is not callable)
Do you have any advice on this now? It is on another table. Here is the
M/V/C:
# coding: utf8 db.define_table('park', Field('park_name', 'string',
requires=IS_NOT_EMPTY()), Field('park_city', 'string',
requires=IS_NOT_EMPTY()), Field('park_state', 'string',
requires=IS_NOT_EMPTY()), Field('park_address', 'string',
requires=IS_NOT_EMPTY()), Field('park_zip', 'string',
requires=IS_NOT_EMPTY()), Field('country', 'string', default="USA",
notnull=True, readable=False, writable=False), Field('park_phone',
'string', requires=IS_MATCH('[\d\-\(\) ]+')), Field('park_fax', 'string',
requires=IS_EMPTY_OR(IS_MATCH('[\d\-\(\) ]+'))), Field('park_phone_2',
'string', requires=IS_EMPTY_OR(('[\d\-\(\) ]+'))), Field('photo1',
'upload'), Field('photo2', 'upload'), Field('photo3', 'upload'),
Field('photo4', 'upload'), Field('photo5', 'upload'), Field('manager',
'string', requires=IS_NOT_EMPTY()), Field('manager_email', 'string',
requires=IS_EMAIL()), Field('spaces', 'integer', requires=IS_NOT_EMPTY()),
Field('vacant', 'integer'), Field('lot_rent', 'integer',
requires=IS_NOT_EMPTY()), Field('water', 'boolean'), Field('sewer',
'boolean'), Field('trash', 'boolean'), Field('pool', 'boolean'),
Field('playground', 'boolean'), Field('clubhouse', 'boolean'),
Field('laundromat', 'boolean'), Field('rv_spaces', 'boolean'),
Field('storage', 'boolean'), Field('handicap_accessible', 'boolean'),
Field('community_description', 'text'), format='%(park_name)s')
db.define_table('home', Field('pid', notnull=True, readable=False,
writable=False), Field('lot', 'string'), Field('year', length=4,
requires=IS_NOT_EMPTY()), Field('make', 'string'), Field('model',
'string'), Field('for_sale', 'boolean', default=True), Field('beds',
'string', requires=IS_NOT_EMPTY()), Field('baths', 'string',
requires=IS_NOT_EMPTY()), Field('fridge', 'boolean'), Field('stove',
'boolean'), Field('dishwasher', 'boolean'), Field('microwave', 'boolean'),
Field('washer', 'boolean'), Field('dryer', 'boolean'), Field('photo1',
'upload'), Field('photo2', 'upload'), Field('photo3', 'upload'),
Field('photo4', 'upload'), Field('photo5', 'upload'), Field('price',
'string' , requires=IS_NOT_EMPTY()), Field('description', 'text',
requires=IS_NOT_EMPTY())) db.define_table('state', Field('name', 'string'),
Field('full_name', 'string')) db.park.park_state.requires = IS_IN_DB(db,
'state.name', '%(name)s', zero=T('Select State'))
@auth.requires_membership('Admin') def new_park(): form =
crud.create(db.park, next='park/[id]') return locals()
@auth.requires_membership('Admin') def new_home(): db.home.pid.default =
request.args(0) or redirect(URL('parks')) db.home.price.default =
"$0000.00" form = crud.create(db.home, next='home/[id]') return locals()
@auth.requires_membership('Admin') def edit_park(): park =
db.park(request.args(0)) or redirct(URL('parks')) form =
crud.update(db.park, park, next='park/[id]') return locals()
@auth.requires_membership('Admin') def edit_home(): home =
db.home(request.args(0)) or redirct(URL('parks')) form =
crud.update(db.home, home, next='home/[id]') return locals()
{{extend 'layout.html'}} <h1>Create A New Park</h1> {{=form}}
Traceback (most recent call last):
File "gluon/restricted.py", line 205, in restricted
File
"/Applications/web2py.app/Contents/Resources/applications/pages/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/pages/controllers/appadmin.py>, line
433, in <module>
File "gluon/globals.py", line 173, in <lambda>
File
"/Applications/web2py.app/Contents/Resources/applications/pages/controllers/appadmin.py"
<http://127.0.0.1:8000/admin/default/edit/pages/controllers/appadmin.py>, line
128, in insert
File "gluon/sqlhtml.py", line 1089, in accepts
File "gluon/html.py", line 1841, in accepts
File "gluon/html.py", line 781, in _traverse
File "gluon/html.py", line 781, in _traverse
File "gluon/html.py", line 781, in _traverse
File "gluon/html.py", line 781, in _traverse
File "gluon/html.py", line 788, in _traverse
File "gluon/html.py", line 1606, in _validate
File "gluon/validators.py", line 2485, in __call__
TypeError: 'str' object is not callable
Thanks for the help.
-Brandon
On Monday, May 21, 2012 2:59:17 PM UTC-6, Anthony wrote:
>
> Can you inspect the database directly (not using web2py)? Is there in fact
> a "yearstring" field in the "home" table of the database, and if so, is
> there a NOT NULL constraint on it.
>
> Anthony
>
> On Monday, May 21, 2012 3:40:14 PM UTC-4, Brandon Reynolds wrote:
>>
>> How do I insert the value into that yearstring field? I understand i got
>> the key error because of the field not being defined. I was trying that
>> only as a troubleshooting step to see what happened. Should i make a
>> yearstring field in the db and then just assing it a default value? Or how
>> else to i get the value into that field? I also have another form that
>> works fine on the site and it doesn't have yearstring field. Please advise.
>>
>> On Monday, May 21, 2012 12:07:42 PM UTC-6, Anthony wrote:
>>>
>>> In your model, there is no "yearstring" field defined (there is a "year"
>>> field, though) -- so that's why you get a key error when trying to set
>>> db.home.yearstring.default. You might be getting the integrity error
>>> because the database itself does include a "yearstring" field (with a
>>> notnull requirement), and you are not inserting any value for that field.
>>>
>>> Anthony
>>>
>>> On Monday, May 21, 2012 1:08:25 PM UTC-4, Brandon Reynolds wrote:
>>>>
>>>> Hello,
>>>>
>>>> I am new to web2py and pretty new to programming in general. I am
>>>> getting the following error when trying to insert a new record with a form
>>>> made with crud.create:
>>>>
>>>> <class 'sqlite3.IntegrityError'> home.yearstring may not be NULL
>>>>
>>>> I have nothing in my model/view/controllers at all that mentions the
>>>> year string. I tried to set yearstring a default value
>>>> with db.home.yearstring.default = "0" but then got a key error that year
>>>> string was not defined. Here is my controller for this view:
>>>>
>>>> @auth.requires_membership('Admin')
>>>> def new_home():
>>>> db.home.pid.default = request.args(0) or redirect(URL('parks'))
>>>> db.home.price.default = "$0000.00"
>>>> form = crud.create(db.home, next='home/[id]')
>>>> return locals()
>>>>
>>>> Here is the model for this controller:
>>>>
>>>> db.define_table('home',
>>>> Field('pid', notnull=True),
>>>> Field('lot', 'string'),
>>>> Field('year', 'string', requires=IS_NOT_EMPTY()),
>>>> Field('make', 'string'),
>>>> Field('model', 'string'),
>>>> Field('for_sale', 'boolean', default=True),
>>>> Field('beds', 'string', requires=IS_NOT_EMPTY()),
>>>> Field('baths', 'string', requires=IS_NOT_EMPTY()),
>>>> Field('fridge', 'boolean'),
>>>> Field('stove', 'boolean'),
>>>> Field('dishwasher', 'boolean'),
>>>> Field('microwave', 'boolean'),
>>>> Field('washer', 'boolean'),
>>>> Field('dryer', 'boolean'),
>>>> Field('photo1', 'upload'),
>>>> Field('photo2', 'upload'),
>>>> Field('photo3', 'upload'),
>>>> Field('photo4', 'upload'),
>>>> Field('photo5', 'upload'),
>>>> Field('price', 'string' , requires=IS_NOT_EMPTY()),
>>>> Field('description', 'text', requires=IS_NOT_EMPTY()))
>>>>
>>>> Also here is the traceback.
>>>>
>>>> Traceback (most recent call last):
>>>> File "gluon/restricted.py", line 205, in restricted
>>>> File
>>>> "/Applications/web2py.app/Contents/Resources/applications/pages/controllers/view.py"
>>>> <http://127.0.0.1:8000/admin/default/edit/pages/controllers/view.py>,
>>>> line 110, in <module>
>>>> File "gluon/globals.py", line 173, in <lambda>
>>>> File "gluon/tools.py", line 2575, in f
>>>> File
>>>> "/Applications/web2py.app/Contents/Resources/applications/pages/controllers/view.py"
>>>> <http://127.0.0.1:8000/admin/default/edit/pages/controllers/view.py>,
>>>> line 88, in new_home
>>>> File "gluon/tools.py", line 3172, in create
>>>> File "gluon/tools.py", line 3115, in update
>>>> File "gluon/sqlhtml.py", line 1274, in accepts
>>>> File "gluon/dal.py", line 6829, in insert
>>>> File "gluon/dal.py", line 928, in insert
>>>> IntegrityError: home.yearstring may not be NULL
>>>>
>>>>
>>>> What is this error ad how can i get around it?
>>>>
>>>
