oh that's why. thank for the info. On Jan 25, 3:24 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > You can have a problem with sqlite if you remove a field and you add > it again with the same name. > > This is because sqlite does not support ALTER TABLE ... DROP. > > Massimo > > On Jan 24, 1:21 pm, vince <lapcc...@gmail.com> wrote: > > > > > i can't sort out how to reproduce it anyway, it's not happening > > everytime i add a field. i'll see if the clean up of .table works > > > On Jan 25, 2:58 am, vince <lapcc...@gmail.com> wrote: > > > > 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 <mdipie...@cs.depaul.edu> 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 <lapcc...@gmail.com> 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 <mdipie...@cs.depaul.edu> 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 <lapcc...@gmail.com> wrote: > > > > > > > > i am running from source on linux and mac. > > > > > > > > On Jan 23, 6:36 am, mdipierro <mdipie...@cs.depaul.edu> 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 <bmere...@gmail.com> 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 <thade...@thadeusb.com> > > > > > > > > > wrote: > > > > > > > > > > > looks like a corrupted .table file > > > > > > > > > > -Thadeus > > > > > > > > > > > On Fri, Jan 22, 2010 at 1:18 PM, vince <lapcc...@gmail.com> > > > > > > > > > > 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 > > > > > > > > > > > web...@googlegroups.com. > > > > > > > > > > > To unsubscribe from this group, send email to > > > > > > > > > > > web2py+unsubscr...@googlegroups.com. > > > > > > > > > > > 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 web...@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.
