Modify

Opened 5 years ago

Last modified 5 years ago

#7121 new defect

Team Availability doesn't work

Reported by: Chris.Nelson@… Owned by: viola
Priority: normal Component: SchedulingToolsPlugin
Severity: blocker Keywords:
Cc: Trac Release: 0.11

Description

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

Attachments (0)

Change History (2)

comment:1 Changed 5 years ago by Chris.Nelson@…

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

ProgrammingError: relation "availability" does not exist

comment:2 Changed 5 years ago by 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.

Add Comment

Modify Ticket

Action
as new The owner will remain viola.
Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.