One of my fields is 40off_sh (legacy MySQL db), and all works fine in 1.97.
Seems like cleanup function in dal doesn't like the numeric part at the
beginning of field name, or I'm reading it wrong? I checked the table and
the field is in, so it's not missing.
I can't change the field name, since it's used by other applications, so
not sure what would you recommend to do here?
Thanks,
Adnan
Traceback (most recent call last):
File "/opt/web-apps/web2py/gluon/restricted.py", line 209, in restricted
exec ccode in environment
File "/opt/web-apps/web2py/applications/thane_us/models/db_1_common.py", line
182, in <module>
Field('40off_sh', 'boolean',),
File "/opt/web-apps/web2py/gluon/dal.py", line 8396, in __init__
self.name = fieldname = cleanup(fieldname)
File "/opt/web-apps/web2py/gluon/dal.py", line 4769, in cleanup
raise SyntaxError, 'invalid table or field name: %s' % text
SyntaxError: invalid table or field name: 40off_sh
--
