Ok,
auth.define_tables( migrate=False )
seems to fix it, but what happens when a future web2py update changes
the auth tables ?
On Jun 27, 3:09 pm, Christopher Baron <cba...@fieldmuseum.org> 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 <cba...@fieldmuseum.org> 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 <ml.richard.vez...@gmail.com>
> > 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
> > > <ml.richard.vez...@gmail.com
>
> > > > wrote:
> > > > Did you upgrade by the web2py "admin" update link?
>
> > > > Richard
>
> > > > On Mon, Jun 27, 2011 at 2:22 PM, Christopher Baron
> > > > <cba...@fieldmuseum.org
> > > > > 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
