Actually no, I moved the web2py folder somewhere else,worked on my project for a while then noticed said weirdness, moved it back to where it was but still problem remains. As I said there's no data I need in the db so I figure wiping it would be faster than trying to diagnose and fix the error. I take it from the procedure above 'truncate' would do this?
:) Roger. On Apr 6, 1:01 am, mdipierro <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
