Re: [Zope] Problem on running the ZOPE by using ZmySQLDA
Angietel writes: > Finally my ZOPE is connected to MySQL succesfully, i can insert, delete = > the record,but i can not search and view my record in ZOPE. When i go to = > MySQL it can shows all my database records after my modification in = > ZOPE. Every time when i want to search or view my records it will promt = > out the illegal operation message in ZOPE and my pyhon will be exactly = > look like this:- > > > 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 = Your Zope died. Must be something wrong in an C extension module, probably the MySQL connector. I would try to get a core ("limit", "ulimit" commands) and then look with a debugger into it. Dieter ___ 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 )
[Zope] *Problem on running the ZOPE by using ZmySQLDA
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 1316:34:31 2000 Hostname: ANGIE Port:8080--2000-12-13T08:34:31 INFO(0) ZServer FTP server started at Wed Dec 1316:34:31 2000 Authorizer:None Hostname: angie Port: 8021--2000-12-13T08:34:31 INFO(0) ZServer PCGI Server started at Wed Dec 1316:34:31 2000 Inet socket port: 8090-- 2000-12-13T08:34:31 INFO(0) ZServer Monitor Server (V1.8) started on port8099C:\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, clickthe "Test" tab and then enter the SQL statement. Then click the "SubmitQuery" 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
RE: [Zope] Problem on running the ZOPE by using ZmySQLDA
Hi Angie. First off, I think there are some users in the list that are unable to read HTML formatted email. I've seen a lot of requests for folks to send only plain text messages to the list. Well, I don't run Zope on a Windows machine, so maybe I'm wrong here, but the output you've shown below looks normal to me. It doesn't look like an error. Is there any error message that's displayed in your browser? If so, can you recreate it and send it to the list? Also, can you include the SQL statement that is causing the problem? Have you tried making a ZSQL Method that issues a really simple query, like: SELECT * FROM InsertYourTableNameHere You can also 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. It should return all the records in the table you specified. If it doesn't, I would hope it simply returns a traceback and not crash Zope. Hope that helps. Eric. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Angietel Sent: Wednesday, December 13, 2000 12:42 AM To: [EMAIL PROTECTED] Subject: [Zope] Problem on running the ZOPE by using ZmySQLDA Finally my ZOPE is connected to MySQL succesfully, i can insert, delete the record,but i can not search and view my record in ZOPE. When i go to MySQL it can shows all my database records after my modification in ZOPE. Every time when i want to search or view my records it will promt out the illegal operation message in ZOPE and my pyhon will be exactly look like this:- iles\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> P/s let me know me that whether this is regard to my MySQL or ZOPE or Python, but i have tried to reinstall all of them, and the situation is still remain the same. Thanks for your concern. ___ 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 )
[Zope] Problem on running the ZOPE by using ZmySQLDA
Finally my ZOPE is connected to MySQL succesfully, i can insert, delete the record,but i can not search and view my record in ZOPE. When i go to MySQL it can shows all my database records after my modification in ZOPE. Every time when i want to search or view my records it will promt out the illegal operation message in ZOPE and my pyhon will be exactly look like this:- iles\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 2000 Authorizer:None Hostname: angie Port: 8021--2000-12-13T08:34:31 INFO(0) ZServer PCGI Server started at Wed Dec 13 16:34:31 2000 Inet socket port: 8090--2000-12-13T08:34:31 INFO(0) ZServer Monitor Server (V1.8) started on port 8099 C:\Program Files\WebSite> P/s let me know me that whether this is regard to my MySQL or ZOPE or Python, but i have tried to reinstall all of them, and the situation is still remain the same. Thanks for your concern.