Modify

Opened 5 years ago

Closed 2 years ago

#6303 closed defect (worksforme)

Install AgiloTicketReportPlugin Error

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

Description

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,

Attachments (1)

0001-Behave-as-plain-trac-on-milestone-update.patch (2.2 KB) - added by dwt 5 years ago.
Patch to fix this problem

Download all attachments as: .zip

Change History (12)

comment:1 in reply to: ↑ description Changed 5 years ago by todjiang

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.

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

comment:3 in reply to: ↑ 2 Changed 5 years ago by todjiang

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.

comment:4 Changed 5 years ago by 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 ?

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

Changed 5 years ago by dwt

Patch to fix this problem

comment:6 Changed 5 years ago by dwt

@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

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

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

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

comment:10 Changed 2 years ago by rjollos

  • Owner changed from todjiang to rjollos
  • Status changed from new to assigned

comment:11 Changed 2 years ago by rjollos

  • Resolution set to worksforme
  • Status changed from assigned to closed

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

Add Comment

Modify Ticket

Action
as closed The owner will remain rjollos.
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.