Something got corrupted. try this:
copy somewhere the sqlite file remove everything in databases set migrate=True run appadmin once copy your sqlite file back Massimo On Jul 1, 7:45 am, MikeEllis <michael.f.el...@gmail.com> wrote: > I'm confused, too! > > Tables were created by web2py > yes, they are sqlite tables > > This is important for me to resolve, so I'm going to spend some time > trying to reliably reproduce the problem in as few steps as possible. > > Thanks again for the help, web2py is a truly impressive product and I > really want to make it work for this application. > > Mike > > On Jun 30, 7:57 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > Now I am confused. migrate=False is not an alterantive to migrate=True > > when the latter is not working. > > > before you take any action: > > > are you trying to access tables created by web2py? > > if yes, are these sqlite tables? > > if no, did you change username/password? > > if yes. let me know because your .table files got corrupted > > but they can be recoevered > > if no, migrate=False is the only choice. web2py cannot migrate > > preexisting tables. > > > In all other cases... did you move the content of the databases > > folder? Did you rename any of the files in there? > > > Massimo > > > On Jun 30, 4:07 pm, MikeEllis <michael.f.el...@gmail.com> wrote: > > > > Thanks Fran, that makes it much clearer. It would be nice if > > > migrate=True worked as described in the manual, but I can live with > > > migrate=False for the time being. Just have to make sure to get my > > > table designs correct from the start (LOL). > > > Cheers, > > > Mike > > > > On Jun 30, 4:52 pm, Fran <francisb...@googlemail.com> wrote: > > > > > On Jun 30, 4:57 pm, MikeEllis <michael.f.el...@gmail.com> wrote: > > > > > > doesn't migrate=False prevent me from altering the > > > > > table's structure within a running instance of web2py? > > > > > Mostly correct - migrate=False means that Web2Py doesn't try to create > > > > the Table, but assumes this exists already. > > > > > > am I misunderstanding > > > > > what migrate=False does? I'm assuming it means the table will be > > > > > dropped with all its data and a new one will be created? > > > > > No it won't drop the table/data - migrate=False simply means that only > > > > Table Data not Structure is editable. > > > > > F --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
