need more info On Apr 7, 1:36 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > Traceback (most recent call last): > File "/home/tburgess/Applications/web2py/gluon/restricted.py", line > 173, in restricted > exec ccode in environment > File > "/home/tburgess/Applications/web2py/applications/pms/views/default/index.html", > line 62, in <module> > <thead> > File "/home/tburgess/Applications/web2py/applications/pms/models/common.py", > line 197, in <lambda> > db.TableA.id_TableB.represent = lambda value: "%s" % db.TableB[value].name > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2402, > in __getitem__ > return self._db(self.id == key).select().first() > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 3276, in select > return self._db._adapter.select(self._query,*fields,**attributes) > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 507, in select > query = self.SELECT(query,*fields, **attributes) > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 433, in SELECT > for field in self.db[table]: > File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2102, > in __getitem__ > return dict.__getitem__(self, str(key)) > KeyError: 'None' > > -Thadeus > > On Mon, Apr 5, 2010 at 6:00 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > uploading fix. please check it. Thanks for testing this. > > > On Apr 5, 3:59 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > >> Traceback (most recent call last): > >> File "/home/tburgess/Applications/web2py/gluon/restricted.py", line > >> 173, in restricted > >> exec ccode in environment > >> File > >> "/home/tburgess/Applications/web2py/applications/pms/controllers/default.py", > >> line 278, in <module> > >> File "/home/tburgess/Applications/web2py/gluon/globals.py", line 96, > >> in <lambda> > >> self._caller = lambda f: f() > >> File > >> "/home/tburgess/Applications/web2py/applications/pms/controllers/default.py", > >> line 76, in duplicates > >> orderby=db.potentials.A > >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 3258, in > >> select > >> return self._db._adapter.select(self._query,*fields,**attributes) > >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 512, in > >> select > >> return self.parse(rows,self._colnames) > >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 706, in > >> parse > >> (rid._table, rid._record) = (db[referee], None) > >> NameError: global name 'db' is not defined > > >> -Thadeus > > >> On Mon, Apr 5, 2010 at 3:01 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > >> > try now > > >> > On Apr 5, 2:30 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > >> >> Now I get this for reference field > > >> >> Traceback (most recent call last): > >> >> File "/home/tburgess/Applications/web2py/gluon/restricted.py", line > >> >> 173, in restricted > >> >> exec ccode in environment > >> >> File > >> >> "/home/tburgess/Applications/web2py/applications/pms/views/default/index.html", > >> >> line 84, in <module> > >> >> {{=db.table[column].represent(d.B[column])}} > >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2210, > >> >> in __getattr__ > >> >> self.__allocate() > >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2203, > >> >> in __allocate > >> >> self._record = self._table[int(self)] > >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2384, > >> >> in __getitem__ > >> >> return self._db(self.id == key).select().first() > >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 3258, in > >> >> select > >> >> return self._db._adapter.select(self._query,*fields,**attributes) > >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 512, in > >> >> select > >> >> return self.parse(rows,self._colnames) > >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 707, in > >> >> parse > >> >> colset[fieldname] = rid = Reference(value) > >> >> TypeError: int() argument must be a string or a number, not 'NoneType' > > >> >> -Thadeus > > >> >> On Mon, Apr 5, 2010 at 2:20 PM, mdipierro <mdipie...@cs.depaul.edu> > >> >> wrote: > >> >> > I fixed the former. I did not fix the latter. It is a known problem > >> >> > with the new dal and one of the few things that needs to be ironed > >> >> > out: it does not like select('fieldname') only > >> >> > select(db.table['fieldname']). Not difficult to fix anyway. > > >> >> > On Apr 5, 2:13 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > >> >> >> I get this traceback when attempting to access a reference field. > > >> >> >> rows = db().select(db.table.ALL) > >> >> >> for r in rows: > >> >> >> r.id > >> >> >> r.title > >> >> >> r.reference_field.name > >> >> >> r.reference_field.description > > >> >> >> Traceback (most recent call last): > >> >> >> File "/home/tburgess/Applications/web2py/gluon/restricted.py", line > >> >> >> 173, in restricted > >> >> >> exec ccode in environment > >> >> >> File > >> >> >> "/home/tburgess/Applications/web2py/applications/pms/views/default/index.html", > >> >> >> line 84, in <module> > >> >> >> {{=db.field[column].represent(d.B[column])}} > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2210, > >> >> >> in __getattr__ > >> >> >> self.__allocate() > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2203, > >> >> >> in __allocate > >> >> >> self._record = self._table[int(self)] > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 2384, > >> >> >> in __getitem__ > >> >> >> return self._db(self.id == key).select()._first() > >> >> >> AttributeError: 'Rows' object has no attribute '_first' > > >> >> >> I get this traceback from form = SQLFORM(db.mytable) > > >> >> >> Traceback (most recent call last): > >> >> >> File "/home/tburgess/Applications/web2py/gluon/restricted.py", line > >> >> >> 173, in restricted > >> >> >> exec ccode in environment > >> >> >> File > >> >> >> "/home/tburgess/Applications/web2py/applications/pms/controllers/default.py", > >> >> >> line 278, in <module> > >> >> >> File > >> >> >> "/home/tburgess/Applications/web2py/applications/pms/models/plugin_compression.py", > >> >> >> line 28, in compress_response > >> >> >> d = d() > >> >> >> File > >> >> >> "/home/tburgess/Applications/web2py/applications/pms/controllers/default.py", > >> >> >> line 15, in index > >> >> >> return dict(hi='hi', form=SQLFORM(db.mytable)) > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sqlhtml.py", line > >> >> >> 688, in __init__ > >> >> >> inp = self.widgets.multiple.widget(field, default) > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sqlhtml.py", line > >> >> >> 211, in widget > >> >> >> return OptionsWidget.widget(field, value, **attributes) > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sqlhtml.py", line > >> >> >> 187, in widget > >> >> >> options = requires[0].options() > >> >> >> File "/home/tburgess/Applications/web2py/gluon/validators.py", line > >> >> >> 2227, in _options > >> >> >> options = self.other.options() > >> >> >> File "/home/tburgess/Applications/web2py/gluon/validators.py", line > >> >> >> 385, in options > >> >> >> self.build_set() > >> >> >> File "/home/tburgess/Applications/web2py/gluon/validators.py", line > >> >> >> 369, in build_set > >> >> >> records = self.dbset.select(*self.fields, **dd) > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 3258, > >> >> >> in select > >> >> >> return self._db._adapter.select(self._query,*fields,**attributes) > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 501, > >> >> >> in select > >> >> >> query = self.SELECT(query,*fields, **attributes) > >> >> >> File "/home/tburgess/Applications/web2py/gluon/sql.py", line 432, > >> >> >> in SELECT > >> >> >> tablenames.append(f._tablename) > >> >> >> AttributeError: 'str' object has no attribute '_tablename' > > >> >> >> -Thadeus > > >> >> > -- > >> >> > You received this message because you are subscribed to the Google > >> >> > Groups "web2py-users" group. > >> >> > To post to this group, send email to web...@googlegroups.com. > >> >> > To unsubscribe from this group, send email to > >> >> > web2py+unsubscr...@googlegroups.com. > >> >> > For more options, visit this group > >> >> > athttp://groups.google.com/group/web2py?hl=en. > > >> > -- > >> > You received this message because you are subscribed to the Google > >> > Groups "web2py-users" group. > >> > To post to this group, send email to web...@googlegroups.com. > >> > To unsubscribe from this group, send email to > >> > web2py+unsubscr...@googlegroups.com. > >> > For more options, visit this group > >> > athttp://groups.google.com/group/web2py?hl=en. > > > -- > > You received this message because you are subscribed to the Google Groups > > "web2py-users" group. > > To post to this group, send email to web...@googlegroups.com. > > To unsubscribe from this group, send email to > > web2py+unsubscr...@googlegroups.com. > > For more options, visit this group > > athttp://groups.google.com/group/web2py?hl=en.
-- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.