The following commit has caused an error when columns/fields are not 
specified:

http://code.google.com/p/web2py/source/detail?r=48e6f24a4ed36bb35bcd3f37e9ebc955dc9868a1

I have been trying to figure out where this error has been coming from and 
finally narrowed it down. Here is the code I have been using:

Model:
db.define_table('batch',
    Field('auth_user', db.auth_user),
    Field('partnumber', length=30),
    Field('description', length=60),
    Field('quantity', 'double')
)

Controller:
    table = db.batch.auth_user==auth.user.id
    return dict(table=SQLFORM.grid(table))

Error:
Traceback (most recent call last):
  File "/media/psf/Python/web2py/gluon/restricted.py", line 194, in 
restricted
    exec ccode in environment
  File 
"/media/psf/Python/web2py/applications/marlin/controllers/default.py", line 
115, in <module>
  File "/media/psf/Python/web2py/gluon/globals.py", line 149, in <lambda>
    self._caller = lambda f: f()
  File 
"/media/psf/Python/web2py/applications/marlin/controllers/default.py", line 
21, in list_batch
    return SQLFORM.grid(table)
  File "/media/psf/Python/web2py/gluon/sqlhtml.py", line 1586, in grid
    columns = [str(field) for field in columns]
TypeError: 'NoneType' object is not iterable

Putting a try/except at that line confirms that columns is None. When this 
line is removed, the grid works normally.

Reply via email to