Team Availability doesn't work

[Chris.Nelson@…]

When I install the plugin, I get two Team Availability items on the Admin page but both give:

Traceback (most recent call last):
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/api.py", line 377, in send_error
    'text/html')
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/chrome.py", line 743, in render_template
    message = req.session.pop('chrome.%s.%d' % (type_, i))
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/api.py", line 195, in __getattr__
    value = self.callbacks[name](self)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 265, in _get_session
    return Session(self.env, req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/session.py", line 149, in __init__
    if req.authname == 'anonymous':
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/api.py", line 195, in __getattr__
    value = self.callbacks[name](self)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 134, in authenticate
    authname = authenticator.authenticate(req)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/auth.py", line 70, in authenticate
    authname = self._get_name_for_cookie(req, req.incookie['trac_auth'])
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/auth.py", line 189, in _get_name_for_cookie
    (cookie.value, req.remote_addr))
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/util.py", line 64, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
  File "/usr/local/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/util.py", line 64, in execute
    return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: current transaction is aborted, commands ignored until end of transaction block

[Chris.Nelson@…]

I get similar errors trying to update a ticket and the log files says

ProgrammingError: relation "availability" does not exist

[anonymous]

I manually did:

postgres psql sandbox                                                         
Welcome to psql 8.3.10, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands    
       \? for help with psql commands   
       \g or terminate with semicolon to execute query
       \q to quit                                     

sandbox=# CREATE TABLE  availability (
sandbox(# name varchar(255),          
sandbox(# validFrom varchar(20),
sandbox(# validUntil varchar(20),
sandbox(# weekdays varchar(255), 
sandbox(# resources varchar(255),
sandbox(# workFrom char(5),
sandbox(# workUntil char(5));
CREATE TABLE                 
sandbox=# ALTER TABLE availability OWNER TO sandbox;
ALTER TABLE

and the Team Availability admin panel runs without error. The problem appears to be that the plugin assumes SQLite.