You have a field 'datetime' that was not a 'datetime'. You changed the type after you have data in it. In any database but sqlite, web2py would have attampated a migration and would have failed. sqlite does not support column drop and therefore did not alter the table. You have to clear the content of the column using the shell.
Massimo On 3 Lug, 22:14, weheh <[email protected]> wrote: > I'm getting the following ticket when trying to access one of the > tables in my db via tha appadmin interface. Any ideas? > > Traceback (most recent call last): > File "C:\web2py\gluon\restricted.py", line 178, in restricted > exec ccode in environment > File "C:/web2py/applications/myapp/views/appadmin.html", line 326, > in <module> > File "C:\web2py\gluon\globals.py", line 105, in write > self.body.write(xmlescape(data)) > File "C:\web2py\gluon\html.py", line 104, in xmlescape > return data.xml() > File "C:\web2py\gluon\html.py", line 547, in xml > (fa, co) = self._xml() > File "C:\web2py\gluon\html.py", line 538, in _xml > self.components]) > File "C:\web2py\gluon\html.py", line 104, in xmlescape > return data.xml() > File "C:\web2py\gluon\html.py", line 547, in xml > (fa, co) = self._xml() > File "C:\web2py\gluon\html.py", line 538, in _xml > self.components]) > File "C:\web2py\gluon\html.py", line 104, in xmlescape > return data.xml() > File "C:\web2py\gluon\html.py", line 547, in xml > (fa, co) = self._xml() > File "C:\web2py\gluon\html.py", line 538, in _xml > self.components]) > File "C:\web2py\gluon\html.py", line 104, in xmlescape > return data.xml() > File "C:\web2py\gluon\html.py", line 547, in xml > (fa, co) = self._xml() > File "C:\web2py\gluon\html.py", line 538, in _xml > self.components]) > File "C:\web2py\gluon\html.py", line 104, in xmlescape > return data.xml() > File "C:\web2py\gluon\html.py", line 547, in xml > (fa, co) = self._xml() > File "C:\web2py\gluon\html.py", line 538, in _xml > self.components]) > File "C:\web2py\gluon\html.py", line 104, in xmlescape > return data.xml() > File "C:\web2py\gluon\sql.py", line 1469, in __getattr__ > self.__allocate() > File "C:\web2py\gluon\sql.py", line 1462, in __allocate > self._record = self._table[int(self)] > File "C:\web2py\gluon\sql.py", line 1592, in __getitem__ > return self._db(self.id == key).select().first() > File "C:\web2py\gluon\sql.py", line 3142, in select > return self.parse(db,rows,self.colnames,SetClass=Set) > File "C:\web2py\gluon\sql.py", line 3211, in parse > (h, mi, s) = time_items + [0] > ValueError: need more than 2 values to unpack
