Hi Cliff, Via SQL developer and also through using DAL on the command line. I've seen delays from problems in syntax and misplellings too however omething else is going on. The rocket server will actually lock up and require me to end it's process. Too.
On Monday, October 8, 2012 9:08:58 PM UTC-5, Cliff Kachinske wrote: > > Can you connect to the database outside of Web2py? > > The long delay can mean connection problems, which I have induced by > typing the db name incorrectly. > > On Monday, October 8, 2012 8:06:58 PM UTC-4, Bill Thayer wrote: >> >> Hi Massimo, >> >> Thank you. >> >> After installing the latest version I deleted the contents of the >> databases folder and run with DAL(...,migrate=True) got one error, set the >> table causing the error to migrate=false and re-ran. Now all the database >> tables are created but now (after seting my settings.migrate to False in >> 0.py the browser just shows the spinner when I try to access my app's index >> page. The progress bar is shows only half progress. >> >> Regards, >> Bill >> >> On Monday, October 8, 2012 5:53:04 PM UTC-5, Massimo Di Pierro wrote: >>> >>> LOL >>> >>> - Make sure you use stable "Version 2.0.9 (2012-09-13 23:51:30)" of the >>> latest trunk. Not any intermediate version. >>> - do not use the wizard if you do not want crap. The wizard is >>> experimental and not the best piece of web2py. >>> - If your tables already exist and you are happy with them run onces >>> with db = DAL(....,fake_migrate=True) and then run with >>> DAL(...,migrate=false) >>> - If instead you want web2py to create tables and use migrations, delete >>> you database, re-create it empty, delete everything under >>> yourapp/databases/ and run with DAL(...,migrate=True). >>> >>> On Monday, 8 October 2012 17:33:06 UTC-5, Bill Thayer wrote: >>>> >>>> Ok, >>>> >>>> I have my Oracle database. From some attempted migrations I have the >>>> auth tables defined and two other tables defined of about 17 tables.The >>>> typical error is Object with that name already exists or some crap like >>>> that. I figured clicking the clean button would help... DON"T DO THAT! Now >>>> my browser just spins and spins. >>>> >>>> My SQL log has a bunch of crap that i do not want created in my >>>> database like archive tables that the wizard created. Yet if I delete the >>>> log file it will not re-create with a fresh log. >>>> >>>> After restoiring my backup my sql.log file has 2627 lines in it and the >>>> time stamps go back 6 days when I started this all from scratch. >>>> >>>> Without having to re-create my application again. How can i just get a >>>> nice clean SQL file and how, once connect to my DB can I get my new db.py >>>> or db_wizard.py definitions to make the database tables that aren't >>>> already >>>> created without throwing errors for the ones that already are? >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> --
