nothing. this is a known bug which we think is related to timeout in keeping the sqlite connection open. For now use the normal shell.
On Aug 13, 8:59 am, mwolfe02 <michael.joseph.wo...@gmail.com> wrote: > I'm trying to run a very simple select query from the built-in web- > based shell, but I keep getting the following error: The cursor's > connection has been closed. > > Here is the full traceback: > > Traceback (most recent call last): > File "<input>", line 1, in <module> > File "...\web2py\gluon\sql.py", line 3214, in select > rows = response(query) > File "...\web2py\gluon\sql.py", line 3209, in response > db._execute(query) > File "...\web2py\gluon\sql.py", line 1087, in <lambda> > self._execute = lambda *a, **b: self._cursor.execute(*a, **b) > ProgrammingError: The cursor's connection has been closed. > > What am I doing wrong? It would be really hand to debug queries > interactively. > > Thanks, > Mike