Try this: db = DAL('sqlite://storage.db', migrate=True, fake_migrate=True)
if everything works than your .table files are correct, remove migrate=True, fake_migrate=True and you should be fine. 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