Zero tickets in report

[lmar@…]

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 ?

[Tod Jiang]

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.