Hello,

(1) I use sqlite

(2) In development I made the following change to a given table:
db.define_table(...
    Field('description', 'text'),
...
) 
becomes:
db.define_table(...
    Field('description_en', 'text'),
    Field('description_fr', 'text'),
...
) 
Everything went well.

(3) Then I tried to apply the same changes to the production database and 
it gave me the
error: "column description_en does not exist" when the application try to 
access the table.
The migration did not occur. The database still has only the description 
field in it.

(4) I tried to get rid of the table files (migration files from the 
databases folder) related to that table
without success ("table does not exist")

(5) I tried to get rid of my changes in the models file and use:
db_es = DAL('sqlite://estore.db', fake_migrate_all=True) and then
reapply my changes with db_es = DAL('sqlite://estore.db', migrate=True)
with the same error ("description_en does not exist")

Please, how could I solve that problem?

Thanks!

-- 
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
--- 
You received this message because you are subscribed to the Google Groups 
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to