definitively the problem is the name "fields" for the objects table. This should be caught. Will fix it. "fields" is an invalid field name.
Massimo On Jul 27, 8:32 am, François Le Gal <[email protected]> wrote: > I try with the last one as you say, and i have this error now : > > File "/home/fanch/Logiciels/web2py/gluon/dal.py", line 4305, in define_table > t._create_references() > File "/home/fanch/Logiciels/web2py/gluon/dal.py", line 4615, in > _create_references > field=self[fieldname] > File "/home/fanch/Logiciels/web2py/gluon/dal.py", line 4671, in __getitem__ > return dict.__getitem__(self, str(key)) > KeyError: 'SUBSTR(objects.fields,1,(2 - 1))' > > 2011/7/27 Massimo Di Pierro <[email protected]> > > > > > > > > > try the one labeled as "nightly build" from the download page. > > > On Jul 27, 8:22 am, François Le Gal <[email protected]> wrote: > > > Strange, i have this version : > > > Version 1.97.1 (2011-06-26 19:25:44) Is there a newer ? > > > > 2011/7/27 Massimo Di Pierro <[email protected]> > > > > > Johannes is right (try another name for the fields field) yet the line > > > > of the error does not exist in my copy of dal.py. Also try a newer > > > > web2py version, you may get no error, or a better description of the > > > > problem. > > > > > Massimo > > > > > On Jul 27, 6:07 am, François Le Gal <[email protected]> wrote: > > > > > That's the code i try : > > > > > > db_system = SQLDB("sqlite://db_system.db") > > > > > > db_system.define_table("fields",Field("name")) > > > db_system.define_table("objects",Field("name"),Field("fields",db_system.fie > > > > lds)) > > > > > > But when i execute this code, i got this error : > > > > > > File "/home/fanch/Logiciels/web2py/gluon/dal.py", line 4228, in > > > > > define_table > > > > > t._create_references() > > > > > File "/home/fanch/Logiciels/web2py/gluon/dal.py", line 4536, in > > > > > _create_references > > > > > field=self[fieldname] > > > > > File "/home/fanch/Logiciels/web2py/gluon/dal.py", line 4592, in > > > > > __getitem__ > > > > > return dict.__getitem__(self, str(key)) > > > > > KeyError: 'SUBSTR(objects.fields,1,(2 - 1))' > > > > > > What's wrong ? Any idea ? > > > > > > thanks.
