As requested, here is the traceback: In FILE: /base/data/home/apps/s~sbhweb2py/1.364873083036857122/applications/ppt_demo/controllers/default.py
Traceback (most recent call last): File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/restricted.py", line 212, in restricted exec ccode in environment File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/applications/ppt_demo/controllers/default.py", line 57, in <module> File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/globals.py", line 193, in <lambda> self._caller = lambda f: f() File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/tools.py", line 2929, in f return action(*a, **b) File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/applications/ppt_demo/controllers/default.py", line 22, in trial_manage form = SQLFORM.smartgrid(db.t_trial,onupdate=auth.archive) File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/sqlhtml.py", line 2489, in smartgrid user_signature=user_signature, **kwargs) File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/sqlhtml.py", line 1881, in grid onsuccess=oncreate) File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/html.py", line 2179, in process self.validate(**kwargs) File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/html.py", line 2118, in validate if self.accepts(**kwargs): File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/sqlhtml.py", line 1486, in accepts self.vars.id = self.table.insert(**fields) File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/dal.py", line 7918, in insert ret = self._db._adapter.insert(self,self._listify(fields)) File "/base/data/home/apps/s~sbhweb2py/1.364873083036857122/gluon/dal.py", line 4671, in insert tmp = table._tableobj(**dfields) File "/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py", line 970, in __init__ prop.__set__(self, value) File "/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py", line 614, in __set__ value = self.validate(value) File "/base/python_runtime/python_lib/versions/1/google/appengine/ext/db/__init__.py", line 3286, in validate raise BadValueError('Property %s must be a float' % self.name) BadValueError: Property f_run_fee_2 must be a float Here is the controller: @auth.requires_login() def trial_manage(): form = SQLFORM.smartgrid(db.t_trial,onupdate=auth.archive) return locals() And here is the model: db.define_table('t_trial', Field('f_name', type='string', label=T('Name')), Field('f_club', type='string', label=T('Club')), Field('f_club_link', type='string', label=T('Club')), Field('f_when', type='date', label=T('When')), Field('f_days', type='integer', label=T('Days')), Field('f_open', type='date', label=T('Openning')), Field('f_close', type='date', label=T('Closing')), Field('f_location', type='string', label=T('Location')), Field('f_maplink', type='string', label=T('Map')), Field('f_maxruns', type='integer', label=T('Runs')), Field('f_run_fee_1', type='float', label=T('1st Run Fee')), Field('f_run_fee_2', type='float', label=T('2nd Run Fee')), Field('f_status', type='string', label=T('Status')), auth.signature, format='%(f_name)s', migrate=settings.migrate) (settings.migrate = True, from settings.py -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.