On 8 May 2012 07:17, Yarin <[email protected]> wrote: > > I understand that the db definitions may be corrupted from time to time, > even though in this case I see no reason why they should have been. But my > real concern is that *there's no process I can fall back on to rebuild > the definitions from scratch*. Please help me with this. >
What is happening in the database itself: Can you browse the data in mysql outside web2py? If so, you can try the following: * Backup your mysql database (mysqldump) * Export the mysql-data to csv-file(s). * Drop the tables * Fix your models. * delete all the files in web2py/applications<yourapp>/databases * start the app again (try "python web2py.py -M -N -S <yourapp>"). This will recreate the tables. * from appadmin: export the empty tables to get the correct csv-file headings. * adapt your previously exported csv-files to fit the exported headings. * try and import it. Regards Johann -- Because experiencing your loyal love is better than life itself, my lips will praise you. (Psalm 63:3)
