Sorry villas. Tried that already but failed to mention it. The auth tables are listed but not the auth.wiki tables. yet they are in the databases folder. The sql log shows the creation in the transcript but the database is not creating them. So is there a particular way to access the auth.wiki pages that I don't know about?
Available Databases and Tables db.auth_user<http://127.0.0.1:8000/welcome/appadmin/select/db?query=db.auth_user.id%3E0> New Record <http://127.0.0.1:8000/welcome/appadmin/insert/db/auth_user> db.auth_group<http://127.0.0.1:8000/welcome/appadmin/select/db?query=db.auth_group.id%3E0> New Record <http://127.0.0.1:8000/welcome/appadmin/insert/db/auth_group> db.auth_membership<http://127.0.0.1:8000/welcome/appadmin/select/db?query=db.auth_membership.id%3E0> New Record <http://127.0.0.1:8000/welcome/appadmin/insert/db/auth_membership> db.auth_permission<http://127.0.0.1:8000/welcome/appadmin/select/db?query=db.auth_permission.id%3E0> New Record <http://127.0.0.1:8000/welcome/appadmin/insert/db/auth_permission> db.auth_event<http://127.0.0.1:8000/welcome/appadmin/select/db?query=db.auth_event.id%3E0> New Record <http://127.0.0.1:8000/welcome/appadmin/insert/db/auth_event> db.auth_cas<http://127.0.0.1:8000/welcome/appadmin/select/db?query=db.auth_cas.id%3E0> New Record <http://127.0.0.1:8000/welcome/appadmin/insert/db/auth_cas> no wiki tables here yet On Tuesday, October 9, 2012 5:25:44 PM UTC-5, villas wrote: > > Myabe you missed my point 1 ? > > When migrating my DB... > > 1. I have to remember to access a auth.wiki page to make sure my wiki > table definitions are run. > > > > On Tuesday, October 9, 2012 11:19:28 PM UTC+1, Bill Thayer wrote: >> >> 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. >>> >>> >>> >>> >>> >>> >>> --
