web2py will only recreate them if a) you also delete the database itself (for sqlite, you must delete everything in databases)
OR b) you know for sure that the current models reflect exactly the structure of the database tables and you set "db.define_table (...,fake_migrate=True)" for all tables. In any case. Make a backup of the .tables before you delete them. In theory, if you lose them it is always possible to rebuild them (they are just picked files. Massimo On Jan 24, 10:54 am, vince <[email protected]> wrote: > i just double check and it should not be file permission issue. > > is it safe to just delete all .table? web2py will auto recreate them? > > On Jan 25, 12:44 am, mdipierro <[email protected]> wrote: > > > I can only see three possible causes of the problem: > > 1) bug in your version of pickle > > 2) file permission issue > > 3) there are some .table files in you databases folder that were > > created by a different python dictribution > > > On Jan 24, 10:16 am, vince <[email protected]> wrote: > > > > i am running from source on linux and mac. > > > > On Jan 23, 6:36 am, mdipierro <[email protected]> wrote: > > > > > Are you using the web2py binary or source? > > > > Did you delete only the .table or everything in databases? > > > > Does you app run if you set migrate=False for all tables? > > > > > Massimo > > > > > On Jan 22, 4:11 pm, Brian M <[email protected]> wrote: > > > > > > Hmm, I've been running into this problem a bunch today. WinXP with > > > > > source web2py 1.74.5 and SQLite. My .table files keep getting > > > > > truncated to 0 bytes for some reason and then web2py chokes. > > > > > > ~Brian > > > > > > On Jan 22, 2:13 pm, Thadeus Burgess <[email protected]> wrote: > > > > > > > looks like a corrupted .table file > > > > > > -Thadeus > > > > > > > On Fri, Jan 22, 2010 at 1:18 PM, vince <[email protected]> wrote: > > > > > > > i just look into the error log for some clean up and found several > > > > > > > ticket with the following errors. i am using 1.74.6, any ideas? > > > > > > > > Traceback (most recent call last): > > > > > > > File "/Library/WebServer/Documents/web2py/gluon/restricted.py", > > > > > > > line > > > > > > > 173, in restricted > > > > > > > exec ccode in environment > > > > > > > File > > > > > > > "/Library/WebServer/Documents/web2py/applications/cms/models/ > > > > > > > db.py", line 137, in <module> > > > > > > > migrate=is_migrate) > > > > > > > File "/Library/WebServer/Documents/web2py/gluon/sql.py", line > > > > > > > 1252, > > > > > > > in define_table > > > > > > > t._create(migrate=migrate, fake_migrate=fake_migrate) > > > > > > > File "/Library/WebServer/Documents/web2py/gluon/sql.py", line > > > > > > > 1703, > > > > > > > in _create > > > > > > > sql_fields_old = cPickle.load(tfile) > > > > > > > EOFError > > > > > > > > -- > > > > > > > You received this message because you are subscribed to the > > > > > > > Google Groups "web2py-users" 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 > > > > > > > athttp://groups.google.com/group/web2py?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web2py-users" 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.
