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.
