Stephen, 1) Go to http://www.zope.org/Members/adustman/Products/ZMySQLDA and download load version 2.0.8 2) Go to http://www.zope.org/Members/adustman/Products/MySQLdb and download version 0.9.0 3) You have to compile the _mysql.c with MSVC or Bloodshed's C++ compiler (free). The instructions for doing this are in readme. Examine the setup.py and you will find that it will look for the mysql libs in the default installation path. You may have to change it to the correct location on your harddrive. Good Luck, Joseph -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Stephen Fung Sent: Tuesday, October 01, 2002 8:02 PM To: zope@zope.org Subject: RE: [Zope] MySQL Database not working well with Zope I've tried to install ZMySQLDA before, but I've gotten stuck every time. I've installed the newest version of Python on my computer, and have tried to follow the given directions, but, as I run windowsXP, there isn't a whole lot of instructions for windows users. I can't the the ZMySQLDA to work at all, and I get the same "No Module Named _myql" error whenever I start Zope. Can somebody please guide me through the install process in WindowsXP? --- Kevin Carlson <khcarlso@bellsouth.net> wrote:
This may not address your specific problem, but it may help solve it (and potentially others). I had many problems when using MySQL with ODBC and Zope. I switched to MySQL Python libraries and ZMySQLDA and have had no trouble at all. Get ZMySQLDA from
http://www.zope.org/Members/adustman/Products/ZMySQLDA
and then download the MySQLdb python library. This might take care of your problem.
Kevin
-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Stephen Fung Sent: Tuesday, October 01, 2002 12:56 PM To: zope@zope.org Subject: [Zope] MySQL Database not working well with Zope
I'm new to setting up my own Zope and MySQL Servers, so I'm not sure if I just didn't configure it correctly or what, but I'm now getting errors when I try to connect to my MySQL server. I'm currently using Zope 2.5.1 and MySQL Max 3.23.51 with the myodbc-2.50.39-nt package, and connect to the MySQL server using the Z ODBC Database Adapter Product. The root of my Zope installation is J:\Zope_2-5-1\Ricepail_Com. It seems to be set up correctly, as it was working fine at first. When I entered some data into a table I created, it worked fine with zope. However, when I tried to add longer entries into a cell of type "text" (smaller, 2-sentence entries worked fine) the database stopped working, and I'd get the following error page:
Zope Error Zope has encountered an error while publishing this resource.
Error Type: sql.error Error Value: None
----------------------------------------------------------------------------
----
Troubleshooting Suggestions
The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page.
If the error persists please contact the site maintainer. Thank you for your patience.
Traceback (innermost last): File
J:\Zope_2-5-1\Ricepail_Com\lib\python\ZPublisher\Publish.py,
line 150, in publish_module File
J:\Zope_2-5-1\Ricepail_Com\lib\python\ZPublisher\Publish.py,
line 114, in publish File J:\ZOPE_2~1\RICEPA~1\lib\python\Zope\__init__.py, line 159, in zpublisher_exception_hook (Object: rightbarpages) File
J:\Zope_2-5-1\Ricepail_Com\lib\python\ZPublisher\Publish.py,
line 98, in publish File
J:\ZOPE_2~1\RICEPA~1\lib\python\ZPublisher\mapply.py,
line 88, in mapply (Object: index_html) File
J:\Zope_2-5-1\Ricepail_Com\lib\python\ZPublisher\Publish.py,
line 39, in call_object (Object: index_html) File J:\ZOPE_2~1\RICEPA~1\lib\python\OFS\DTMLDocument.py, line 127, in __call__ (Object: index_html) File
J:\ZOPE_2~1\RICEPA~1\lib\python\DocumentTemplate\DT_String.py,
line 473, in __call__ (Object: index_html) File
J:\ZOPE_2~1\RICEPA~1\lib\python\DocumentTemplate\DT_In.py,
line 437, in renderwb (Object: sqlGetEverything) File
J:\ZOPE_2~1\RICEPA~1\lib\python\Shared\DC\ZRDB\DA.py,
line 421, in __call__ (Object: sqlGetEverything) File
J:\Zope_2-5-1\Ricepail_Com\lib\python\Products\ZODBCDA\db.py,
line 232, in query sql.error: (see above)
After receiving the above message, if I try to access another entry from the database, I receive the following message:
Zope Error Zope has encountered an error while publishing this resource.
Error Type: sql.error Error Value: ('24000', 0, '[Microsoft][ODBC Driver Manager] Invalid cursor state')
----------------------------------------------------------------------------
----
Troubleshooting Suggestions
The URL may be incorrect. The parameters passed to this resource may be incorrect. A resource that this resource relies on may be encountering an error. For more detailed information about the error, please refer to the HTML source for this page.
If the error persists please contact the site maintainer. Thank you for your patience.
Traceback (innermost last): File
J:\Zope_2-5-1\Ricepail_Com\lib\python\ZPublisher\Publish.py,
line 150, in publish_module File
J:\Zope_2-5-1\Ricepail_Com\lib\python\ZPublisher\Publish.py,
line 114, in publish File J:\ZOPE_2~1\RICEPA~1\lib\python\Zope\__init__.py, line 159, in zpublisher_exception_hook (Object: rightbarpages) File
J:\Zope_2-5-1\Ricepail_Com\lib\python\ZPublisher\Publish.py,
line 98, in publish File
J:\ZOPE_2~1\RICEPA~1\lib\python\ZPublisher\mapply.py,
line 88, in mapply (Object: index_html) File
J:\Zope_2-5-1\Ricepail_Com\lib\python\ZPublisher\Publish.py,
line 39, in call_object (Object: index_html) File J:\ZOPE_2~1\RICEPA~1\lib\python\OFS\DTMLDocument.py, line 127, in __call__ (Object: index_html) File
J:\ZOPE_2~1\RICEPA~1\lib\python\DocumentTemplate\DT_String.py,
line 473, in __call__ (Object: index_html) File
J:\ZOPE_2~1\RICEPA~1\lib\python\DocumentTemplate\DT_In.py,
line 617, in renderwob (Object: sqlGetInfo) File
J:\ZOPE_2~1\RICEPA~1\lib\python\Shared\DC\ZRDB\DA.py,
line 421, in __call__ (Object: sqlGetInfo) File
J:\Zope_2-5-1\Ricepail_Com\lib\python\Products\ZODBCDA\db.py,
line 198, in query sql.error: (see above)
I continue to get the above message nomatter what I do, until I restart the Zope Server.
=== message truncated === __________________________________________________ Do you Yahoo!? New DSL Internet Access from SBC & Yahoo! http://sbc.yahoo.com _______________________________________________ Zope maillist - Zope@zope.org 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 )