[Zope] Zope -> MySQL Weirdness

[Chris McDonough]

Sounds like a 2.8 bug to me.  If you get a chance, do you think you
could file a bug report about this issue for 2.8 in the Zope collector? 
http://zope.org/Collectors/Zope

On Sat, 2004-11-27 at 22:39, Tom Rectenwald wrote:
> > 
> > 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
> 
> _______________________________________________
> 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 )
>