Opened 8 years ago

Closed 8 years ago

#6068 closed defect (invalid)

Zero tickets in report

Reported by: lmar@… Owned by: Tod Jiang
Priority: normal Component: AgiloTicketReportPlugin
Severity: normal Keywords:
Cc: Trac Release: 0.11


When I try to prepare a report , I set the start date like 2009/1/1 9:00:00 and end date like 2009/10/29 14:00:00 I get nothing in ticket report result

In trac log I have not seen any interesting:

16:53:48 Trac[default_workflow] DEBUG: Workflow actions at initialization: {'resolve': {'operations': [u'set_resolution'], 'name': 'resolve', 'default': 0, 'newstate': u'closed', 'oldstates': [u'new', u'assigned', u'accepted', u'reopened', u'pending'], 'permissions': [u'TICKET_MODIFY']}, 'accept': {'operations': [u'set_owner_to_self'], 'name': 'accept', 'default': 0, 'newstate': u'accepted', 'oldstates': [u'new', u'assigned', u'accepted', u'reopened', u'pending'], 'permissions': [u'TICKET_MODIFY']}, 'leave': {'operations': [u'leave_status'], 'name': 'leave', 'default': 1, 'newstate': u'*', 'oldstates': [u'*'], 'permissions': []}, 'reopen': {'operations': [u'del_resolution'], 'name': 'reopen', 'default': 0, 'newstate': u'reopened', 'oldstates': [u'closed'], 'permissions': [u'TICKET_CREATE']}, '_reset': {'operations': ['reset_workflow'], 'name': 'reset', 'default': 0, 'newstate': 'new', 'oldstates': [], 'permissions': []}, 'reassign': {'operations': [u'set_owner'], 'name': 'reassign', 'default': 0, 'newstate': u'assigned', 'oldstates': [u'new', u'assigned', u'accepted', u'reopened'], 'permissions': [u'TICKET_MODIFY']}, 'pending': {'operations': [], 'name': 'pending', 'default': 0, 'newstate': u'pending', 'oldstates': [u'new', u'assigned', u'accepted', u'reopened'], 'permissions': [u'TICKET_MODIFY']}}

16:53:48 Trac[env] WARNING: base_url option not set in configuration, generated links may be incorrect
16:53:48 Trac[main] DEBUG: Dispatching <Request "POST u'/admin/agilo/AgiloTicketReport'">
16:53:48 Trac[api] DEBUG: action controllers for ticket workflow: ['ConfigurableTicketWorkflow']
16:53:48 Trac[chrome] DEBUG: Prepare chrome data for request
16:53:48 Trac[session] DEBUG: Retrieving session for ID '22323fa664e265f644fe3c76' - - [29/Oct/2009 16:53:49] "POST /myproj/admin/agilo/AgiloTicketReport HTTP/1.1" 200 -

Before start testing I'm create needed tables in my sqlite3 trac.db from script:

CREATE TABLE agilo_backlog (
    name text PRIMARY KEY,
    b_type integer,
    description text,
    ticket_types text,
    sorting_keys text,
    b_strict integer
CREATE TABLE agilo_backlog_ticket (
    name text,
    pos integer,
    scope text,
... etc

I found it somwhere in internet 'cos agilo plugin complain to missed tables.

How to repair report ?

Attachments (0)

Change History (1)

comment:1 Changed 8 years ago by Tod Jiang

Resolution: invalid
Status: newclosed

Hi there, This plugin is design for Agilo Plugin which is scrum process tools base on trac. So, when you install Agilo, tables like "agilo_backlog" will create automatically.

Thanks, Tod.

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Tod Jiang.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Note: See TracTickets for help on using tickets.