Here are the answers to your questions in my case: - I am using 1.83.2 on Windows. - The DB in this test is sqlite. - I am using a custom auth but 2 of the 3 instances of the problem (another db table file was removed since I posted earlier today) occurred in non-auth tables. - I am not using 'notnull = True' on any table within the application. - I will download the nightly build now and let you know how it works out.
On Sep 1, 9:09 pm, mdipierro <[email protected]> wrote: > ... and what db are you using, sqlite? > do you use a custom auth table? > do you use notnull=True in any of your tables? > > Massimo > > On Sep 1, 11:07 pm, mdipierro <[email protected]> wrote: > > > > > before we work on a fix. Let me understand what is causing this. What > > version are you upgrading from? > > > massimo > > > On Sep 1, 6:07 pm, berubejd <[email protected]> wrote: > > > > This has happened to me twice in the last week on two different > > > tables. I have started backing up the table files so that I can > > > restore them. I will try to use fake_migrate next time. > > > > Is there any way to avoid having this happen in the first place? > > > > Thanks! > > > Jeff > > > > On Sep 1, 10:55 am, mdipierro <[email protected]> wrote: > > > > > yes. db.define_table(...,fake_migrate=True) > > > > > On Sep 1, 12:11 pm, vince <[email protected]> wrote: > > > > > > upgraded to 1.83.2, the application itself run fine just with this > > > > > error appearing in error log sometimes. > > > > > > is there any way to regenerate the db table file? > > > > > > Traceback (most recent call last): > > > > > File "gluon/restricted.py", line 186, in restricted > > > > > exec ccode in environment > > > > > File "/home/web2py/applications/cms/models/db.py", line 36, in > > > > > <module> > > > > > auth.define_tables() # creates all needed > > > > > tables > > > > > File "gluon/tools.py", line 1153, in define_tables > > > > > self.settings.table_membership_name, migrate)) > > > > > File "gluon/sql.py", line 1359, in define_table > > > > > t._create(migrate=migrate, fake_migrate=fake_migrate) > > > > > File "gluon/sql.py", line 1839, in _create > > > > > raise RuntimeError, 'File %s appears corrupted' % self._dbt > > > > > RuntimeError: File /home/web2py/applications/cms/databases/ > > > > > fb87181b96a99be45f5a23f4277867ce_auth_membership.table appears > > > > > corrupted
