On Tuesday, October 31, 2017 at 3:18:01 AM UTC-7, Oasis Agano wrote: > > Hi > > I have the same issue, 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 appearing. > > In the appadmin section of w2p i can see the 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. You've probably read these parts of the user manual already, but in case others find this old 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 > > > On Tuesday, August 23, 2011 at 5:17:54 PM UTC+2, TomPliss wrote: >> >> Hey (noob here again), >> >> >> I needed to change the type of a field in my DB (the Date one of a >> table was a string, i'm changing its require to IS_DATE). >> but the values for existing entries were "wrong" (string has no >> attribute year), so went on "oh, only tests are in this table, let's >> drop it", and drop it in the sqlite I got, watching the DB. >> >> So I get my DB, with a table not here. >> I restart the web2py server, but the table still isn't here. I save >> the model.py, restart (with the side sqlite off), still not here. >> >> I checked in the book, chapter 06, "By default, migrate is set to >> True". Isn't that what tells web2py to create the table, if it doesn't >> exist ? >> >> What am I missing ? > > > -- 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.