A) your SQL is wrong, you want a VARCHAR not a CHAR there. and i doubt 'NOW' is a valid value for a TIMESTAMP type in your DB. You'll be wanting a SQL function like Date(), not a string. Probably. Look in your DB docs. Not that I'm much of a SQL person - someone else will probably correct me. B) Now why you'd get a pickling error when you've got bad SQL i don't know - and 'cannot pickle objects' is a blantant lie. Surely that's what pickling's all about. Anyway you read the traceback from bottom to top. The error occured on line 348 of Connection.py, which threw an error in Transaction.py, blah blah, which threw an error in Publish.py, which caused Zope to exit the publisher and print the stack trace. seb.

-----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Tom Deprez Sent: 01 August 2000 12:41 To: zope@zope.org Subject: [Zope] tracebacks

Hi,

Can somebody explain me how you can use the given tracebacks to find the possible error? For example, I get the following error and I know what causes it, but I don't know where I must go to find the code-line where the error starts:

I get the following error when I use a table in which a field is defined with a default string value.

eg :

MY_NAME CHAR(20) DEFAULT 'tom' MY_DATE TIMESTAMP DEFAULT '6/07/2000' MY_DATE TIMESTAMP DEFAULT 'NOW'

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

Error Type: cPickle.PicklingError Error Value: Cannot pickle objects. ---

<!-- Traceback (innermost last): File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 222, in publish_module File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 187, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 221, in zpublisher_exception_hook File /usr/local/zope/lib/python/ZPublisher/Publish.py, line 175, in publish File /usr/local/zope/lib/python/Zope/__init__.py, line 235, in commit File /usr/local/zope/lib/python/ZODB/Transaction.py, line 251, in commit File /usr/local/zope/lib/python/ZODB/Connection.py, line 348, in commit (Info: (('Products.ZnolkSQLWizard.Wizard', 'ZnolkSQLWizard'), '\000\000\000\000\000\000\015\025', '')) cPickle.PicklingError: (see above)

-->

Thanks for any advice.

Tom

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )