[Zope] Strange Error with mxDateTime/Zope 1.11pr1 win32 / also ODBC Problems

[Phil Harris]

Hi all,

I hope someone can help me here, I have installed and am happily using the
mxDatetime package.

Now the problem, I'm getting a strange error message that I hope someone can
help with:

Traceback says

Traceback (innermost last):
  File D:\zope\lib\python\ZPublisher\Publish.py, line 255, in publish_module
  File D:\zope\lib\python\ZPublisher\Publish.py, line 157, in publish
  File D:\zope\lib\python\ZPublisher\mapply.py, line 154, in mapply
    (Object: index_html)
  File D:\zope\lib\python\ZPublisher\Publish.py, line 98, in call_object
    (Object: index_html)
  File D:\zope\lib\python\OFS\DTMLDocument.py, line 181, in __call__
    (Object: index_html)
  File D:\zope\lib\python\OFS\DTMLDocument.py, line 177, in __call__
    (Object: index_html)
  File D:\zope\lib\python\DocumentTemplate\DT_String.py, line 514, in
__call__
    (Object: index_html)
  File D:\zope\lib\python\DocumentTemplate\DT_Util.py, line 315, in eval
    (Object: drawcal(year=1999,month=3))
  File <string>, line 0, in ?
  File D:\zope\lib\python\Products\ExternalMethod\ExternalMethod.py, line
231, in __call__
    (Object: drawcal)
  File D:\zope\lib\python\Products\ExternalMethod\ExternalMethod.py, line
193, in getFunction
    (Object: drawcal)
  File D:\zope\lib\python\App\Extensions.py, line 195, in getObject
    (Info: ('d:/Zope\\Extensions\\drawcal.py', 'drawcal'))
  File d:/Zope\Extensions\drawcal.py, line 71, in ?
  File d:/Zope\Extensions\drawcal.py, line 9, in drawcal
  File D:\zope\lib\python\DateTime\DateTime.py, line 582, in __init__
TypeError: (see above)

and the actual error message is:-

Zope Error
Zope has encountered an error while publishing this resource.

Error Type: TypeError
Error Value: not all arguments converted
             ~~~~~~~~~~~~~~~~~~~~~~~~~~~


Versions of software used are Zope 1.11pr1 with the binary python that comes
with this, using zserver as the server.

Now problem number two, and I'm not alone here, at least one other user I'm
in contact with also suffers with this.

When using ODBC with MS Access and/or MySQL opn Win32 I get strange errors
whenever a date field is read from the database, namely:-

Traceback (innermost last):
  File D:\zope\lib\python\ZPublisher\Publish.py, line 255, in publish_module
  File D:\zope\lib\python\ZPublisher\Publish.py, line 157, in publish
  File D:\zope\lib\python\ZPublisher\mapply.py, line 154, in mapply
    (Object: manage_test)
  File D:\zope\lib\python\ZPublisher\Publish.py, line 98, in call_object
    (Object: manage_test)
  File D:\zope\lib\python\Shared\DC\ZRDB\DA.py, line 300, in manage_test
    (Object: test)
  File D:\zope\lib\python\DocumentTemplate\DT_String.py, line 514, in
__call__
    (Object: <string>)
  File D:\zope\lib\python\DocumentTemplate\DT_In.py, line 580, in renderwb
    (Object: test)
  File D:\zope\lib\python\Shared\DC\ZRDB\RDB.py, line 272, in __getitem__
ValueError: Invalid value, 1999-04-23 00:00:00, for DATE in record 1316

Well that's enough problems for now, thanks in advance for any suggestions.

See ya

Phil
phil@philh.org