So this is the whole procedure I did at the end and it seems to do the trick
1. create a folder for your new app (WoShiTest) 2. copy production version there 3. delete content of sessions, error and DATABASE folders 4. in 0.py set db connection string 5. set migrate = True and false migrate = False 6. create database in postgres with the name you put in 0.py 7. start web2py (in my case from cmd running web2py.exe -i 192.168.100.47 -p 8080 -a 12345 -K WoShiTest -X) 8. check if db is created and access to the webapp 9. it works? Good 10. delete database on postgres 11. create new with the same name and restore the production db with all your data 12. no errors or warnings? Good 13. again run web2py server and check if all the stuff works - now including login stuff 14. it does? No! You are getting ERROR:web2py.scheduler.ue-ebi#2488: error popping tasks --> stop server. delete all scheduler related tables on postgres and files in database folder related to scheduler table 15. run server again 16. now it works? Great - almost there 17. now lets update the current app to the new/develop app 18. copy the following folders from develop app - controlers, model, modules, static, ...view and all you think you need EXCEPT errors, sessions and of course DATABASE 19. update 0.py and set new db connection 20. now start using your brand new updated bugfree app :) I hope somebody finds this useful On Tuesday, October 24, 2017 at 10:32:11 PM UTC+2, Alex Glaros wrote: > > I'm a beginner but seems like you should create your new version to first > be exact duplicate of the original, pg_restore db to the new version, make > sure it's working like old one, THEN change DAL tables, then run migrate = > True. (I haven't needed to run fake_migrate in these situations) > > Maybe I read it wrong but looks like you changed DAL first on the new > instance, then imported Postgres db. > > Of course keep your Postgres archive as permanent backup. > > Alex Glaros > -- 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. For more options, visit https://groups.google.com/d/optout.
