Gaute Amundsen schrieb:
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 >")
Thats a very bad idea. Better make zsql methods for every query you want to issue instead of rebuilding your own (obviously not working) templating for SQL. Quoting is done automatically when you use <dtml-sqlvar ...>
(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
_______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )