Of course... after two complete days and nights of trying to get this to work, and finally throwing up my hands in despair and asking for help here on the list -- I made one last attempt while awaiting a response... and behold! Viola! I finally got everything to work correctly! ( and there was much rejoicing ) I just ended up compeletely erradicating every last vestige of Python, Zope, ZMySQLDA and MySQLdb on my system - and recompiling everything from scratch, carefully and methodically. Anyhow - problem solved, sorry for the rant. Beers! Corey And upon Sunday of December 03, the illustrious corey@axcelerant.com spake thusly...
Greetings!
I'm at the point where I could really use some help...
Specifically, I cannot for the life of me get a ZMySQL instance to work - on two different machines, using about 4 different combinations of Zope, Python, ZMySQLDA and MySQLdb versions... What occurs ( depending on which particular combo I try ) is one of three things, either:
#1 - the loading of the ZMySQLDA Product fails entirely, causing Zope itself to die upon startup, or
#2 - an error about invalid syntax or somesuch occurs, although the sql query is perfectly correct. ( sorry, I can't remember the exact error msg, although it occured frequently through my attempts - and I'm not going to try and reproduce it )
or
#3 - the following error is recieved: 'There was no data matching this Z MySQL Database Connection (connected) query.' Even though I *know* that the simple query I'm testing with *definately* returns data.
I was finally able to get past errors #1 and #2, with #3 being the closest I've been able to get everything working - I can create and load the ZMysqlDA Product just fine, I can test the query, without error #2, but for some reason no matter what - the response is *allways* that there was no data matching my query! I've attempted the same query using the same user on the same database with the same table via the mysql client just fine... why is Zope failing me?
Any suggestions? Anyone else run accross this problem? I'm at wits end here. I've been through ever possible logical solution I can think of to no avail. Is there some lower level interface or debug or log that I can inspect for further details?
Current config:
Zope version: Zope 2.2.4 (source release, python 1.5.2, linux2) Python version: 2.0 (#1, Oct 25 2000, 19:37:52) [GCC egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)] System Platform: linux2 ZMySQLDA: 1.2.0 MySQLdb: 0.1.2
Beers,
Corey
_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )