[Zope] Bizarre ZMySQLDA problem...

[Phil Harris]

Tone,

What version of the MySQL DA are you using, there is a bug in one of them
that causes no data to be returned in specific circumstances, at least as
far as I can see.

I did at one time fix it, give me a few hours to see what I did and I'll
mail you back.

hth

Phil
----- Original Message -----
From: "Tony McDonald" <tony.mcdonald@ncl.ac.uk>
To: "Zope List" <zope@zope.org>
Sent: Tuesday, October 10, 2000 5:35 PM
Subject: [Zope] Bizarre ZMySQLDA problem...


> Hi all,
> I've just installed Zope-2.2.1 onto a clean Solaris 8 machine. I've
> built Python 1.5.2 from source and have MySQL 3.22 on the server.
>
> I've compiled up the ZMySQLDA product and put the MySQLModule.so in
> the correct place (ie one directory up from the src directory).
>
> I've restarted the Zope server, checked that ZMySQLDA is not broken
> and created a connection:
> test@localhost root
>
> I've created a ZSQL method that is essnetially 'select * from
> my_table' (and there *is* data in this table).
>
> The DA reports:
> There was no data matching this Z MySQL Database Connection (connected)
query.
>
> The same query produces a flood of data from the mysql monitor.
>
> I'm totally baffled here, and would really appreciate any advice...
>
> Tone
> ------
> Dr Tony McDonald,  FMCC, Networked Learning Environments Project
> http://nle.ncl.ac.uk/
> The Medical School, Newcastle University Tel: +44 191 222 5116
> A Zope list for UK HE/FE  http://www.fmcc.org.uk/mailman/listinfo/zope
>
> _______________________________________________
> 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 )
>