should be fixed in trunk. The problem is corrupted data anyway. Massimo
On Mar 4, 4:34 am, szimszon <[email protected]> wrote: > I had a mysql table with boolean field but there was some rows with > empty fields than I got that: > > Traceback (most recent call last): > File "applications/serveradmin/compiled/controllers_integrity_ftp.py", > line 191, in ftp > File "/usr/local/web2py/gluon/dal.py", line 4605, in select return > self.db._adapter.select(self.query,fields,attributes) > File "/usr/local/web2py/gluon/dal.py", line 1027, in select return > self.parse(rows,self._colnames) > File "/usr/local/web2py/gluon/dal.py", line 1225, in parse if value == > True or str(value)[0].lower() == 't': > IndexError: string index out of range > > +-------------+---------------+------+-----+---------+---------------- > + > | Field | Type | Null | Key | Default | Extra > | > +-------------+---------------+------+-----+---------+---------------- > + > | User | varchar(128) | NO | UNI | | > | > | status | enum('0','1') | NO | | 0 | > | > > It's an outer DB I just connect to it (migrate=False). After I put a > value to all the status field everything is working OK.

