- Zope - Zope lists

problem with ms sql server
by Miguel Beltran R. 02 Dec '08

02 Dec '08

Hi list I have a zsql where made a UPDATE and INSERT, I need know when happen a error to show. I using pyodbc 2.0.58, zpyodbcda 1.0.6 and ms sql server 2000 [zsql with error after render: actualiza_info ] SET XACT_ABORT ON BEGIN TRANSACTION UPDATE taller SET comercial = '' where taller = 1 insert into taller_movimiento (estado, taller, fecha, asunto, observacion ) values( '14', 1, '', <--This must be not blank '', '' ) COMMIT TRANSACTION [dtml method] <dtml-try> <dtml-call actualiza_info> All Ok <dtml-except> Error, but not showed :( </dtml-if> If I test the zsql show this, but must show the error: This statement returned no results. ------------------------------ *SQL used:* SET XACT_ABORT ON BEGIN TRANSACTION UPDATE taller SET comercial = '' where taller = 1 insert into taller_movimiento (estado, taller, fecha, asunto, observacion ) values( '14', 1, '', '', '' ) COMMIT TRANSACTION -- ________________________________________ Lo bueno de vivir un dia mas es saber que nos queda un dia menos de vida

3 2

Re: [Zope] database conflict error on startup - disabling Five
by Dieter Maurer 01 Dec '08

01 Dec '08

Dylan Jay wrote at 2008-12-1 10:22 +1100: > ... >> You are right. Almost surely, you see a "Five" bug: "Five", too, should >> respect "enable-product-installation". >> >> You can see the right transaction handling in >> "OFS.Application.install_product' -- somewhere near the buttom of this >> function. >> Maybe, you correct "Five" accordingly. > >I applied this guys patch which seems to have fixed the problem >http://archives.free.net.ph/message/20080516.100305.16f90017.en.html > >He's asking if that is the right way to patch it. Is it? It looks not bad. >And if so what is the right way to get it into the Five 1.4 branch? Write a bug report, attach the patch and for a quicker response inform a "Five" maintainer about the "bug+solution". I am not sure however, that this will be sufficient: "Zope 2.9" is no longer an actively maintained version; maybe the maintainers think there are more important tasks that to fix problems with older versions. -- Dieter

2 1

Anyone know of a tool to restore/cleanup/reset security/role settings?
by Ross Patterson 01 Dec '08

01 Dec '08

Does anyone know of an existing tool for restoring all security settings/rolemaps from the ground up? Obviously I can use rolemap.xml where applicable and update workflow security. I want to first restore the Zope root to code defaults and restore the whole hierarchy to just acquire. I'm going to write something myself if not, but I thought I'd see if there was anything out there. Ross

2 4

Re: [Zope] database conflict error on startup - disabling Five
by Dieter Maurer 30 Nov '08

30 Nov '08

Dylan Jay wrote at 2008-11-30 08:46 +1100: > ... >> When you have a multi ZEO client setup, you should have a single >> client distinguished responsible to keep "Control_Panel/products" >> up to date. There is a configuration option for this ("*enable*product*"). >> Set it to "on" in this distinguished client and to "off" in all others. >> This avoids "ConflictError"s during startup. > >Thanks for the tip but it didn't solve the problem. >The conflict error is coming from Five zcml registration steps so I guess >"enable-product-installation off" doesn't help with that. You are right. Almost surely, you see a "Five" bug: "Five", too, should respect "enable-product-installation". You can see the right transaction handling in "OFS.Application.install_product' -- somewhere near the buttom of this function. Maybe, you correct "Five" accordingly. >Any idea why this is happening to me >and doesn't seem to be a common problem >others come across? "ConflictError"s are apparently nondeterministic errors -- they only occur when concurrent transactions conflict with one another. Apparently, in your setup, the conflict probability is especially high (maybe because it is especially expensive to register your package). In principle, others are threatened as well if the are using "registerPackage". I do not have Zope 2.9 with its "Five". In Zope 2.11, the "Five" code appears to have been cleaned up. This means, upgrading to Zope 2.11 may be another option for you. -- Dieter

1 0

Where is my BtreeFolder stored?
by Mr SZ 29 Nov '08

29 Nov '08

Hi All, I can now create BTreeFolders and add,remve items to and from it but how and where does zope store my folders,does the id indicate the folder I'm storing in? This is in an external method: def test3(): f = BTreeFolder2('sufest') f2 = BTreeFolder2('somefolder') f3 = BTreeFolder2('somefolder2') f._setObject(f2.id, f2) f._setObject(f3.id, f3) uniq_id = f.generateId() obT = OOBStuff(uniq_id,{'a':1,'b':2}) f._setOb(uniq_id, obT) lst = f.objectItems() return lst def test4(): if 'suftest' in aq_parent.objectIds(): return 'True' class OOBStuff(BTreeFolder2): meta_type ='OOBStuff' def __init__(self, oid,dict_to_add): super(OOBStuff, self).__init__(oid) self.item = OOBTree() self.item['Auth'] = dict_to_add def return_Tree(self): return self.item Running test4 gives this error: Error Type: AttributeError Error Value: 'builtin_function_or_method' object has no attribute 'objectIds' Also, how come my BTFolder didn't show up anywhere in the ZMI? I have imported aq_base and aq_parent. Regards, sz " life isn't heavy enough,it flies away and floats far above action" Start your day with Yahoo!7 and win a Sony Bravia TV. Enter now http://au.docs.yahoo.com/homepageset/?p1=other&p2=au&p3=tagline

3 2

database conflict error on startup - disabling Five
by djay75 29 Nov '08

29 Nov '08

Hi, I'm getting the following error during startup of a zeo with 3 instances. It doesn't happen with one instance. It's zope2.9.8, plone 2.5 and the Five 1.4 svn branch. I thought the Five svn branch might help based on this thread http://archives.free.net.ph/message/20080520.172500.38ab3445.en.html but no luck. 2008-11-25T00:37:49 ERROR Zope Couldn't install Five Traceback (most recent call last): File "c:\zope\2.9.8\Zope\lib\python\OFS\Application.py", line 783, in install_product initmethod(context) File "c:\zope\Plone\parts\productsvn\Five\__init__.py", line 31, in initialize zcml.load_site() File "c:\zope\Plone\parts\productsvn\Five\zcml.py", line 41, in load_site _context = xmlconfig.file(file) File "c:\zope\2.9.8\Zope\lib\python\zope\configuration\xmlconfig.py", line 560, in file context.execute_actions() File "c:\zope\2.9.8\Zope\lib\python\zope\configuration\config.py", line 612, in execute_actions callable(*args, **kw) File "c:\zope\Plone\parts\productsvn\Five\fiveconfigure.py", line 289, in _registerPackage transaction.commit() File "c:\zope\2.9.8\Zope\lib\python\transaction\_manager.py", line 96, in commit return self.get().commit(sub, deprecation_wng=False) File "c:\zope\2.9.8\Zope\lib\python\transaction\_transaction.py", line 380, in commit self._saveCommitishError() # This raises! File "c:\zope\2.9.8\Zope\lib\python\transaction\_transaction.py", line 378, in commit self._commitResources() File "c:\zope\2.9.8\Zope\lib\python\transaction\_transaction.py", line 433, in _commitResources rm.commit(self) File "c:\zope\2.9.8\Zope\lib\python\ZODB\Connection.py", line 484, in commit self._commit(transaction) File "c:\zope\2.9.8\Zope\lib\python\ZODB\Connection.py", line 518, in _commit raise ConflictError(object=obj) ConfigurationExecutionError: ZODB.POSException.ConflictError: database conflict error (oid 0x1338, class App.Product.Product) in: File "c:\zope\plone\src\pretaweb.obrien_theme\pretaweb\obrien_theme\configure.zcml", line 8.2-8.63 <five:registerPackage package="." initialize=".initialize" /> -- View this message in context: http://www.nabble.com/database-conflict-error-on-startup---disabling-Five-t… Sent from the Zope - General mailing list archive at Nabble.com.

2 1

How to get all URL's
by Rupesh P Raj 28 Nov '08

28 Nov '08

Hi, How can I get the list of all urls from zodb. This is for creating an xml Sitemap? Zope version is 2.8. Thanks Pearl

3 9

Obtaining user name in python
by Garry Saddington 28 Nov '08

28 Nov '08

I can do this in DTML: <dtml-var "_.SecurityGetUser().getUserName()"> but I want to do it from a Python script, where the use of the underscore is not allowed. Can anyone point me in the correct direction? Regards Garry

2 1

Cookie _ZopeId
by Ulla Theiss 27 Nov '08

27 Nov '08

Hello list, Zope sets a Cookie with the name "_ZopeId". For which purpose this cookie is used? Many thanks in advance, Ulla.

2 1

import error
by sujitha mary 27 Nov '08

27 Nov '08

hi all, The importing of my site is getting failed due to an error: "Input MIME type 'text/x-web-markdown' for transform markdown_to_html is not registered in the MIME types registry" I can't re-export my site as my system got crashed and i have only my backup which is a .zexp file. Is there any other possibility? Please help. Thanks in advance. --------------------------------- Bollywood news, movie reviews, film trailers and more! Click here.

1 0