[Zope] Arrrgh!!! *Weird* SQLSession problem

[Charlie Wilkinson]

Ok, all weekend I've been chasing my tail.  Now I scream for help...

I cannot get SQLSession to insert values into the zsession_data table
to save my freeking life.  I'm not getting errors of any kind, just no
inserted session data.  However, the zsessions table shows the sessions
being created, so that table is working ok.  I mangled the SQL syntax for
sqlSetValue, *then* I got a pg. error, so sqlSetValue *is* running, yes?
I installed Logger and logged the values from sqlSetValue to the zope log.
I cut and pasted those values from the log into the test query screen for
sqlSetValues and when I submit the query it inserts just fine.  At that
point I can see the manually inserted values from session_test.dtml, so
sqlGetValues is working.  But if I try to insert values with session_test,
they show up in the very next screen, but are gone thereafter and of
course they do not show up in the database.  I'm really at quite a loss here.

I made sure to give SQLSession its very own ZPyGresQLDA connection.
After beating on that unsuccessfully for awhile, I installed ZPoPyDA,
and set SQLSession to use that, which of course didn't change anything.

Here's the version particulars:

Zope version: Zope 2.1.6 (source release, python 1.5.2, linux2) 
Python version: 1.5.2 (#1, Sep 17 1999, 20:15:36) [GCC egcs-2.91.66 19990314/Linux (egcs- 
System Platform: linux-i386 

ZPyGreSQLDA 0.3
ZPoPyDA 0.5.1
PoPy 1.3.2 beta
SQLSession 0.3.0
PostgreSQL 7.0.2

Other installed products (if it matters...):

ZPyGreSQLDA Fortune Calendar Logger Photo ZPatterns Confera LoginManager
SQLSession ZPoPyDA WorldPilot iTrack

Mild rant:

I've got a big, scary, and now behind schedule database-enabled website
to build for a client.  Most everything I've read, and even my earlier,
simpler experiences with Zope have been fantastic.  I've been going
on to my client about how great Zope is, rapid deployment, etc, blah.
So I committed, but after fighting with LM (It took weeks to get it
working once and I have not been able to duplicate that feat since), a
failed upgrade to Zope 2.2 (LM wouldn't work there yet(?), doh!), and now
SQLSession...  I'm *not* having an overall good feeling about all this.
I'm even starting to get thoughts of retreating to Perl or learning PHP3
and never looking back.  But I really want to get over what's probably
mostly newbie learning curve & lack of docs and make this work in Zope.
Please help!!!

-cw-

-- 
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            Charlie Wilkinson - cwilkins@boinklabs.com - N3HAZ
Parental Unit, UNIX Admin, Homebrewer, Cat Lover, Spam Fighter, HAM, SWLer...
    Visit the Radio For Peace International Website: http://www.rfpi.org/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
            CLOBBER INTERNET SPAM:  See!! <http://spam.abuse.net/>        
                                   Join!! <http://www.cauce.org/>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
QOTD:
Failure is not an option. It's bundled with your software.