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 [email protected].
For more options, visit https://groups.google.com/d/optout.
