Hello David,
Do you have a backup of the databases/ folder that worked with a previous
version?
If so..., delete everything in databases. Than do:
db = DAL('sqlite://storage.sqlite', migrate_enabled=True)
Do you get an error? If you do not get any error, check which table files
different from the backup and newly created ones. Which version are you
upgrading from?
massimo
On Friday, 1 June 2012 20:20:03 UTC-5, david.waldrop wrote:
>
> 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.
>
>
>
>
>
>
