I just downloaded the nightly build form Trunk to test the new web2py 2.0 with some of my web2py based solutions. I now have a very weird eroor I think due to migrating the database form postgress (production) to sqllite (development). Here is one of the errors I get:
Traceback (most recent call last): File "gluon/restricted.py", line 205, in restricted File "C:/Users/david/My Projects/Miscelaneous/web2py/applications/COPSIS/controllers/items.py" <http://127.0.0.1:8000/admin/default/edit/COPSIS/controllers/items.py>, line 776, in <module> File "gluon/globals.py", line 175, in <lambda> File "gluon/tools.py", line 2679, in f File "C:/Users/david/My Projects/Miscelaneous/web2py/applications/COPSIS/controllers/items.py" <http://127.0.0.1:8000/admin/default/edit/COPSIS/controllers/items.py>, line 20, in additem File "gluon/sqlhtml.py", line 1298, in accepts File "gluon/dal.py", line 7255, in insert File "gluon/dal.py", line 1009, in insert OperationalError: table item has no column named name I have tried several of the migration options, but none seem to work thus far. Here is the code in db.py I tried after searching the google group: db = DAL('sqlite://storage.sqlite', migrate_enabled=True, fake_migrate_all=True) When I look in the application/database subdirectory there are not .table files for each table, which does not seem correct. Any Ideas or suggestions would be greatly appreciated.
