Wrong thread?? On Thu, Aug 25, 2011 at 3:06 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote:
> Did you try grep (http://en.wikipedia.org/wiki/Grep)? > > On Aug 25, 12:53 pm, Eric Scott <erictransla...@gmail.com> wrote: > > I'm using postgresql. I had to change a field name in my table def, > > which are in the web2py models. The database changed accordingly, but > > now I get a key error when I try to insert a new record using > > appadmin. I made sure appadmin.py is the latest and greatest. Still > > getting key error. I don't dare drop the db since each time I've done > > that before I've not been able to get it running again, no matter how > > many variations of migrate and fake_migrate I tried. So end up having > > to re-create the app, and then copy in the files, which takes a long > > time. > > > > I love web2py but database issues are driving me nuts. Can someone > > please help me? My app is so close to finished. > > > > Here's the traceback > > > > Traceback (most recent call last): > > File "/home/www-data/web2py/gluon/restricted.py", line 192, in > > restricted > > exec ccode in environment > > File "/home/www-data/web2py/applications/baristacode/controllers/ > > appadmin.py", line 411, in <module> > > File "/home/www-data/web2py/gluon/globals.py", line 145, in <lambda> > > self._caller = lambda f: f() > > File "/home/www-data/web2py/applications/baristacode/controllers/ > > appadmin.py", line 126, in insert > > form = SQLFORM(db[table], ignore_rw=ignore_rw) > > File "/home/www-data/web2py/gluon/sqlhtml.py", line 830, in __init__ > > inp = self.widgets.options.widget(field, default) > > File "/home/www-data/web2py/gluon/sqlhtml.py", line 218, in widget > > options = requires[0].options() > > File "/home/www-data/web2py/gluon/validators.py", line 438, in > > options > > self.build_set() > > File "/home/www-data/web2py/gluon/validators.py", line 421, in > > build_set > > fields = [self.dbset.db[self.ktable][k] for k in self.fields] > > File "/home/www-data/web2py/gluon/dal.py", line 4675, in __getitem__ > > return dict.__getitem__(self, str(key)) > > KeyError: 'name_string' > > > > By the way, I changed the field name from "name_string" to "name". > > Somewhere, "name_string" is still cached. I just can't figure out > > where. I've cleared the caches, restarted, etc etc. > > > > Thanks in advance for your help. > > > > Eric >
