>
> Fixing broken migrations...
>
> db.define_table(....,migrate=False,fake_migrate=True) means rebuild the table
> meta data according to the table definitions.
> db = DAL(...,fake_migrate_all=True) means you are fixing all the tables at
> once but will not help in narrowing down the problem.
>
> Looks like the metadata matches my table definitions. I have narrowed the
> problem down to wiki page does not exist in the database. Since it doesn't
> exist in
> metadata either then what's the problem? Shouldn't the behavior be to create
> the database table and the table metadata? That is my desire.
>
> if I delete all of my meta data that usually creates more problems. But in
> theory setting migrate=False, fake_migrate_all=True then all the
> metadata gets rebuilt without touching the database. Not my intention as I
> want the missing tables added.
>
>
> db = DAL('oracle://uname/pw@dbserver:1521', migrate=False,
> fake_migrate_all=True)
>
>
> auth.define_tables(username=True, signature=False, migrate=False,
> fake_migrate=True)
>
> Error:
>
> <class 'cx_Oracle.DatabaseError'> ORA-00942: table or view does not exist
>
>
> and Welcome /database has 6 auth tables and wiki_<media, page, tag>
>
> So this should not build metadata but go ahead and build the tables not in
> the database:
>
> db = DAL('oracle://uname/pw@dbserver:1521', migrate=True)
>
> auth.define_tables(username=True, signature=False, migrate=True,
> fake_migrate=False)
>
> Error:
>
> <class 'cx_Oracle.DatabaseError'> ORA-00955: name is already used by an
> existing object
>
>
> No Kidding! There's no way I'm going to delete my auth_user table from
> Oracle at this point, I have another app using it!
>
>
> Perhaps this will create the missing tables?
>
>
> db = DAL('oracle://uname/pw@dbserver:1521', migrate=True)
>
> auth.define_tables(username=True, signature=False, migrate=False,
> fake_migrate=False)
>
> Now my browser is spinning and spinning. I suspect that the rocket server
> is hung again and I need to stop the process with the task manager. I'll
> give it a few minutes and see.
>
>
>
>
>
>
>
--
