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.

Reply via email to