It all started with an a single column deletion on a single table in my db.py: <class 'gluon.contrib.pymysql.err.InternalError'> (1025, u"Error on rename of './db_myapp/#sql-198_246f' to './db_myapp/note' (errno: 150)")
Since then I've spent *hours* trying to reconstitute the database files in any way possible. An earlier issue I had reported here<https://groups.google.com/forum/?fromgroups#!topic/web2py/YUDE19OQC8M> had been resolved by setting migrate=True, fake_migrate_all=True, but this time around this doesn't do anything. The only time I can get the app running is when migrate=False. Any time migrate=True, in *any* combination with fake_migrate, my connection hangs, I get no errors, no db files ever get built, and have to quit the server. I've even cleared out the entire db.py file except for the auth table, and still, migrate=True causes a hang. Since that first error I haven't been able to generate a single error, or generate a single db file, in any conceivable combination. At this point I'm at a complete dead end and can't imagine what the issue could be or what more to try. 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.
