[Zope-DB] Mysql Win32 Help

[Aaron Fosdick]

At the minimum, you need the win32 port of msyqldb 1.0 - at 
http://sourceforge.net/projects/mysql-python/  Also, since you're 
running 4.1, it probably won't work as it is linked against 4.0.7. 
You'll need to downgrade to MySQL 4.0.x before using that version.

If you gotta run 4.1:
I recently sent Andy (the maintainer) a version linked to 4.1 but he 
hasn't posted it on Sourceforge yet. You can get it from me at: 
http://www.hypervision.com/files/mysql-python-1.1.7.win32-py2.3.4.zip
Note that while it works fine on my PC, consider it as 
testing/bleeding-edge. I have no idea what bugs it might contain....

Make sure you have zmysqlda 2.08 - also at sourceforge.

Regards,

--Aaron

Loomis, Todd, CTR, DMSO wrote:

>MySQLdb 0.9.1
>MySQL 4.1
>
>-----Original Message-----
>From: Aaron Fosdick [mailto:aaron at hypervision.com] 
>Sent: Wednesday, December 15, 2004 12:54 PM
>To: Loomis, Todd, CTR, DMSO; zope-db mailling list
>Subject: Re: [Zope-DB] Mysql Win32 Help
>
>What versions of mysqldb and MySQL are you running?
>
>--Aaron
>
>Loomis, Todd, CTR, DMSO wrote:
>
>  
>
>>I'm in the process of moving from a linux box to a win32 box and have 
>>everything up and running nicely. However I'm getting the following 
>>error when access a table that has a mysql timestamp, any suggestions:
>>
>><!--
>>
>>Traceback (innermost last):
>>
>>File E:\DMSO-www\lib\python\Products\Hotfix_2002-04-15\__init__.py, 
>>line 51, in publish_module
>>
>>File E:\DMSO-www\lib\python\ZPublisher\Publish.py, line 187, in
>>    
>>
>publish
>  
>
>>File E:\DMSO-www\lib\python\Zope\__init__.py, line 226, in 
>>zpublisher_exception_hook
>>
>>File E:\DMSO-www\lib\python\ZPublisher\Publish.py, line 171, in
>>    
>>
>publish
>  
>
>>File E:\DMSO-www\lib\python\ZPublisher\mapply.py, line 160, in mapply
>>
>>(Object: index)
>>
>>File E:\DMSO-www\lib\python\ZPublisher\Publish.py, line 112, in 
>>call_object
>>
>>(Object: index)
>>
>>File E:\DMSO-www\lib\python\OFS\DTMLMethod.py, line 195, in __call__
>>
>>(Object: index)
>>
>>File E:\DMSO-www\lib\python\DocumentTemplate\DT_String.py, line 546, 
>>in __call__
>>
>>(Object: index)
>>
>>File E:\DMSO-www\lib\python\DocumentTemplate\DT_In.py, line 691, in 
>>renderwob
>>
>>(Object: get_nominations)
>>
>>File E:\DMSO-www\lib\python\Shared\DC\ZRDB\DA.py, line 493, in
>>    
>>
>__call__
>  
>
>>(Object: get_nominations)
>>
>>File E:\DMSO-www\lib\python\Products\ZMySQLDA\db.py, line 293, in
>>    
>>
>query
>  
>
>>File E:\DMSO-www\lib\python\MySQLdb\times.py, line 105, in 
>>mysql_timestamp_converter
>>
>>ValueError: invalid literal for int(): 0-
>>
>>-->
>>
>>____________________________________
>>
>>Todd Loomis
>>
>>Web Developer
>>
>>Defense Modeling & Simulation Office
>>
>>1901 N. Beauregard Street, Suite 500
>>
>>Alexandria, VA 22311
>>
>>Office: (703) 824-3407
>>
>>Fax: (703) 379-3778
>>
>>-----------------------------------------------------------------------
>>    
>>
>-
>  
>
>>_______________________________________________
>>Zope-DB mailing list
>>Zope-DB at zope.org
>>http://mail.zope.org/mailman/listinfo/zope-db
>> 
>>
>>    
>>
>
>
>
>
>  
>