I haven't been following this thread, so I apologize in advance for any redundancy. Several weeks ago I had an existing mysql fail as you describe after I upgraded mysqldb in /usr/lib/python. I fixed it by moving ZMySQLDA/MySQLdb-0.1.2/_mysqlmodule.so up one level as described in README.txt. Bill. On Thu, 11 Jan 2001 paul_s_johnson@urscorp.com wrote:
From Zope management database connection Test tab, on valid SELECT queries it tells me that there was no data matching my query. On invalid SELECT queries (ones on nonexistent tables or columns) Zope raises the correct error originating from MySQL, such as "Error Value: (1146, "Table 'somedatabase.sometable' doesn't exist")". The trial queries I am testing through Zope all work from the MySQL command line so I know they do in fact return data. It appears that error messages are making it back to Zope from MySQL but real query results are not.