[sqlalchemy] Re: ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

2009-03-17 Thread Timothy N. Tsvetkov
I have the same problem, I've installed pysqlite (2.5.5) from sources, and after I've removed it everything is ok. I've tried to install the last one because I had a common problem: ProgrammingError?: (ProgrammingError?) You must not use 8-bit bytestrings unless you use a text_factory that can

[sqlalchemy] Re: ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

2009-03-17 Thread Michael Bayer
Timothy N. Tsvetkov wrote: I have the same problem, I've installed pysqlite (2.5.5) from sources, and after I've removed it everything is ok. I've tried to install the last one because I had a common problem: ProgrammingError?: (ProgrammingError?) You must not use 8-bit bytestrings unless

[sqlalchemy] Re: ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

2009-03-17 Thread Michael Bayer
OK scratch that, it is in fact fetchone() raising an error on a closed cursor that's the difference, the PRAGMA behavior, to my surprise, was always there. an adjustment to the sqlite dialect is made in r5846 for 0.5 and r5847 for the 0.4 branch. A release for 0.5 should be made before

[sqlalchemy] Re: ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

2009-03-15 Thread Michael Bayer
that looks like somehting wrong with your pysqlite install.Note that if you're on Python 2.5 or 2.6, sqlite3 is included, so in this case I'd recommend uninstalling any external pysqlite installs for that python installation. On Mar 15, 2009, at 5:36 AM, GeertVc wrote: Hi, I have

[sqlalchemy] Re: ProgrammingError: (ProgrammingError) Cannot operate on a closed cursor. None None

2009-03-15 Thread Michael Bayer
this appears to be a SQLite bug and I've created a ticket at: http://oss.itsystementwicklung.de/trac/pysqlite/ticket/256 On Mar 15, 2009, at 5:36 AM, GeertVc wrote: Hi, I have a problem following the DivingIn tutorial on http://elixir.ematia.de/trac/wiki/TutorialDivingIn. I've posted a