More headaches. I gave up on trying to migrate because I do not know what is going on. I suspect the DAL table definitions, the actual database tables, and the mysterious *.table files are out of sync in some weird way. If anyone has any pointers on this I think I will have to figure it out sooner or later in order to deploy production apps.
Meanwhile I have hit another dead end. I tried to delete the entire content of the database sub-directory, let web2py rebuild the empty table structures, and use the db.export_to_csv, and db.import_from_csv capability. This appeared to work, but did not preserve the correct relationships between tables. For example in production my id is associated with "meeting.ids" 1 and 19, but after export and import I was associated with someone else's meeting. This has been a long weekend so far with very little progress. I am hoping the breakthroughs start right now.
