i just did some test and the error seems to appear when i modify the table definition, eg add a new field with migrate=true. it will only appear in the error log and i won't see the actually error ticket on browsing.
On Jan 25, 1:12 am, mdipierro <[email protected]> wrote: > 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.
