hi,
i'm using from-svn turbogears, revision 306.
i am unable to edit/add objects using catwalk.
it works ok with "tg-admin shell".
i'm using mac osx, and postgres 8.0.4.
when editing, i get (full traceback at the end of the mail):
=====
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/postgres/pgconnection.py",
line 119, in _queryInsertID
c.execute("SELECT NEXTVAL('%s')" % sequenceName)
ProgrammingError: ERROR: current transaction is aborted, commands
ignored until end of transaction block
SELECT NEXTVAL('node_id_seq')
=====
when adding a new object i get (full traceback at the end of the mail):
=====
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/dbconnection.py",
line 295, in _executeRetry
return cursor.execute(query)
ProgrammingError: ERROR: current transaction is aborted, commands
ignored until end of transaction block
UPDATE node SET stuff = 'stuffz', name = 'nammes' WHERE id = 16
=====
does it work for anyone?
or is this simply a bug with catwalk?
if so, should i create a ticket in trac?
thanks,
gabor
ADD_NEW_ENTRY_TRACEBACK:
2005/12/10 01:21:17 INFO Traceback (most recent call last):
File
"/sw/lib/python2.4/site-packages/CherryPy-2.1.0-py2.4.egg/cherrypy/_cphttptools.py",
line 271, in run
main()
File
"/sw/lib/python2.4/site-packages/CherryPy-2.1.0-py2.4.egg/cherrypy/_cphttptools.py",
line 502, in main
body = page_handler(*args, **cherrypy.request.paramMap)
File "/Users/gabor/devel/turbogears/turbogears/controllers.py", line
196, in newfunc
html, *args, **kw)
File "/Users/gabor/devel/turbogears/turbogears/database.py", line
174, in run_with_transaction
retval = func(*args, **kw)
File "/Users/gabor/devel/turbogears/turbogears/controllers.py", line
222, in _execute_func
output = func(self, *args, **kw)
File "/Users/gabor/devel/turbogears/turbogears/catwalk/catwalk.py",
line 697, in add
new_object = eval(u'obj(%s)'% param_string)
File "<string>", line 0, in ?
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/main.py",
line 1183, in __init__
self._create(id, **kw)
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/main.py",
line 1210, in _create
self._SO_finishCreate(id)
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/main.py",
line 1234, in _SO_finishCreate
id, names, values)
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/dbconnection.py",
line 744, in queryInsertID
return self._dbConnection._queryInsertID(
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/postgres/pgconnection.py",
line 119, in _queryInsertID
c.execute("SELECT NEXTVAL('%s')" % sequenceName)
ProgrammingError: ERROR: current transaction is aborted, commands
ignored until end of transaction block
SELECT NEXTVAL('node_id_seq')
EDIT_ENTRY_TRACEBACK:
2005/12/10 01:27:03 INFO Traceback (most recent call last):
File
"/sw/lib/python2.4/site-packages/CherryPy-2.1.0-py2.4.egg/cherrypy/_cphttptools.py",
line 271, in run
main()
File
"/sw/lib/python2.4/site-packages/CherryPy-2.1.0-py2.4.egg/cherrypy/_cphttptools.py",
line 502, in main
body = page_handler(*args, **cherrypy.request.paramMap)
File "/Users/gabor/devel/turbogears/turbogears/controllers.py", line
196, in newfunc
html, *args, **kw)
File "/Users/gabor/devel/turbogears/turbogears/database.py", line
174, in run_with_transaction
retval = func(*args, **kw)
File "/Users/gabor/devel/turbogears/turbogears/controllers.py", line
222, in _execute_func
output = func(self, *args, **kw)
File "/Users/gabor/devel/turbogears/turbogears/catwalk/catwalk.py",
line 710, in update
self.update_object(object_name,id,values)
File "/Users/gabor/devel/turbogears/turbogears/catwalk/catwalk.py",
line 213, in update_object
eval('instance.set(%s)'% parameter_string)
File "<string>", line 0, in ?
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/main.py",
line 1128, in set
self._connection._SO_update(self, args)
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/dbconnection.py",
line 555, in _SO_update
self.query("UPDATE %s SET %s WHERE %s = %s" %
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/dbconnection.py",
line 732, in query
return self._dbConnection._query(self._connection, s)
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/dbconnection.py",
line 300, in _query
self._executeRetry(conn, conn.cursor(), s)
File
"/sw/lib/python2.4/site-packages/SQLObject-0.7.0-py2.4.egg/sqlobject/dbconnection.py",
line 295, in _executeRetry
return cursor.execute(query)
ProgrammingError: ERROR: current transaction is aborted, commands
ignored until end of transaction block
UPDATE node SET stuff = 'stuffz', name = 'nammes' WHERE id = 16
