Andrea -
(sorry for the delay, been out of town for a while)
I enabled the 3 agilo entries in trac.ini and turned on debug logging, and
THEN ran the trac-admin upgrade command as you suggested. There was no
change. Trac-admin says the database is current, and when I go to the admin
page it gets the same error (table agilo-sprint doesn't exist). Here's the
debug output during the trac-admin upgrade command:
2009-08-10 18:53:32,842 Trac[loader] DEBUG: Adding plugin tracaccountmanager
0.2.1dev from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:32,842 Trac[loader] DEBUG: Loading trac.ticket.web_ui from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,858 Trac[loader] DEBUG: Loading trac.mimeview.php from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,858 Trac[loader] DEBUG: Loading trac.ticket.query from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,875 Trac[loader] DEBUG: Loading trac.attachment from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,875 Trac[loader] DEBUG: Loading
trac.versioncontrol.svn_fs from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,875 Trac[loader] DEBUG: Loading trac.mimeview.patch from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,875 Trac[loader] DEBUG: Loading trac.mimeview.txtl from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,890 Trac[loader] DEBUG: Skipping "trac.mimeview.txtl =
trac.mimeview.txtl [textile]": ("DistributionNotFound: textile>=2.0" not
found)
2009-08-10 18:53:32,890 Trac[loader] DEBUG: Loading trac.admin.web_ui from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,905 Trac[loader] DEBUG: Loading trac.ticket.admin from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,905 Trac[loader] DEBUG: Loading trac.mimeview.rst from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,921 Trac[loader] DEBUG: Skipping "trac.mimeview.rst =
trac.mimeview.rst [rest]": ("DistributionNotFound: docutils>=0.3" not found)
2009-08-10 18:53:32,921 Trac[loader] DEBUG: Loading trac.db.postgres from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,921 Trac[loader] DEBUG: Loading
trac.versioncontrol.web_ui from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,937 Trac[loader] DEBUG: Loading trac.timeline from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,937 Trac[loader] DEBUG: Loading trac.mimeview.pygments
from c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,953 Trac[loader] DEBUG: Skipping "trac.mimeview.pygments
= trac.mimeview.pygments [pygments]": ("DistributionNotFound: Pygments>=0.6"
not found)
2009-08-10 18:53:32,953 Trac[loader] DEBUG: Loading trac.about from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,953 Trac[loader] DEBUG: Loading trac.wiki.interwiki from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,967 Trac[loader] DEBUG: Loading trac.ticket.roadmap from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,967 Trac[loader] DEBUG: Loading
trac.versioncontrol.svn_prop from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,967 Trac[loader] DEBUG: Loading trac.mimeview.silvercity
from c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,983 Trac[loader] DEBUG: Skipping
"trac.mimeview.silvercity = trac.mimeview.silvercity [silvercity]":
("DistributionNotFound: SilverCity>=0.9.4" not found)
2009-08-10 18:53:32,983 Trac[loader] DEBUG: Loading trac.wiki.macros from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:32,983 Trac[loader] DEBUG: Loading trac.db.sqlite from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,000 Trac[loader] DEBUG: Loading trac.wiki.web_ui from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,000 Trac[loader] DEBUG: Loading trac.mimeview.enscript
from c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,000 Trac[loader] DEBUG: Loading trac.web.auth from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,015 Trac[loader] DEBUG: Loading trac.admin.console from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,015 Trac[loader] DEBUG: Loading trac.db.mysql from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,015 Trac[loader] DEBUG: Loading trac.search from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,015 Trac[loader] DEBUG: Loading trac.prefs from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,030 Trac[loader] DEBUG: Loading trac.ticket.report from
c:\python25\lib\site-packages\trac-0.11.5-py2.5-win32.egg
2009-08-10 18:53:33,030 Trac[loader] DEBUG: Loading agilo.help.search from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,046 Trac[loader] DEBUG: Loading agilo.api.web_ui from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,046 Trac[loader] DEBUG: Loading agilo.charts from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,062 Trac[loader] DEBUG: Loading agilo_common.core from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,092 Trac[loader] DEBUG: Loading agilo.help from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,092 Trac[loader] DEBUG: Loading agilo.scrum from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,203 Trac[loader] DEBUG: Loading agilo_common.scrum from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,203 Trac[loader] DEBUG: Loading agilo_pro.pro_setup from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,217 Trac[loader] DEBUG: Loading agilo.init from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,217 Trac[loader] DEBUG: Loading agilo.admin from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,217 Trac[loader] DEBUG: Loading agilo_common.conf from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,233 Trac[loader] DEBUG: Loading agilo.ticket.web_ui from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,233 Trac[loader] DEBUG: Loading agilo.ticket.links from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,233 Trac[loader] DEBUG: Loading
agilo.scrum.workflow.rules from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,250 Trac[loader] DEBUG: Loading agilo.csv_import.web_ui
from c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,250 Trac[loader] DEBUG: Loading
agilo_common.scrum.backlog.web_ui from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,250 Trac[loader] DEBUG: Loading agilo.ticket from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,250 Trac[loader] DEBUG: Loading agilo.utils.permissions
from c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,250 Trac[loader] DEBUG: Loading agilo.utils.web_ui from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,265 Trac[loader] DEBUG: Loading agilo_common.ticket from
c:\python25\lib\site-packages\binary_agilo-1.0_pro_rc2-py2.5.egg
2009-08-10 18:53:33,265 Trac[loader] DEBUG: Loading acct_mgr.admin from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,265 Trac[loader] DEBUG: Loading acct_mgr.db from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,280 Trac[loader] DEBUG: Loading acct_mgr.htfile from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,280 Trac[loader] DEBUG: Loading acct_mgr.http from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,280 Trac[loader] DEBUG: Loading acct_mgr.notification
from c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,280 Trac[loader] DEBUG: Loading acct_mgr.pwhash from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,280 Trac[loader] DEBUG: Loading acct_mgr.svnserve from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,280 Trac[loader] DEBUG: Loading acct_mgr.web_ui from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,280 Trac[loader] DEBUG: Loading acct_mgr.api from
c:\python25\lib\site-packages\tracaccountmanager-0.2.1dev-py2.5.egg
2009-08-10 18:53:33,296 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'], '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'], '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']},
'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']}, '_reset': {'operations':
['reset_workflow'], 'name': 'reset', 'default': 0, 'newstate': 'new',
'oldstates': [], 'permissions': []}}
And here's the output when trying to go to the admin page of Trac:
UnableToLoadObjectError: An error occurred while getting None from the
database: no such table: agilo_sprint
2009-08-10 18:59:23,967 Trac[main] ERROR: Internal Server Error:
Traceback (most recent call last):
File
"c:\python25\lib\site-packages\Trac-0.11.5-py2.5-win32.egg\trac\web\main.py"
, line 444, in _dispatch_request
dispatcher.dispatch(req)
File
"c:\python25\lib\site-packages\Trac-0.11.5-py2.5-win32.egg\trac\web\main.py"
, line 165, in dispatch
for handler in self.handlers:
File
"c:\python25\lib\site-packages\Trac-0.11.5-py2.5-win32.egg\trac\core.py",
line 70, in extensions
return filter(None, [component.compmgr[cls] for cls in extensions])
File
"c:\python25\lib\site-packages\Trac-0.11.5-py2.5-win32.egg\trac\core.py",
line 207, in __getitem__
component = cls(self)
File
"c:\python25\lib\site-packages\Trac-0.11.5-py2.5-win32.egg\trac\core.py",
line 111, in maybe_init
init(self)
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\tick
et\web_ui.py", line 61, in __init__
if AgiloConfig(self.env).is_agilo_enabled:
File
"c:\python25\lib\site-packages\Trac-0.11.5-py2.5-win32.egg\trac\core.py",
line 111, in maybe_init
init(self)
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\util
s\config.py", line 267, in __init__
self.reload()
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\util
s\config.py", line 483, in reload
fields =
AgiloTicketSystem(self.env).get_ticket_fields(new_aliases=self.ALIASES)
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\tick
et\api.py", line 339, in get_ticket_fields
FieldsWrapper(self.env, self._get_ticket_fields(), t_type)
File
"c:\python25\lib\site-packages\Trac-0.11.5-py2.5-win32.egg\trac\ticket\api.p
y", line 266, in _get_ticket_fields
for field in self.get_custom_fields():
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\tick
et\api.py", line 269, in get_custom_fields
fields = super(AgiloTicketSystem, self).get_custom_fields()
File
"c:\python25\lib\site-packages\Trac-0.11.5-py2.5-win32.egg\trac\ticket\api.p
y", line 293, in get_custom_fields
self._custom_fields = self._get_custom_fields()
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\tick
et\api.py", line 296, in _get_custom_fields
self._add_sprint_options(fields)
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\tick
et\api.py", line 288, in _add_sprint_options
field['options'] = [s.name for s in sp_manager.select()]
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\core
\model.py", line 1020, in select
db=db)
File
"c:\python25\lib\site-packages\binary_agilo-1.0_PRO_RC2-py2.5.egg\agilo\core
\model.py", line 792, in select
(obj, to_unicode(e))))
UnableToLoadObjectError: An error occurred while getting None from the
database: no such table: agilo_sprint
2009-08-10 18:59:23,983 Trac[log] DEBUG: [AgiloTicketSystem]: Got new
aliases: {u'requirement': u'Requirement', u'task': u'Task', u'story': u'User
Story', u'bug': u'Bug'}
2009-08-10 18:59:23,983 Trac[log] DEBUG: [Environment]: SELECT => Executing
Query: SELECT description, sprint_end, milestone, name, start, team FROM
agilo_sprint {}
2009-08-10 18:59:23,983 Trac[chrome] DEBUG: Prepare chrome data for request
2009-08-10 18:59:24,000 Trac[log] DEBUG: [AgiloTicketSystem]: Got new
aliases: {u'requirement': u'Requirement', u'task': u'Task', u'story': u'User
Story', u'bug': u'Bug'}
2009-08-10 18:59:24,015 Trac[log] DEBUG: [Environment]: SELECT => Executing
Query: SELECT description, sprint_end, milestone, name, start, team FROM
agilo_sprint {}
What do you suggest I try next? I greatly appreciate your help.
Jeff
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of
Andrea Tomasini
Sent: Thursday, August 06, 2009 11:19 AM
To: [email protected]
Subject: [Agilo for Scrum] Re: Agilo for Scrum 0.8.0 and Agilo Pro Released!
On 6 Aug, 2009, at 16:12 , Jeff Albertine wrote:
> Hey Andrea
Hi Jeff :-)
> I downloaded the windows zip file from Agile42 site, it's named
> binary_agilo-1.0_PRO-py2.5.egg.zip dated 8/5/2009. I copied it into
> my Python25\Scripts folder, and ran easy_install:
>
> C:\Python25\Scripts>easy_install binary_agilo-1.0_PRO-py2.5.egg
> Processing binary_agilo-1.0_PRO-py2.5.egg
> removing 'c:\python25\lib\site-packages\binary_agilo-1.0_PRO-
> py2.5.egg' (and eve
> rything under it)
> creating c:\python25\lib\site-packages\binary_agilo-1.0_PRO-py2.5.egg
> Extracting binary_agilo-1.0_PRO-py2.5.egg to c:\python25\lib\site-
> packages
> binary-agilo 1.0-PRO is already the active version in easy-install.pth
> Installing agilo_svn_hook_commit.py script to c:\Python25\Scripts
> Installing create_agilo_project.py script to c:\Python25\Scripts
>
> Installed c:\python25\lib\site-packages\binary_agilo-1.0_pro-py2.5.egg
> Processing dependencies for binary-agilo==1.0-PRO
> Finished processing dependencies for binary-agilo==1.0-PRO
>
> Then I ran trac-admin for the upgrade:
>
> C:\Python25\Scripts>trac-admin.exe c:\tracprojects\encore upgrade
> Database is up to date, no upgrade necessary.
Before this you need to change the trac.ini and add the:
[components]
agilo.* = enabled
agilo_common.* = enabled
agilo_pro.* = enabled
than do the trac-admin upgrade thing
> Then when I enable Agilo Scrum in the ini file, it gets the same
> database table not found error. I agree there must be something
> wrong in my installation here, but being new at this Python thing
> I'm not sure what to do. Any suggestions? Also, after the
> installation, the plugins on the admin page still name the Agilo
> plugin as RC2. Is that any help?
Could be that you have both versions installed, in which case may
create confusion, have you checked in the /plugins folder of your
project, or in the site-packages of Python? Should be c:\python25\lib
\site-packages according to your log :-)
The best you could do is to enable the logging to DEBUG in the
trac.ini, and try to run the upgrade again, and see if it is logging
something interesting...
[logging]
log_type = file
log_level = DEBUG
log_file = logs/trac.log
Than try to run the upgrade again, clean possibly, that should log out
pretty much :-)
HTH
Best
ANdreaT
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH
http://www.agile42.com and is focused in supporting Agilo for Scrum users.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo?hl=en
-~----------~----~----~----~------~----~------~--~---
