Fixed Thankfully... 1) Renamed the table in the model 2) Uploaded the backup csv file to the renamed table... was about a week out of date 3) Manually deleted the corrupt file from the database 4) Created a new table with the old table name without fields and set migrate and fake_migrate to true 5) Deleted this model and renamed the model holding the backup files back to its original name...
and (quite miraculously) everything appeared as it was immediately before the crash... Thanks for the help everyone... On Saturday, 6 September 2014 03:15:27 UTC+10, Greg Vaughan wrote: > > Version > Enter code here... > > > web2py™ Version 2.8.2-stable+timestamp.2013.11.28.13.54.07 Python Python > 2.7.5+: /usr/local/bin/uwsgi (prefix: /usr) Traceback > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 12. > 13. > > Traceback (most recent call last): > File "/home/gsv/enertek/web2py/gluon/restricted.py", line 217, in restricted > exec ccode in environment > File "/home/gsv/enertek/web2py/applications/welcome/models/marketing.py" > <https://www.enerteksecure.com/admin/default/edit/welcome/models/marketing.py>, > line 198, in <module> > auth.signature > File "/home/gsv/enertek/web2py/gluon/dal.py", line 8139, in define_table > table = self.lazy_define_table(tablename,*fields,**args) > File "/home/gsv/enertek/web2py/gluon/dal.py", line 8176, in > lazy_define_table > polymodel=polymodel) > File "/home/gsv/enertek/web2py/gluon/dal.py", line 1079, in create_table > raise RuntimeError('File %s appears corrupted' % table._dbt) > RuntimeError: File > /home/gsv/enertek/web2py/applications/welcome/databases/c8b669d15150d7109e5f7ab36744a5b7_sales_leads.table > appears corrupted > > > > On Saturday, 6 September 2014 03:05:27 UTC+10, Greg Vaughan wrote: >> >> Tried fake_migrate... production site on pythonanywhere so disk space >> wasn't the issue... scratching my head with this... >> >> On Saturday, 6 September 2014 02:55:23 UTC+10, Marin Pranjić wrote: >>> >>> It can happen if you run out of disk space. You should check it. >>> >>> Btw, maybe just .table got corrupted... Make sure to backup everything, >>> and then do a fake migrate. >>> >>> Marin >>> >>> >>> On Fri, Sep 5, 2014 at 6:51 PM, Greg Vaughan <[email protected]> >>> wrote: >>> >>>> I wasn't working on the site at the time... I was notified by some of >>>> the employees... yes it looks like the table has been dropped... I cannot >>>> for the life of me work out how that could have happened though. >>>> >>>> >>>> On Saturday, 6 September 2014 02:41:30 UTC+10, Leonel Câmara wrote: >>>>> >>>>> Err wait a minute the table has actually been dropped? >>>>> >>>> -- >>>> Resources: >>>> - http://web2py.com >>>> - http://web2py.com/book (Documentation) >>>> - http://github.com/web2py/web2py (Source code) >>>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "web2py-users" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to [email protected]. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
