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?
>>
>
