as a test... try remove the SPAN around labels
On Nov 19, 1:35 am, Johann Spies <johann.sp...@gmail.com> wrote:
> I have a generic controller to show the contents of a table in a grid. For
> one of the 33 tables I get this error while the other seems to work without
> problem:
>
> Controller:
>
> @auth.requires_login()
> def show_data():
> tabel = request.vars.tabel.lower()
> data= plugin_wiki.widget('jqgrid',table=tabel,width=950)
> return dict(data=data,tabel=tabel)
>
> @auth.requires_login()
> def captured_data():
> form = SQLFORM.factory(Field('tabel', requires =
> IS_IN_DB(db,db.label.form_id,groupby = 'form_id'),
> label = "Which forms?"),
> )
> if form.accepts(request.vars, session):
> redirect(URL(r=request, f='show_data',vars=request.vars))
> elif form.errors:
> response.flash = 'form has errors'
> return dict(form = form)
>
> Model of the problem table:
>
> db.define_table("gr03",
> Field("observer_or_trainer"),
> Field("service_provider",db.service_provider,
> requires=IS_IN_DB(db,db.service_provider.id,
> '%(name)s'),label="Service provider"),
> Field("date","date"),
> Field("school",db.school,label="School",
> requires=IS_IN_DB(db,db.school.id, '%(name)s')),
> Field("teacher",db.teacher,
> requires=IS_IN_DB(db,db.teacher.id,
> '%(school)s,%(surname)s,%(name)s')),
> Field("focus",label="Topic/focus"),
> Field("assessment_standard",label="2. Assessment Standard"),
> Field("q3","text",
> label=SPAN("3. Content knowledge for teacher")
> ),
> Field("q4","text",
> label=SPAN("4. Teaching skills of
> teacher",BR(),spasies(4),
> "(include use of resources)")
> ),
> Field("q5","text",
> label=SPAN("5. Overall finding"),
> ),
>
> Field("q7","text"),
> Field("q8","text"),
> Field("q9","text"),
> Field("q10","text"),
> )
>
> What is a bit strange to me is that the line in the controller referred to
> by the ticket is the last line of the file and not in the vicinity of the
> controller involved.
>
> The ticket:
>
> Traceback (most recent call last):
>
> File "/Users/js/Programmeer/zenex/web2py/gluon/restricted.py", line
> 188, in restricted
> exec ccode in environment
> File
> "/Users/js/Programmeer/zenex/web2py/applications/zenex2/controllers/default.py"
> <http://127.0.0.1:8000/admin/default/edit/zenex2/controllers/default.py>,
> line 1402, in <module>
> File "/Users/js/Programmeer/zenex/web2py/gluon/globals.py", line 96,
> in <lambda>
> self._caller = lambda f: f()
> File "/Users/js/Programmeer/zenex/web2py/gluon/tools.py", line 2272, in f
> return action(*a, **b)
> File
> "/Users/js/Programmeer/zenex/web2py/applications/zenex2/controllers/default.py"
> <http://127.0.0.1:8000/admin/default/edit/zenex2/controllers/default.py>,
> line 827, in show_data
> data= plugin_wiki.widget('jqgrid',table=tabel,width=950)
> File
> "/Users/js/Programmeer/zenex/web2py/applications/zenex2/models/plugin_wiki.py"
> <http://127.0.0.1:8000/admin/default/edit/zenex2/models/plugin_wiki.py>,
> line 675, in widget
> return getattr(PluginWikiWidgets,name)(*args,**kargs)
> File
> "/Users/js/Programmeer/zenex/web2py/applications/zenex2/models/plugin_wiki.py"
> <http://127.0.0.1:8000/admin/default/edit/zenex2/models/plugin_wiki.py>,
> line 280, in jqgrid
> """ % dict(callback=callback,colnames=json(colnames),
> File "/Users/js/Programmeer/zenex/web2py/gluon/serializers.py", line
> 31, in json
> return simplejson.dumps(value)
> File
> "/Users/js/Programmeer/zenex/web2py/gluon/contrib/simplejson/__init__.py",
> line 228, in dumps
> return _default_encoder.encode(obj)
> File
> "/Users/js/Programmeer/zenex/web2py/gluon/contrib/simplejson/encoder.py",
> line 232, in encode
> chunks = list(chunks)
> File
> "/Users/js/Programmeer/zenex/web2py/gluon/contrib/simplejson/encoder.py",
> line 498, in _iterencode
> for chunk in _iterencode_list(o, _current_indent_level):
> File
> "/Users/js/Programmeer/zenex/web2py/gluon/contrib/simplejson/encoder.py",
> line 396, in _iterencode_list
> for chunk in chunks:
> File
> "/Users/js/Programmeer/zenex/web2py/gluon/contrib/simplejson/encoder.py",
> line 511, in _iterencode
> o = _default(o)
> File
> "/Users/js/Programmeer/zenex/web2py/gluon/contrib/simplejson/encoder.py",
> line 206, in default
> raise TypeError(repr(o) + " is not JSON serializable")
> TypeError: is not JSON serializable
>
> I have no idea where to look for the problem. In the appadmin everything
> seems to work OK.
>
> Regards
> Johann
>
> --
> May grace and peace be yours in abundance through the full knowledge of God
> and of Jesus our Lord! His divine power has given us everything we need for
> life and godliness through the full knowledge of the one who called us by
> his own glory and excellence.
> 2 Pet. 1:2b,3a
