When you deleted the db, did you also delete the associated .table files? You should have
On Jun 24, 10:31 am, Manuele Pesenti <manuele.pese...@gmail.com> wrote: > dear all, > I've added a unique field to some existing tables and w2p gave me an > error saing that he cannot add unique fields to a table so I deleted my > db and restarted as a new application but I obtained this: > > ProgrammingError: Cannot operate on a closed database. > > it's sufficient to comment out the property unique=True and no errors > occurs. > > Here under you can find the complete traceback. > Any suggestion?? > > Thanks a lot > > Manuele > > Traceback (most recent call last): > File > "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/restricted.py", line > 192, in restricted > exec ccode in environment > File > "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/applications/wind2pow2/contro > llers/appadmin.py", > line 410, in <module> > File "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/globals.py", > line 137, in <lambda> > self._caller = lambda f: f() > File > "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/applications/wind2pow2/contro > llers/appadmin.py", > line 126, in insert > form = SQLFORM(db[table], ignore_rw=ignore_rw) > File "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/sqlhtml.py", > line 817, in __init__ > inp = self.widgets.options.widget(field, default) > File "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/sqlhtml.py", > line 206, in widget > options = requires[0].options() > File > "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/validators.py", line > 438, in options > self.build_set() > File > "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/validators.py", line > 426, in build_set > records = self.dbset.select(*fields, **dd) > File "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/dal.py", > line 5382, in select > return self.db._adapter.select(self.query,fields,attributes) > File "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/dal.py", > line 1159, in select > rows = response(sql) > File "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/dal.py", > line 1149, in response > self.execute(sql) > File "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/dal.py", > line 1234, in execute > return self.log_execute(*a, **b) > File "/home/manuele/Dropbox/sviluppo/web2py-1.96.4/gluon/dal.py", > line 1229, in log_execute > ret = self.cursor.execute(*a,**b) > ProgrammingError: Cannot operate on a closed database.
