It says: InternalError: (1050, u"Table 'app_version' already exists")
When migrate=True. And it is true. I don't want it to recreate anything. What does web2py detect here? that tables are different from .table file? Should I delete .table files? On Sep 9, 2:34 pm, Massimo Di Pierro <[email protected]> wrote: > If web2py tries to create it then it does not know it exist. If you do > know and web2py does not know it means something is wrong with the > database metadata and needs rebuilding. You can do > > db.define_tables(...,migrate=True,fake_migrate=True) > > to rebuild metadata. Once done, remove the fake_migrate option. > > On Sep 9, 4:19 am,vortex<[email protected]> wrote: > > > > > > > > > What should be the definition so that web2py only alters the mysql > > table to correspond to the new definition but if it exists not to > > create it. > > > db_server.define_table('db_version', > > Field('major', 'integer', default = 0), > > Field('minor', 'integer', default = 0), > > migrate= True, > > ) > > > Or at least never to create the table but alter it if needed.
