Hi,

I'm still having no luck getting the aggregate functions to work on Solaris. Can someone help me figure out how to debug this?

In Connection.py in the manage_test method we find:

        report=DocumentTemplate.HTML(
            '<html><body bgcolor="#ffffff" link="#000099" vlink="#555555">\n'
            '<dtml-var name="manage_tabs">\n<hr>\n%s\n\n'
            '<hr><h4>SQL Used:</strong><br>\n<pre>\n%s\n</pre>\n<hr>\n'
            '</body></html>'
            % (r, query))

        report=apply(report,(self,REQUEST),{self.id:result})

If I run "select * from users," there is no problem. When I run "select count(*) from users" the server drops the connection. I've tried logging before and after 'apply' and found that that's where it dies. The DA is running the query and returning the result , but any count/sum/average functions cause it to die when it's being rendered. How can I print the contents of {self.id:result} to compare * vs. count(*)?

Please help!!

Solaris 2.7
Zope 2.3.0
Python 1.5
MySQL 2.22
MySQL-python-0.3.2
ZMySQLDA-2.0.4

Dwayne Morrison
morrison@qsilver.net