(a) Because when you changed the DAL connection string, web2py thinks it might be a new database and tries to recreate the tables from scratch.
(b) You could try: db = DAL(...,fake_migrate_all=True) run the app and, if successful, then: db = DAL(...,fake_migrate_all=False) But read the instructions in the book first http://web2py.com/books/default/chapter/29/06?search=fake_migrate On Tuesday, February 5, 2013 7:08:27 AM UTC+13, Neil wrote: > > I've changed the user password for my Postgresql database. When I make the > update to the DAL connection string, I then get the following error: > > postgresql error ... <class 'psycopg2.ProgrammingError'>(relation > "auth_user" already exists) > > when going to the site. Notes: > > - I've made no other changes to the database or model files > - I know the password is correct, because when I deliberately use the > wrong password I get a different message (about not being able to connect > to the database). > - When I revert to the old password (in both the connection string and > the database), everything starts working again. > > Anyone know (a) what is causing this, and (b) how I can get around it? > > Neil > -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
