From: Cliff Ford <Cliff.Ford@ed.ac.uk> Date: 2004/11/27 Sat AM 09:50:03 GMT To: Tom Rectenwald <seldan@verizon.net> CC: zope@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@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