Note, the 'migrate' and 'fake_migrate' arguments to DAL may not do what you
think they should do -- they merely set the 'migrate' and 'fake_migrate'
default values for any table definitions that do not explicitly set those
arguments -- if a table explicitly sets one or both of those arguments, that
will override the DAL arguments. I think auth.define_tables may explicitly
set 'migrate' to True for auth tables unless you do
auth.define_tables(migrate=False).
If you want to override the explicit arguments of all individual tables,
use DAL(...,fake_migrate_all=True) to force fake migration of all tables,
and DAL(...,migrate_enabled=False) to force all migrations off.
Anthony
On Monday, June 27, 2011 4:09:54 PM UTC-4, Christopher Baron wrote:
> I've tried
>
> db = DAL("mysql://%s:%s@%s/%s" % (user, password, host, dbname),
> migrate=False)
>
> and still have the same problem.
>
> On Jun 27, 3:07 pm, Christopher Baron <[email protected]> wrote:
> > I upgraded via the admin update link and received an error, so I went
> > ahead and downloaded the source.
> >
> > Regarding the migration techniques, the exception is being thrown on
> > creating web2py auth tables - specifically the following line of
> > code :
> >
> > auth.define_tables()
> >
> > Shouldn't web2py handle this for me? Perhaps I need to include a line
> > similar to the following?
> >
> > db = DAL('sqlite://storage.db', migrate=False)
> >
> > On Jun 27, 2:45 pm, Richard Vézina <[email protected]>
> > wrote:
> >
> >
> >
> >
> >
> >
> >
> > > Have you try :
> >
> > >http://www.web2py.com/book/default/chapter/06?search=migrate#Fixing-B...
>
> >
> > > You should use migrate=False in your models once your tables have been
> > > created and you know you will not have to modify them...
> >
> > > Richard
> >
> > > On Mon, Jun 27, 2011 at 3:40 PM, Richard Vézina <[email protected]
> >
> > > > wrote:
> > > > Did you upgrade by the web2py "admin" update link?
> >
> > > > Richard
> >
> > > > On Mon, Jun 27, 2011 at 2:22 PM, Christopher Baron <
> [email protected]
> > > > > wrote:
> >
> > > >> Hi web2py users,
> >
> > > >> Just upgraded to Version 1.97.1
> >
> > > >> I checked my code out into the new directory, opened my browser, and
>
> > > >> received and error stating 'auth_cas' already exists.
> >
> > > >> I removed all files from the databases folder and tried again
> > > >> receiving an error that 'auth_user' already exists.
> >
> > > >> I'm using a private/config file that points to some mysql database
> on
> > > >> another server.
> >
> > > >> What can I do ?
> >
> > > >> I'd be happy to share more information needed to help solve the
> > > >> problem.
> >
> > > >> Thanks in advance,
> >
> > > >> Chris
