[Zope] Zope -> MySQL Weirdness

[Tom Rectenwald]

> 
> From: Cliff Ford <Cliff.Ford at ed.ac.uk>
> Date: 2004/11/27 Sat AM 09:50:03 GMT
> To: Tom Rectenwald <seldan at verizon.net>
> CC: zope at zope.org
> Subject: Re: [Zope] Zope -> MySQL Weirdness
> 
> What happens when you run a Select query from the Test tab of the 
> Database Connection object (select * from <tablename>)? That sometimes 
> gives a more explicit error message from the database.
> 
> Cliff
> 
> Tom Rectenwald wrote:
> > Hello,
> > 
> > I am just starting to learn Zope and am having trouble getting it
> > to communicate with mySQL.
> > 
> > Here is what I have done thus far:
> > 
> > - Built and compiled MySQLdb and ZMySQLDA.
> > - Installed the 'Z MySQL Database Connection.
> > - Entered in the 'Database Connection String' (DB, user, password)
> > 
> > Once done, I went to the 'Test' tab and here is where things get
> > weird:
> > 
> > - I can run an INSERT statement with no trouble and verify that
> >   the DB is updated.
> > - However, whenever I run any sort of SELECT query I get the
> >   following error:
> > 
> > Error Type: TypeError
> > Error Value: object does not support item assignment
> > 
> > 
> > I also get this error when trying to put a SELECT in Z SQL Method.
> > I'm very new at this stuff and come from a PHP/Perl/mySQL/postgreSQL
> > background, so any help at all is appreciated.  If desired, I can
> > send the error_log output as well.  I just don't get it. :-(
> > 
> > Thank you for an help, suggestions, advice.  I've googled this to
> > bits to no avail.  I am really enjoying Zope so far; just wish I understood it better.
> > 
> > Regards,
> > Tom
> > 
> > _______________________________________________
> > Zope maillist  -  Zope at zope.org
> > http://mail.zope.org/mailman/listinfo/zope
> > **   No cross posts or HTML encoding!  **
> > (Related lists - 
> >  http://mail.zope.org/mailman/listinfo/zope-announce
> >  http://mail.zope.org/mailman/listinfo/zope-dev )
> 

Hello,

My apologies for the late response.  I was getting the same error when running from the test tab.  As it turns out, I was running Zope 2.8.01a.  Perhaps it was just a compatibility issue.  I removed that and compiled Zope 2.7.3 and everything is working wonderfully now.

Thanks all for the help.
Tom