What does this do exactly? Can you explain?
I've seen "fake_migrate" a few times, but unsure what it does. Thanks. On Mar 20, 12:05 am, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > ask web2py to repair it > > auth.define_tables(fake_migrate=True) > > On Mar 19, 10:16 pm, VP <vtp2...@gmail.com> wrote: > > > I've had problems with backup/restore. These could be very serious > > problems. So, with version 1.94.5, I simulated a backup/restore > > scenario and found a problem. > > > 1. Backup up database with (psql_dump database > database.sql) > > > 2. Create another database (psql database2 < database.sql) > > > 3. Replace "database" in the connection string with "database2". > > > These 3 steps is to simulate a backup/restore scenario. The > > (uncompiled) codebase remains unchanged during these 3 steps. > > > One would think this should work, but it doesn't; at least with my > > app. Here's the error's trackback: > > > Traceback (most recent call last): > > File "/home/username/web2py/gluon/restricted.py", line 188, in > > restricted > > exec ccode in environment > > File "/home/username/web2py/applications/phim/models/db.py", line > > 42, in <module> > > auth.define_tables() # creates all > > needed tables > > File "/home/username/web2py/gluon/tools.py", line 1177, in > > define_tables > > format='%(first_name)s %(last_name)s (%(id)s)') > > File "/home/username/web2py/gluon/dal.py", line 3884, in > > define_table > > polymodel=polymodel) > > File "/home/username/web2py/gluon/dal.py", line 581, in create_table > > self.create_sequence_and_triggers(query,table) > > File "/home/username/web2py/gluon/dal.py", line 1575, in > > create_sequence_and_triggers > > self.execute(query) > > File "/home/username/web2py/gluon/dal.py", line 1137, in execute > > return self.log_execute(*a, **b) > > File "/home/username/web2py/gluon/dal.py", line 1134, in log_execute > > return self.cursor.execute(*a,**b) > > ProgrammingError: relation "auth_user" already exists > > > ===== > > > PS: btw, I'm not modifying auth in anyway. It's web2py's default. > >