Modify

Opened 5 years ago

Closed 5 years ago

#6068 closed defect (invalid)

Zero tickets in report

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

Description

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'
192.168.0.1 - - [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 5 years ago by todjiang

  • Resolution set to invalid
  • Status changed from new to closed

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.

Add Comment

Modify Ticket

Action
as closed .
The resolution will be deleted. Next status will be 'reopened'.
Author


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

 
Note: See TracTickets for help on using tickets.