Hi Andy, and all !

I was developing a little webapp under Zope.
I was using the following setup:
Linux 2.4.x
Zope 2.3.0
MySQL 3.22.32
ZMySQLDA-2.0.6
MySQL-python-0.3.5

Everything went smooth that way. Small SQL queries and complex SQL queries, 
queries on empty tables and on full ones, they all went well.

Now I exported the website and dumped the tables structure.

I the impoerted the website and created the tables on a:
Sun Solaris (don't ask me what release) - Sparc processor.
Zope 2.3.0
MySQL 3.23.32 (or 3.23.33, I am not sure)
ZMySQLDA-2.0.6
MySQL-python-0.3.5

And this happened:
Querying MySQL like this:
--
show tables;
--
or
--
select * from data;
--
all went ok.
But running this statement on *empty* tables (mark you, just no data) left no 
python process running, they all died:
--
select a.a b.b c.c
from a b c
where a.fk_b = b.pk_b
and a.fk_c = c.pk_c
order by a.a;
--
It looks to me there is an uncaught "NULL pointer exception" deep down 
somewhere in the code....

Anyone hints or solutions ?
I am going to put some valid data into the database and try to run the 
queries again. I have not done this yet.

- Thanks in advance, Holger


-- 
-----------------------------------
catWorkX GmbH
Dipl.-Ing. Holger Lehmann
Stresemannstr. 364
22761 Hamburg
Tel: +49 (0700) catWorkX
Tel: +49 (40) 890 646-0
Fax: +49 (40) 890 646-66
mailto:[EMAIL PROTECTED]
http://www.catworkx.de
http://www.catbridge.de



_______________________________________________
Zope-Dev maillist  -  [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope-dev
**  No cross posts or HTML encoding!  **
(Related lists -
 http://lists.zope.org/mailman/listinfo/zope-announce
 http://lists.zope.org/mailman/listinfo/zope )

Reply via email to