[web2py] Re: SQLFORM hanging on insert

2015-04-13 Thread Derek
You may want to run some database consistency checks. I've had that happen when one of my tables was corrupted. On Saturday, April 11, 2015 at 8:16:22 AM UTC-7, Ian W. Scott wrote: > > Update: When I put together a minimal app I couldn't reproduce the > problem. I've had to set aside working on

[web2py] Re: SQLFORM hanging on insert

2015-04-11 Thread Ian W. Scott
Update: When I put together a minimal app I couldn't reproduce the problem. I've had to set aside working on the issue, but it does seem to be limited to working with one specific table in my app's db. When I get back to debugging this I'll post any solutions for the sake of posterity. On Frida

[web2py] Re: SQLFORM hanging on insert

2015-02-06 Thread Ian W. Scott
Thanks for your response Massimo. I'll try to put together a minimal version today and post it. Ian On Thursday, February 5, 2015 at 4:46:46 PM UTC-5, Massimo Di Pierro wrote: > > Does it hang if you use sqlite? Can you provide a minimalist app that we > can try. There is nothing wrong with you

[web2py] Re: SQLFORM hanging on insert

2015-02-05 Thread Massimo Di Pierro
Does it hang if you use sqlite? Can you provide a minimalist app that we can try. There is nothing wrong with your code except you do not need db.commit() but it should not hurt. On Thursday, 5 February 2015 14:46:58 UTC-6, Ian W. Scott wrote: > > Hi folks. I still don't really know how to debug

[web2py] Re: SQLFORM hanging on insert

2015-02-05 Thread Ian W. Scott
Hi folks. I still don't really know how to debug this problem beyond what I've done (identify the point in the gluon code where the hang happens). Can anyone at least suggest another strategy for debugging it? Thanks again, Ian On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott wr

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
Thanks, Michelle, for spelling out what Niphlod meant about the shell. Ignore the db.commit() in the controller code. That was something I threw in briefly to see what would happen. I forgot to remove it. When I do db.commit() from the interactive prompt it doesn't hang or stall. I'm using pos

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Michele Comitini
Why do you commit? not needed and even dangerous in that position. What db are you using? Do as niphlod suggests: python web2py.py -M -S At the prompt issue: [1] db.commit() does it stall? Il giorno venerdì 30 gennaio 2015 18:10:23 UTC+1, Ian W. Scott ha scritto: > > If it helps at all,

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
If it helps at all, here's the controller function that creates and processes the form: def dupAndEdit(): """Create and process a form to insert a new record, pre-populated with field values copied from an existing record.""" tablename = request.args[0] rowid = request.args[1]

[web2py] Re: SQLFORM hanging on insert

2015-01-30 Thread Ian W. Scott
Thanks for the suggestion Niphlod. I'm just not sure what you mean by "start a shell". Can you explain? Ian On Thursday, January 29, 2015 at 4:28:15 PM UTC-5, Niphlod wrote: > > what about if you start a shell and issue the insert statement with a > db.commit() ? does it hang also there ? > > O

[web2py] Re: SQLFORM hanging on insert

2015-01-29 Thread Niphlod
what about if you start a shell and issue the insert statement with a db.commit() ? does it hang also there ? On Thursday, January 29, 2015 at 10:05:30 PM UTC+1, Ian W. Scott wrote: > > Oh, and I'm running version 2.9.11-stable. > > On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott

[web2py] Re: SQLFORM hanging on insert

2015-01-29 Thread Ian W. Scott
Oh, and I'm running version 2.9.11-stable. On Thursday, January 29, 2015 at 4:00:54 PM UTC-5, Ian W. Scott wrote: > > I have a create form (SQLFORM) that works (a new record is actually > created) but immediately after inserting the new record the web2py process > hangs. The form remains greyed