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 <[email protected]> wrote:
> uploading fix. please check it. Thanks for testing this.
>
> On Apr 5, 3:59 pm, Thadeus Burgess <[email protected]> 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 <[email protected]> wrote:
>> > try now
>>
>> > On Apr 5, 2:30 pm, Thadeus Burgess <[email protected]> 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 <[email protected]> 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 <[email protected]> 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 [email protected].
>> >> > To unsubscribe from this group, send email to
>> >> > [email protected].
>> >> > 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 [email protected].
>> > To unsubscribe from this group, send email to
>> > [email protected].
>> > 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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://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 [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
