[Zope] Two mysql / timestamp related fixes

[Gaute Amundsen]

Hi.

Just had som troubles when I added timestamp columns to a table.
Commnets?


my setup:
Mysql: 4.1.20-log
 Zope Version: (Zope 2.7.5-1.fc3, python 2.3.4, linux2)


1 )
First I got a ValueError 'query' when using a very simple zsql method.
(consisting of only "<dtml-var sql >")
(I am not totally sure this is related to the timestamp  column)

I appled the fix to customDefaultReport.dtml  mentioned in 
http://mail.zope.org/pipermail/zope-db/2005-June/004219.html

<         <a 
href="&dtml-URL;?query_start=&dtml-previous-sequence-start-number;&query=<dtml-var 
query url_quote>">
---
>         <a 
href="&dtml-URL;&dtml-sequence-query;query_start=&dtml-previous-sequence-start-number;">
25d24
<          <a 
href="&dtml-URL;?query_start=&dtml-next-sequence-start-number;&query=<dtml-var 
query url_quote>">
26a26
>          <a 
href="&dtml-URL;&dtml-sequence-query;query_start=&dtml-next-sequence-start-number;">

This does not seem to be exactly the same fix as described in: 
http://www.zope.org/Collectors/Zope/1812

Should I have this problem in Zope 2.7.5-1.fc3?


2)

ValueError: invalid literal for int(): 0-  
When trying to do a "select *" 

this is definitely connected to the timestamp  column, because this change 
fixed it:

diff /usr/lib/zope/lib/python/Products/ZMySQLDA/db.py /usr/lib/zope/lib/python/Products/ZMySQLDA/db.py~
173d172
<     conv[FIELD_TYPE.TIMESTAMP] = DateTime_or_None

I have found no mention of this anywhere?
Have anyone else had this problem
Comments?

Regards

Gaute Amundsen