SQL problems using Postgres

[chous@…]

After installing WikiMacroCounter (happens on other parts of Trac as well), I get the following error:

ERROR: current transaction is aborted, commands ignored until end of transaction block

SELECT filename,description,size,time,author,ipnr FROM attachment WHERE type='wiki' AND id='WikiStart' ORDER BY time

Python traceback:

Traceback (most recent call last):
  File "/usr/lib/python2.4/site-packages/trac/web/modpython_frontend.py", line 206, in handler
    dispatch_request(mpr.path_info, mpr, env)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 139, in dispatch_request
    dispatcher.dispatch(req)
  File "/usr/lib/python2.4/site-packages/trac/web/main.py", line 107, in dispatch
    resp = chosen_handler.process_request(req)
  File "/usr/lib/python2.4/site-packages/trac/wiki/web_ui.py", line 116, in process_request
    self._render_view(req, db, page)
  File "/usr/lib/python2.4/site-packages/trac/wiki/web_ui.py", line 375, in _render_view
    for attachment in Attachment.select(self.env, 'wiki', page.name, db):
  File "/usr/lib/python2.4/site-packages/trac/attachment.py", line 171, in select
    (parent_type, str(parent_id)))
ProgrammingError: ERROR:  current transaction is aborted, commands ignored until end of transaction block

SELECT filename,description,size,time,author,ipnr FROM attachment WHERE type='wiki' AND id='WikiStart' ORDER BY time

[Markus Bertheau <mbertheau@…>]

The error message means that there was an earlier SQL error that aborted the transaction. For some reason that error wasn't shown.

[Christian Boos]

Probably a WikiMacroCounter error. I suggest that we close this as wontfix and the reporter should probably create a ticket on TracHacks or at the place the plugin is hosted.

[sid]

I cannot find the WikiMacroCounter on TracHacks or the MacroBazaar to test this. But I also agree with cboos. If this only happens when you have WikiMacroCounter installed, then it is a problem with that custom macro, not with Trac. Please ask for support where you got the macro.

If this is a general Trac problem unrelated to the macro, please feel free to reopen the ticket.