[Zope-DB] Problems with ZODBC & User type

Samir Mishra SamirMishra@cbuae.gov.ae
Mon, 7 Jul 2003 14:26:50 +0400

Hello all,

I'm trying to run a query that updates a record in a table in MS SQL using
ZODBC. When I run the query as a manager, it runs without a hitch, but when
I try and run it as an authenticated user, I get the following error -

Site Error
An error was encountered while publishing this resource. 


Sorry, a site error occurred.

Traceback (innermost last): 

Module ZPublisher.Publish, line 150, in publish_module 
Module Products.Localizer, line 57, in new_publish 
Module ZPublisher.Publish, line 114, in publish 
Module Zope.App.startup, line 182, in zpublisher_exception_hook 
Module ZPublisher.Publish, line 98, in publish 
Module ZPublisher.mapply, line 88, in mapply 
Module ZPublisher.Publish, line 39, in call_object 
Module OFS.DTMLMethod, line 126, in __call__ 
Module DocumentTemplate.DT_String, line 474, in __call__ 
Module DocumentTemplate.DT_Util, line 201, in eval
__traceback_info__: REQUEST 
Module <string>, line 2, in f 
Module Shared.DC.ZRDB.DA, line 428, in __call__ 
Module Products.ZODBCDA.db, line 198, in query 

sql.error: ('22001', 8152, '[Microsoft][ODBC SQL Server Driver][SQL
Server]String or binary data would be truncated.') (Also, an error occurred
while attempting to render the standard error message.) 


Could someone help me with this? Not sure where the problem is, and it
definitely works when I'm logged in as a manager.