Should be migrate = True fake_migrate = True db = DAL(db_uri, migrate=migrate, fake_migrate=fake_migrate)
And after one run, that recreate metadata files in databases folder: migrate = True fake_migrate = False db = DAL(db_uri, migrate=migrate, fake_migrate=fake_migrate) maybe you can also check your databases folder permissions. Web2py needs to be able to write into. Il giorno dom 17 lug 2022 alle ore 17:17 Vlad <westgate6...@gmail.com> ha scritto: > Massimiliano, thank you for the suggestion. > > I tried fake_migrate=True - it works fine, but then I switched it back to > migrate=True , and it crashed again. > (migrate=False works perfectly.) > > Any ideas? > > On Sunday, July 17, 2022 at 5:42:11 AM UTC-4 Massimiliano wrote: > >> You can try fake_migrate=True so that DAL recreates tables metafata >> files in the database folder. >> Once done, you can restore fake_migrate=False and migrate=True. >> >> Should work >> >> Il giorno dom 17 lug 2022 alle ore 07:06 Vlad <westga...@gmail.com> ha >> scritto: >> >>> I've been using PythonAnywhere Postgres hosting for a while. Used >>> pg_dump and pg_restore to recreate the database in ElephantSQL. >>> Not sure if this has contributed to the problem, but had to use options >>> that drop owner and privileges (otherwise pg_restore generated errors, >>> complaining about non-existing roles etc.) >>> In the end, everything works perfectly except that I must use >>> migrate=false option only. >>> If migrate=true - it attempts to recreate all the tables and, obviously, >>> complains that tables already exist - because they do exist. >>> Greatly appreciate suggestions on how to fix this. >>> >>> A side question on efficiency: visually I notice that PythonAnywhere >>> postgres hosting works quicker (but ElephantSQL is theoretically better >>> hosting). Is it because in PA both app and db run "in close proximity", >>> presumably on the same server? >>> >>> -- >>> Resources: >>> - http://web2py.com >>> - http://web2py.com/book (Documentation) >>> - http://github.com/web2py/web2py (Source code) >>> - https://code.google.com/p/web2py/issues/list (Report Issues) >>> --- >>> 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 web2py+un...@googlegroups.com. >>> To view this discussion on the web visit >>> https://groups.google.com/d/msgid/web2py/abcae64b-e9b3-4d30-9ae7-98ff01cb51ban%40googlegroups.com >>> <https://groups.google.com/d/msgid/web2py/abcae64b-e9b3-4d30-9ae7-98ff01cb51ban%40googlegroups.com?utm_medium=email&utm_source=footer> >>> . >>> >> >> >> -- >> Massimiliano >> > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > 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 web2py+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/web2py/872ddea5-4c39-4cf8-ad94-ac852f674dd3n%40googlegroups.com > <https://groups.google.com/d/msgid/web2py/872ddea5-4c39-4cf8-ad94-ac852f674dd3n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Massimiliano -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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 web2py+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/web2py/CANPTPxJ5R_ocbegJTeY2otBQYea5ctLmdww3yzed4zVszESRzA%40mail.gmail.com.
