Hi,
This is the same problem as I encountered when I installed the DLL that came
with the mySQL installation, instead of downloading the one which is
available as download via the HOWTO via this link:
http://www.zope.org/Members/philh/mysql/libmySQL.dll
I downloaded and installed all the files mentioned in this HOW-TO
http://www.zope.org/Members/philh/mysql ) instead of building my own or
using other. I use Zope 2.2.2 and Python 1.5.2, latest version of mySQL
3.23.28-gamma-debug
Best regards
Petter Enholm
Snapper
- Original Message -
From: Angietel
To: [EMAIL PROTECTED]
Sent: Tuesday, December 19, 2000 2:57 AM
Subject: [Zope] Problem on running the ZOPE with ZmySQLDA
The following is the illegal operation msg details:-
PYTHON executed an invalid instruction in
module at :01560f54.
Registers:
EAX=00b3ceb1 CS=016f EIP=01560f54 EFLGS=00010286
EBX=0001 SS=0177 ESP=01dbf5dc EBP=01560f50
ECX=1e10f91f DS=0177 ESI= FS=57df
EDX= ES=0177 EDI=011c2a50 GS=
Bytes at CS:EIP:
f0 a2 1c 01 50 14 35 01 44 20 20 20 02 00 00 00
Stack dump:
00763130 1e16f958 00763130 00763130 1e10f831 01713570 00763130
01713570 00b4497c 1e10e74c 01713570 00763130 00b0d970
and this is my ZSQL method:-
1.For search function:-
select *
from customer
where
OR
2.For create table customer:-
CREATE TABLE customer
(custid VARCHAR(10)NOT NULL,
custname VARCHAR(15),
custregno VARCHAR(10),
custactdate DATE,
custadd1 VARCHAR(30),
custadd2 VARCHAR(30),
custcity VARCHAR(20),
custstate VARCHAR(15),
custcountry VARCHAR(30),
custpostcode INTEGER,
custtel INTEGER,
custfax INTEGER,
custemail VARCHAR(30),
custurl VARCHAR(30),
custremarks VARCHAR(30),
shippingadd1 VARCHAR(30),
shippingadd2 VARCHAR(30),
shippingcity VARCHAR(20),
shippingstate VARCHAR(15),
shippingcountry VARCHAR(30),
shippingpostcode INTEGER,
shippingtel INTEGER,
shippingfax INTEGER,
shippingemail VARCHAR(30),
custstatus VARCHAR(10),
custcontname VARCHAR(15),
custcontdesg VARCHAR(20),
custconttel INTEGER,
custcontext INTEGER,
custconteml VARCHAR(30),
custcontmob INTEGER,
custcontfax INTEGER,
custcredlimit FLOAT,
custcredterm INTEGER,
custinterest FLOAT,
custopbal FLOAT,
custbaldue FLOAT,
custsales VARCHAR(15),
custpricelev INTEGER,
PRIMARY KEY(custid)
)
3.For view all records:-
select *
from customer order by custname
So far, i tried to install python1.6 and 1.5.2 but there no changes at all.
and i also reinstall my ZOPE because you said my ZOPE is died. Please tell
me what should i do?Because i have spend a long time in this problem.
___
Zope maillist - [EMAIL PROTECTED]
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 )
