Is this the correct controller?
def index():
"""
example action using the internationalization operator T and flash
rendered by views/default/index.html or views/generic.html
if you need a simple wiki simple replace the two lines below with:
return auth.wiki()
"""
response.flash = T("Welcome to web2py!")
return auth.wiki()
On Tuesday, October 9, 2012 9:30:00 PM UTC-5, Massimo Di Pierro wrote:
>
> Bill,
>
> have you tried using web2py wil sqlite only? does that work for you? I do
> not understand the reason for migrate=false.
>
> On Tuesday, 9 October 2012 17:19:28 UTC-5, 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.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
--
