Yes, right you are, as usual. I picked this apart last night and discovered that it was the time field and that once I had cleared the db and started over, it worked fine. But I dropped dead before I could follow up with this thread. Sorry, and thanks!
On Jul 4, 3:20 am, mdipierro <[email protected]> wrote: > 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
