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.
I'm using an Interbase database. You can use CHAR and VARCHAR. The last one is a variable char, while the first has a fixed length. Anyway, this was just an example out of my head to explain what I'm experiencing. 'NOW' can be used in Interbase as it will insert the current date&time when a value is not given for a record. (Although, I'm not sure it will work through Zope, I'm just curious :-) ). Anyway, '12/07/2000' should work.
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.
MY_NAME VARCHAR(20) DEFAULT 'tom', gives the same error. And yes, it's strange that I get an error with a default literal value. Could it be that Zope handles the tom in 'tom' as a python expresion or something?
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.
Thanks Seb, this is what I wanted to know about the traceback. Tom.
-----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 )