[Zope] Problem on running the ZOPE with ZmySQLDA

Angietel angietel@hotmail.com
Tue, 19 Dec 2000 09:57:20 +0800


This is a multi-part message in MIME format.

------=_NextPart_000_0005_01C069A2.13EEA800
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

The following is the illegal operation msg details:-

PYTHON executed an invalid instruction in
module <unknown> at 0000:01560f54.

Registers:

EAX=3D00b3ceb1 CS=3D016f EIP=3D01560f54 EFLGS=3D00010286

EBX=3D00000001 SS=3D0177 ESP=3D01dbf5dc EBP=3D01560f50

ECX=3D1e10f91f DS=3D0177 ESI=3Dffffffff FS=3D57df

EDX=3D00000000 ES=3D0177 EDI=3D011c2a50 GS=3D0000

Bytes at CS:EIP:

f0 a2 1c 01 50 14 35 01 44 20 20 20 02 00 00 00=20

Stack dump:

00763130 1e16f958 00763130 00000000 00763130 1e10f831 01713570 00763130 =
00000000 01713570 00b4497c 1e10e74c 01713570 00763130 00000000 00b0d970

and this is my ZSQL method:-

1.For search function:-

select *
from customer
where
<dtml-sqltest custid type=3Dstring>
OR
<dtml-sqltest custname type=3Dstring>


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,=20
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.


------=_NextPart_000_0005_01C069A2.13EEA800
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>The following is the illegal operation =
msg=20
details:-</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>PYTHON executed an invalid instruction=20
in<?xml:namespace prefix =3D o ns =3D =
"urn:schemas-microsoft-com:office:office"=20
/><o:p></o:p></DIV>
<P class=3DMsoNormal>module &lt;unknown&gt; at =
0000:01560f54.<o:p></o:p></P>
<P class=3DMsoNormal>Registers:<o:p></o:p></P>
<P class=3DMsoNormal>EAX=3D00b3ceb1 CS=3D016f EIP=3D01560f54=20
EFLGS=3D00010286<o:p></o:p></P>
<P class=3DMsoNormal>EBX=3D00000001 SS=3D0177 ESP=3D01dbf5dc =
EBP=3D01560f50<o:p></o:p></P>
<P class=3DMsoNormal>ECX=3D1e10f91f DS=3D0177 ESI=3Dffffffff =
FS=3D57df<o:p></o:p></P>
<P class=3DMsoNormal>EDX=3D00000000 ES=3D0177 EDI=3D011c2a50 =
GS=3D0000<o:p></o:p></P>
<P class=3DMsoNormal>Bytes at CS:EIP:<o:p></o:p></P>
<P class=3DMsoNormal>f0 a2 1c 01 50 14 35 01 44 20 20 20 02 00 00 00=20
<o:p></o:p></P>
<P class=3DMsoNormal>Stack dump:<o:p></o:p></P>
<P class=3DMsoNormal>00763130 1e16f958 00763130 00000000 00763130 =
1e10f831=20
01713570 00763130 00000000 01713570 00b4497c 1e10e74c 01713570 00763130 =
00000000=20
00b0d970</P>
<P class=3DMsoNormal>and this is my ZSQL method:-</P>
<P class=3DMsoNormal>1.For search function:-</P>
<P class=3DMsoNormal>select *<BR>from =
customer<BR>where<BR>&lt;dtml-sqltest custid=20
type=3Dstring&gt;<BR>OR<BR>&lt;dtml-sqltest custname =
type=3Dstring&gt;<BR></P>
<P class=3DMsoNormal>2.For create table customer:-</P>
<P class=3DMsoNormal>CREATE TABLE customer<BR>(custid VARCHAR(10)NOT=20
NULL,<BR>custname VARCHAR(15),<BR>custregno VARCHAR(10),<BR>custactdate=20
DATE,<BR>custadd1 VARCHAR(30),<BR>custadd2 VARCHAR(30),<BR>custcity=20
VARCHAR(20),<BR>custstate VARCHAR(15),<BR>custcountry=20
VARCHAR(30),<BR>custpostcode INTEGER,<BR>custtel INTEGER,<BR>custfax=20
INTEGER,<BR>custemail VARCHAR(30),<BR>custurl =
VARCHAR(30),<BR>custremarks=20
VARCHAR(30),<BR>shippingadd1 VARCHAR(30),<BR>shippingadd2=20
VARCHAR(30),<BR>shippingcity VARCHAR(20),<BR>shippingstate=20
VARCHAR(15),<BR>shippingcountry VARCHAR(30),<BR>shippingpostcode=20
INTEGER,<BR>shippingtel INTEGER,<BR>shippingfax =
INTEGER,<BR>shippingemail=20
VARCHAR(30),<BR>custstatus VARCHAR(10),<BR>custcontname=20
VARCHAR(15),<BR>custcontdesg VARCHAR(20),<BR>custconttel =
INTEGER,<BR>custcontext=20
INTEGER,<BR>custconteml VARCHAR(30),<BR>custcontmob =
INTEGER,<BR>custcontfax=20
INTEGER,<BR>custcredlimit FLOAT,<BR>custcredterm =
INTEGER,<BR>custinterest=20
FLOAT,<BR>custopbal FLOAT,<BR>custbaldue FLOAT,<BR>custsales=20
VARCHAR(15),<BR>custpricelev INTEGER, <BR>PRIMARY =
KEY(custid)<BR>)<BR></P>
<P class=3DMsoNormal>3.For view all records:-</P>
<P class=3DMsoNormal>select *<BR>from customer order by custname</P>
<P class=3DMsoNormal>So far, i tried to install python1.6 and 1.5.2 but =
there no=20
changes at all. and i also reinstall my ZOPE because you said my ZOPE is =
died.=20
Please tell me what should i do?Because i have spend a long time in this =

problem.</P></FONT></BODY></HTML>

------=_NextPart_000_0005_01C069A2.13EEA800--