Let me guess... you changed a field from 'string' to 'datetime' using sqlite? sqlite does not enforces field types hence it let you do the migration even if there was data in there that is not of type 'datetime'. You need to clean up that column.
In your model do this db(db.youtable.id>0).update(thedatetimefield=None) run appadmin once than remove the above line. Massimo On Apr 5, 9:10 pm, "web2py <<<at>>> technicalbloke.com" <[email protected]> wrote: > Hi, > > Somehow (don't ask me how!) I've managed to bork my database :-/ > Appadmin let's me see all my tables except one, when I click on it's > name it spews the message below. I don't care about the data inside, > I'd just like to have my database rebuilt from the model so what's the > best way to do that? > > db.my_table.truncate? > db.my_table.drop? > delete the contents of the 'databases' folder? > > Traceback (most recent call last): > File "/rahrahrah/web2py/gluon/restricted.py", line 98, in restricted > exec ccode in environment > File "/rahrahrah/web2py/applications/tcrm/views/appadmin.html", line > 102, in <module> > File "/rahrahrah/web2py/gluon/sqlhtml.py", line 605, in __init__ > for (rc, record) in enumerate(sqlrows): > File "/rahrahrah/web2py/gluon/sql.py", line 2127, in __iter__ > yield self[i] > File "/rahrahrah/web2py/gluon/sql.py", line 2082, in __getitem__ > str(value)[:10].strip().split('-')] > ValueError: need more than 1 value to unpack > > Cheers, > > Roger. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
