[Zope] tracebacks

[Seb Bacon]

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 )
> 
>