Phil Harris wrote:
What version of MySQL are you using and also what version of the Zope Adapter?
MySQL Server version: 3.23.21-beta-debug
Was using: ZMySQLDA-1.1.3-nonbin, as per your How-To. Just got: ZMySQLDA-1-1-4 (most recent stable). Same problems. Non-results SQL, 'use tmm', works, but 'show tables' crashes Python/Zope. I installed contents of ZMySQLDA-1-1-4 in: <zope-dir>/lib/python/Products/ZMySQLDA Thanks again, William BC Crandall Wiesbaden, Germany wcra@beest.midat.de
----- Original Message ----- From: "William BC Crandall" <wcra@beest.midat.de> To: <phil.harris@zope.co.uk> Cc: <zope@zope.org> Sent: Wednesday, August 09, 2000 12:56 PM Subject: [Zope] ZMySQLDA on Win32 - connect then crash
Dear Phil:
Thanks for your "How-To: ZMySQLDA on Win32 (2000/02/14)". And for your inquiry about troubles with the set up.
Following the steps you outlined, I was able to establish a (very) minimal working connection. That is to say, I can use Zope's 'Z MySQL Database Connection' 'Test' page with the SQL command 'use tmm' (tmm is the name of my database), with success:
This statement returned no results. -----------------------------------
SQL Used:
use tmm
But, when I 'test' any more complex command ('show tables', or 'select * from city' -- all without the surrounding quotes ' ), Zope crashes.
Specifically, I get a Window's message:
'Python: This program has performed an illegal operation and will be shut down.'
Details: PYTHON executed an invalid instruction in module <unknown> at 0000:01670d74. Registers: EAX=017c81b1 CS=015f EIP=01670d74 EFLGS=00010286 EBX=00000001 SS=0167 ESP=01c8fa90 EBP=01670d70 ECX=1e10f91f DS=0167 ESI=ffffffff FS=1307 EDX=00000000 ES=0167 EDI=012d2a50 GS=0000 Bytes at CS:EIP: f0 a2 2d 01 30 19 46 01 3d 43 3a 5c 02 00 00 00 Stack dump: 00764580 1e16f958 00764580 00000000 00764580 1e10f831 00b4bb40 00764580 00000000 00b4bb40 00f169f4 1e10e74c 00b4bb40 00764580 00000000 00b04400
I am running MySQL with the --console option, which recorded:
C:\mysql\bin\mysqld.exe: ready for connections 000809 12:53:27 Aborted connection 3 to db: 'tmm' user: 'root' host: `localhost' (Unknown error) 000809 12:53:27 Aborted connection 2 to db: 'tmm' user: 'root' host: `localhost' (Unknown error)
My 'Z MySQL Database Connection' page shows:
The Media Machine (connected) Status Id tmm_db Title The Media Machine Database Connection String tmm root
The database connection is open.
My environment: Windows 98 4.10.98 MySQL Server version: 3.23.21-beta-debug Zope version: Zope 2.2.0 (binary release, python 1.5.2, win32-x86) Python version: 1.5.2 (#0, Jul 30 1999, 09:52:18) [MSC 32 bit (Intel)] Computer: Acer Extensa 710TE, PentiumII, 160MB RAM
Thanks in andvance for any thoughts.
William BC Crandall Wiesbaden, Germany wcra@beest.midat.de
_______________________________________________ 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 )