This problem cannot originate from moving the database unless you moved the database but not the .table files (which contain metadata required for migrations).
In this case the only the safe way is drop the table and delete the associated databases/*.table files. Massimo On Apr 6, 12:15 am, "web2py <<<at>>> technicalbloke.com" <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
