I am getting the following error with SA 0.5.0rc4 and Postgres 8.1
while trying some integration work with SQLAlchemy and Plone (on top of
Zope). Any idea?
Andreas
get(): <Storage RDBMSStorage> <ATDocument at front-page>
ab23df631c18ea2c9ae7be8321f647dd
2008-11-23 15:13:39 ERROR root Exception while rendering an error message
Traceback (most recent call last):
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/OFS/SimpleItem.py",
line 227, in raise_standardErrorMessage
v = s(**kwargs)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/CMFCore/FSPythonScript.py",
line 140, in __call__
return Script.__call__(self, *args, **kw)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/Shared/DC/Scripts/Bindings.py",
line 313, in __call__
return self._bindAndExec(args, kw, None)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/Shared/DC/Scripts/Bindings.py",
line 350, in _bindAndExec
return self._exec(bound_data, args, kw)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/CMFCore/FSPythonScript.py",
line 196, in _exec
result = f(*args, **kw)
File "Script (Python)", line 34, in standard_error_message
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/Shared/DC/Scripts/Bindings.py",
line 313, in __call__
return self._bindAndExec(args, kw, None)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/Shared/DC/Scripts/Bindings.py",
line 350, in _bindAndExec
return self._exec(bound_data, args, kw)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/CMFCore/FSPageTemplate.py",
line 216, in _exec
result = self.pt_render(extra_context=bound_names)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/CMFCore/FSPageTemplate.py",
line 155, in pt_render
result = FSPageTemplate.inheritedAttribute('pt_render')(
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/Products/PageTemplates/PageTemplate.py",
line 89, in pt_render
return super(PageTemplate, self).pt_render(c, source=source)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/pagetemplate/pagetemplate.py",
line 117, in pt_render
strictinsert=0, sourceAnnotations=sourceAnnotations)()
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 271, in __call__
self.interpret(self.program)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 346, in interpret
handlers[opcode](self, args)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 891, in do_useMacro
self.interpret(macro)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 346, in interpret
handlers[opcode](self, args)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 536, in do_optTag_tal
self.do_optTag(stuff)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 521, in do_optTag
return self.no_tag(start, program)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 516, in no_tag
self.interpret(program)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 346, in interpret
handlers[opcode](self, args)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 891, in do_useMacro
self.interpret(macro)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 346, in interpret
handlers[opcode](self, args)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tal/talinterpreter.py",
line 586, in do_setLocal_tal
self.engine.setLocal(name, self.engine.evaluateValue(expr))
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tales/tales.py",
line 696, in evaluate
return expression(self)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/zope/tales/expressions.py",
line 217, in __call__
return self._eval(econtext)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/Products/PageTemplates/Expressions.py",
line 161, in _eval
return render(ob, econtext.vars)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/zope2/lib/python/Products/PageTemplates/Expressions.py",
line 123, in render
ob = ob()
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/CMFPlone/browser/ploneview.py",
line 67, in globalize
self._initializeData(options=options, view=view, template=template)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/CMFPlone/browser/ploneview.py",
line 111, in _initializeData
self._data['object_title'] = context_state.object_title()
File
"/home/ajung/.buildout/eggs/plone.memoize-1.0.4-py2.4.egg/plone/memoize/view.py",
line 55, in memogetter
value = cache[key] = func(*args, **kwargs)
File
"/home/ajung/.buildout/eggs/plone.app.layout-1.1.5-py2.4.egg/plone/app/layout/globals/context.py",
line 123, in object_title
return utils.pretty_title_or_id(context, context)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/CMFPlone/utils.py",
line 161, in pretty_title_or_id
title = title()
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/Archetypes/ClassGen.py",
line 56, in generatedAccessor
return schema[name].get(self, **kw)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/Archetypes/Field.py",
line 839, in get
value = ObjectField.get(self, instance, **kwargs)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/parts/plone/Archetypes/Field.py",
line 706, in get
return self.getStorage(instance).get(self.getName(), instance,
**kwargs)
File
"/home/ajung/src/marburg/zopyx.plone.archetypes_on_rdbms/buildout/trunk/src/zopyx.plone.archetypes_on_rdbms/zopyx/plone/archetypes_on_rdbms/storage.py",
line 36, in get
row = session.query(mapper_cls).filter_by(uuid=uuid).one()
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py",
line 1048, in one
ret = list(self[0:2])
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py",
line 952, in __getitem__
return list(res)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py",
line 1088, in __iter__
return self._execute_and_instances(context)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/query.py",
line 1091, in _execute_and_instances
result = self.session.execute(querycontext.statement,
params=self._params, mapper=self._mapper_zero_or_none(),
_state=self._refresh_state)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py",
line 749, in execute
return self.__connection(engine, close_with_result=True).execute(
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py",
line 716, in __connection
return self.transaction._connection_for_bind(engine)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/orm/session.py",
line 331, in _connection_for_bind
transaction = conn.begin_nested()
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py",
line 669, in begin_nested
self.__transaction = NestedTransaction(self, self.__transaction)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py",
line 1038, in __init__
self._savepoint = self.connection._savepoint_impl()
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py",
line 740, in _savepoint_impl
self.engine.dialect.do_savepoint(self, name)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/default.py",
line 110, in do_savepoint
connection.execute(expression.SavepointClause(name))
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py",
line 806, in execute
return Connection.executors[c](self, object, multiparams, params)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py",
line 856, in execute_clauseelement
return self.__execute_context(context)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py",
line 878, in __execute_context
self._cursor_execute(context.cursor, context.statement,
context.parameters[0], context=context)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py",
line 927, in _cursor_execute
self._handle_dbapi_exception(e, statement, parameters, cursor)
File
"/home/ajung/.buildout/eggs/SQLAlchemy-0.5.0rc4-py2.4.egg/sqlalchemy/engine/base.py",
line 909, in _handle_dbapi_exception
raise exc.DBAPIError.instance(statement, parameters, e,
connection_invalidated=is_disconnect)
ProgrammingError: (ProgrammingError) Fehler »syntax error« bei »SAVEPOINT«
LINE 1: SAVEPOINT sa_savepoint_2
^
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
begin:vcard
fn:Andreas Jung
n:Jung;Andreas
org:ZOPYX Ltd. & Co. KG
adr;quoted-printable:;;Charlottenstr. 37/1;T=C3=BCbingen;;72070;Germany
email;internet:[EMAIL PROTECTED]
title:CEO
tel;work:+49-7071-793376
tel;fax:+49-7071-7936840
tel;home:+49-7071-793257
x-mozilla-html:FALSE
url:www.zopyx.com
version:2.1
end:vcard
