Modify

Opened 15 years ago

Closed 12 years ago

#6303 closed defect (worksforme)

Install AgiloTicketReportPlugin Error

Reported by: rue@… Owned by: Ryan J Ollos
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 Martin Häcker 15 years ago.
Patch to fix this problem

Download all attachments as: .zip

Change History (12)

comment:1 in reply to:  description Changed 15 years ago by 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.

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

comment:4 Changed 15 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 15 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 15 years ago by Martin Häcker

Patch to fix this problem

comment:6 Changed 15 years ago by 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

comment:7 Changed 14 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 14 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 14 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 12 years ago by Ryan J Ollos

Owner: changed from Tod Jiang to Ryan J Ollos
Status: newassigned

comment:11 Changed 12 years ago by Ryan J Ollos

Resolution: worksforme
Status: assignedclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Ryan J Ollos.
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.