I've following in model
db.define_table('languages',
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('full', 'string', length=30,
notnull=True, required=True),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('short', 'string', length=10
, notnull=True, required=True),
format='%(full)s - %(short)s')
db.define_table('words',
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('word', 'string',
notnull=True, required=True),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('lang', db.languages,
notnull=True, readable=False, writable=False),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('entry_by', db.auth_user,
notnull=True, readable=False, writable=False))
db.define_table('pictures',
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('image', 'upload',
notnull=True, required=True, label='Visual Lingua'),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('word', 'list:reference
words', readable=False, writable=False, required=True),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('total', 'integer',
notnull=True, readable=False, writable=False, default=2),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('clicks', 'integer',
notnull=True, readable=False, writable=False, default=1),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('rating', 'double',
notnull=True, readable=False, writable=False, compute=lambda row:
row['total']/row['clicks']),
Field
<http://127.0.0.1:8000/examples/global/vars/Field>('entry_by', db.auth_user,
notnull=True, readable=False, writable=False))
'''
db.define_table('symbolize',
Field('image', db.pictures, notnull=True, readable=False,
writable=False, required=True ),
Field('word', db.words, notnull=True, readable=False,
writable=False, required=True))
'''
I got following error when I select table '*pictures*' on appadmin.
Isn't that an error?
Other table's pages are rendered correct.
Version web2py™ Version 1.91.4 (2010-12-22 17:31:23) Python Python 2.5.1:
C:\Python25\python.exe Traceback
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
Traceback (most recent call last):
File
"I:\Evolve\Work\web2py_src_downloaded\google_appengine\visuallingua\gluon\restricted.py",
line 188, in restricted
exec ccode in environment
File
"I:/Evolve/Work/web2py_src_downloaded/google_appengine/visuallingua/applications/init/views/appadmin.html"
<http://127.0.0.1:8000/admin/default/edit/init/views/appadmin.html>, line 165,
in <module>
<p>
File
"I:\Evolve\Work\web2py_src_downloaded\google_appengine\visuallingua\gluon\sqlhtml.py",
line 1329, in __init__
r = field.represent(r)
File
"I:\Evolve\Work\web2py_src_downloaded\google_appengine\visuallingua\gluon\dal.py",
line 3012, in list_ref_repr
return (ids and ', '.join(f(r,ref.id) for ref in refs) or '')
TypeError: sequence item 0: expected string, int found
Error snapshot [image: help] Detailed traceback description
<type 'exceptions.TypeError'>(sequence item 0: expected string, int found)
Function argument list
(ids=[2], r=<Table {'lang': <gluon.dal.Field object at 0x021...>, 'id':
<gluon.dal.Field object at 0x021B8550>}>, f=<function ff at 0x021C4430>)
Code listing
3007.
3008.
3009.
3010.
3011.
3012.
3013.
3014.
3015.
3016.
field_type.find('.') < 0 and \
field_type[15:] in field.db.tables:
referenced = field.db[field_type[15:]]
def list_ref_repr(ids, r=referenced, f=ff):
refs = r._db(r.id.belongs(ids)).select(r.id)
return (ids and ', '.join(f(r,ref.id) for ref in refs) or '')
field.represent = list_ref_repr
if hasattr(referenced, '_format') and referenced._format:
requires = validators.IS_IN_DB(field.db,referenced.id,
referenced._format,multiple=True)
Variables ', '.join undefined f <function ff at 0x021C4430> refs
<gluon.dal.Rows
object at 0x020A94D0> ids [2] r <Table {'lang': <gluon.dal.Field object at
0x021...>, 'id': <gluon.dal.Field object at 0x021B8550>}> ref undefined
