Install AgiloTicketReportPlugin Error

[rue@…]

Hello, I've followed the link to complete the setup. And I get the error messages in the Admin panel.

" Trac detected an internal error:

OperationalError: no such table: agilo_sprint"

Have you met this situation ?

Thanks,

[Tod Jiang]

Replying to rue@ms5.hinet.net:

Hello, I've followed the link to complete the setup. And I get the error messages in the Admin panel.

" Trac detected an internal error:

OperationalError: no such table: agilo_sprint"

Have you met this situation ?

Thanks,

This plugin is depend on Agilo plugin, have you installed it ? Agilo plugin is agile process tool, agilo_sprint is created when you install agilo plugin.

[rue@…]

I've installed Agilo plugin but I still get the same error messages. And also the error show as below.

File "/usr/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 444, in _dispatch_request
  dispatcher.dispatch(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/web/main.py", line 205, in dispatch
  resp = chosen_handler.process_request(req)
File "/usr/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/admin/web_ui.py", line 114, in process_request
  path_info)
File "build/bdist.linux-i686/egg/AgiloTicketReport/ticketreport.py", line 91, in render_admin_panelFile "build/bdist.linux-i686/egg/AgiloTicketReport/ticketreport.py", line 187, in get_sprint_listFile "build/bdist.linux-i686/egg/AgiloTicketReport/ticketreport.py", line 156, in get_backlog_listFile "/usr/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/util.py", line 60, in execute
  return self.cursor.execute(sql)
File "/usr/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 58, in execute
  args or [])
File "/usr/lib/python2.5/site-packages/Trac-0.11.6-py2.5.egg/trac/db/sqlite_backend.py", line 50, in _rollback_on_error
  return function(self, *args, **kwargs)

[Tod Jiang]

I'll have test agilo_ticket_plugin with latest agilo version. And it's works in my environment.

My environment Info:

python2.5
agilo0.8.3--12032009
postgres db 8.3

I think you agile_sprint table hadn't created yet. Could you double your db tables? Sqlite is file database, so you can write query code to test that.

[rue@…]

I've check my sqlote db. there's no agilo_sprint table inside. How could I do to create this table ? Because I'm a junior IT.Can you help me ?

[khoffman@…]

I'm new to agilo, not new to trac. I'm having this problem (or at least similar) in repositories other than the one where agilo is enabled (I have multiple repos, we are trying agilo in a demo repo....).

We go to the roadmap in an unrelated repo, try to close the milestone and get the error "OperationalError: no such table: agilo_sprint". As expected, there is no agilo_sprint table in the sqlite db for this trac. I expected not to find a table because the plugin is not enabled in this trac. What is unexpected is roadmap.py looking for such a table.

[Martin Häcker]

Patch to fix this problem

[Martin Häcker]

@reporters: This could be a problem we fixed last week, so it will be in the next release of Agilo - probably in about two weeks.

To be sure, could you please state the versions of the involved plugins plugins you are using?

One way to do this is to log in to agilo as an admin and visit "About Trac" in the upper right corner. Then copy the system information table.

I would also like to invite you to our support google group at ​http://groups.google.com/group/agilo so that others can participate in the resolution of this problem too.

If you feel adventourus, you could also try applying this patch till then and report if that fixes the problem.

Thanks in advance!

Regards, Martin

[freeix@…]

Dear dwt

I meet the same error "no such table agilo_sprint" with agilo-1.2.1_PRO-py2.4.egg, how can I resolve this, please tell me. I download the "0001-Behave-as-plain-trac-on-milestone-update.patch" it seems not a really patch file.

[freeix@…]

System Information
Trac: 0.11.7 
Python: 2.4.3 (#1, Sep 17 2008, 16:04:01) [GCC 4.1.2 20071124 (Red Hat 4.1.2-41)] 
setuptools: 0.6c11 
SQLite: 3.3.6 
pysqlite: 2.5.5 
Genshi: 0.5.1 
jQuery: 1.2.6 

[anonymous]

@freeix: it seems you haven't installed agilo? Regarding the patch file, what are you missing in it? It seems perfectly fine for me.

On a sidenote, I would like to invite you to join our free Agilo user group at ​http://groups.google.com/group/agilo . This web community is the preferred place to ask any questions regarding Agilo installation, configuration and usage.

Regards, Martin

[Ryan J Ollos]

I misread the earlier comment. Closing since there has been no follow-up in some time.