[Zope] MySQL

Piotr Kozbial piotrk@pc244.ibb.waw.pl
Fri, 26 Jan 2001 15:32:38 +0100


I have upgraded to MySQL 3.23.28 and both ZMySQLDA and ZMySQLTDA were
broken.Thus I have installed latest
ZMySQLDA-2.0.4 and MySQLdb 0.3.1.

Ufter upgrade it does not work.

I am able to search pages, ie.:
http://arete.ibb.waw.pl/html/leksykon/cd_rom_report_en?nazwa_angielska=b
but I am unable to display single records, ie.:
http://arete.ibb.waw.pl/html/leksykon/single_record_report_hasla2?nazwa_ident_hasla2=933

  Traceback (innermost last):
  File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 222, in
publish_module
  File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 187, in
publish
  File /opt/www/zope/lib/python/Zope/__init__.py, line 221, in
zpublisher_exception_hook
    (Object: Traversable)
  File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 171, in
publish
  File /opt/www/zope/lib/python/ZPublisher/mapply.py, line 160, in
mapply
    (Object: NowehaslaReplyForm)
  File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 112, in
call_object
    (Object: NowehaslaReplyForm)
  File /opt/www/zope/lib/python/OFS/DTMLDocument.py, line 189, in
__call__
    (Object: NowehaslaReplyForm)
  File /opt/www/zope/lib/python/DocumentTemplate/DT_String.py, line 538,
in __call__
    (Object: NowehaslaReplyForm)
  File /opt/www/zope/lib/python/DocumentTemplate/DT_In.py, line 711, in
renderwob
    (Object: single_id_hasla2)
  KeyError: (see above)

I am unable to use TIMESTAMP from database
ie.:
Traceback (innermost last):
  File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 222, in
publish_module
  File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 187, in
publish
  File /opt/www/zope/lib/python/Zope/__init__.py, line 221, in
zpublisher_exception_hook
    (Object: Traversable)
  File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 171, in
publish
  File /opt/www/zope/lib/python/ZPublisher/mapply.py, line 160, in
mapply
    (Object: search_report_pl)
  File /opt/www/zope/lib/python/ZPublisher/Publish.py, line 112, in
call_object
    (Object: search_report_pl)
  File /opt/www/zope/lib/python/OFS/DTMLMethod.py, line 189, in __call__
    (Object: search_report_pl)
  File /opt/www/zope/lib/python/DocumentTemplate/DT_String.py, line 538,
in __call__
    (Object: search_report_pl)
  File /opt/www/zope/lib/python/DocumentTemplate/DT_In.py, line 480, in
renderwb
    (Object: simple_search_pl)
  File /opt/www/zope/lib/python/Shared/DC/ZRDB/DA.py, line 488, in
__call__
    (Object: simple_search_pl)
  File /opt/www/zope/lib/python/Shared/DC/ZRDB/DA.py, line 435, in
_cached_result
    (Object: simple_search_pl)
  File /opt/www/zope/lib/python/Products/ZMySQLDA/db.py, line 231, in
query
  File /opt/www/zope/lib/python/Products/ZMySQLDA/db.py, line 104, in
_mysql_timestamp_converter
ValueError: (see above)
--------------------------------

What is wrong. Is is MySQL or ZOPE or ZMySQLDA problem?

Regards,
Piotr
-- 
_____________________________________
Piotr Kozbial http://arete.ibb.waw.pl