[Zope] *Problem on running the ZOPE by using ZmySQLDA

Angietel angietel@hotmail.com
Thu, 14 Dec 2000 09:41:52 +0800


This is a multi-part message in MIME format.

------=_NextPart_000_0019_01C065B2.165C36A0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Files\WebSite\z2.py" -D
------
2000-12-13T08:34:28 PROBLEM(100) ZServer Computing default hostname
------
2000-12-13T08:34:31 INFO(0) ZServer Medusa (V1.16.4.2) started at Wed =
Dec 13
16:
34:31 2000
        Hostname: ANGIE
        Port:8080

------
2000-12-13T08:34:31 INFO(0) ZServer FTP server started at Wed Dec 13
16:34:31 20
00
        Authorizer:None
        Hostname: angie
        Port: 8021
------
2000-12-13T08:34:31 INFO(0) ZServer PCGI Server started at Wed Dec 13
16:34:31 2
000
        Inet socket port: 8090
------
2000-12-13T08:34:31 INFO(0) ZServer Monitor Server (V1.8) started on =
port
8099


C:\Program Files\WebSite>


The word that i have been highlighted is the error msg that i want to =
mentioned. In the SQL statement it does'nt show any error msg. And what =
you have been suggested to me:-

*//making a ZSQL Method that issues a really simple query, like:
SELECT * FROM InsertYourTableNameHere

 try this simple test from your "Z MySQL Database Connection"
object.  Just browse to that object in the Zope management interface, =
click
the "Test" tab and then enter the SQL statement.  Then click the "Submit
Query" button to test it.

When i clicked the "Submit Query" button the illegal operation error msg =
will come out.

In MySQL is no sense of the error msg.
This is a bit tricky problem that i dont understand.


TQ=20

------=_NextPart_000_0019_01C065B2.165C36A0
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>Files\WebSite\z2.py"=20
-D<BR>------<BR>2000-12-13T08:34:28 PROBLEM(100) ZServer Computing =
default=20
hostname<BR>------<BR>2000-12-13T08:34:31 INFO(0) ZServer Medusa =
(V1.16.4.2)=20
started at Wed Dec 13<BR>16:<BR>34:31=20
2000<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hostname:=20
ANGIE<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Port:8080<BR><BR>------<BR>2000-12-13T08:34:31 INFO(0) ZServer FTP =
server=20
started at Wed Dec 13<BR>16:34:31=20
20<BR>00<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Authorizer:None<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Hostname:=20
angie<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Port:=20
8021<BR>------<BR>2000-12-13T08:34:31 INFO(0) ZServer PCGI Server =
started at Wed=20
Dec 13<BR>16:34:31 =
2<BR>000<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Inet=20
socket port: 8090<BR>------</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>2000-12-13T08:34:31 INFO(0) ZServer =
Monitor Server=20
(V1.8) started on port<BR>8099<BR><FONT face=3DArial size=3D2><SPAN=20
style=3D"BACKGROUND: gray; mso-highlight: =
gray"></SPAN></FONT></FONT></DIV><BR></FONT><FONT=20
face=3DArial size=3D2><SPAN style=3D"BACKGROUND: gray; mso-highlight: =
gray">C:\Program=20
Files\WebSite&gt;</SPAN></FONT></DIV>
<DIV><SPAN style=3D"BACKGROUND: gray; mso-highlight: =
gray"></SPAN>&nbsp;</DIV>
<DIV><SPAN style=3D"BACKGROUND: gray; mso-highlight: =
gray"></SPAN>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>The word that i have been highlighted =
is the error=20
msg that i want to mentioned. In the SQL statement it does'nt show any =
error=20
msg. And what you have been suggested to me:-</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>*//making a ZSQL Method that issues a =
really simple=20
query, like:<BR>SELECT * FROM InsertYourTableNameHere<BR><BR>&nbsp;try =
this=20
simple test from your "Z MySQL Database Connection"<BR>object.&nbsp; =
Just browse=20
to that object in the Zope management interface, click<BR>the "Test" tab =
and=20
then enter the SQL statement.&nbsp; Then click the "Submit<BR>Query" =
button to=20
test it.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>When i clicked the "Submit Query" =
button the=20
illegal operation error msg will come out.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>In MySQL is no sense of the error =
msg.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>This is a bit tricky problem that i=20
dont&nbsp;understand.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>TQ </FONT></DIV></BODY></HTML>

------=_NextPart_000_0019_01C065B2.165C36A0--