On Tuesday, October 31, 2017 at 3:44:30 AM UTC-7, Oasis Agano wrote: > > Hi > > I am facing an issue of table migration where my table is not being > created > in the database, > > > i have changed migrate to* migrate='tablename.table'*, > deleted the *tablename.table* inside the database folder, > set *fake_migrations to true* but the issue is still coming. > > In the *appadmin* section of w2p i can see the table and in the > *database*/ > folder i can see 4 new tables created(i think its due to auth signature > because they are named tablename.table, tablename.tableauthcas.table...). > but when i open it the error appears > " > raise errorclass, errorvalue > > ProgrammingError: (1146, "Table 'database.table' doesn't exist") > " > > and inside the mysql console the table is indeed not there. > > Im i missing something? > > > I'm not answering directly, sorry, except that if mysql doesn't have the table you may want migrate instead of fake_migrate.
You've probably read these parts of the user manual already, but in case others find this thread in a search, I want the links to be here. <URL: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#migrate--fake_migrate > <URL: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Fixing-broken-migrations > <URL: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Migration-control-summary> /dps -- 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.
