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
participants (1)
-
William BC Crandall