Hello, I upgraded our agilo system ((very old: still trac 0.10.5 and multiple agilo lib like agilo_sprint_data-1.2_r388-py2.4.egg ). So we installed a new version and created a new project (initenv) and then I imported the data from the old to the new one.
I updated the following data in DB to conform to new Agilo db structure: -- we were using defect instead of bug update ticket set type='bug' where type ='defect'; -- create a sprint for each milestone(in old agilo only milestone was existing) insert into agilo_sprint (milestone, name, sprint_end) select name, name, due from milestone; update agilo_sprint set s.start = (select max(due) from milestone where due < s.sprint_end); -- link US to sprint insert into ticket_custom(ticket, name, value) select id, 'sprint', milestone from ticket where type ='story' or type='bug'; -- remove milestone from TASK update ticket set milestone = null where type = 'task'; My problem is that when I select a Sprint backlog only Req, US and Bug are displayed but the Tasks are not. I checked the linking and it's OK. Is there any data inconsistency that may prevent listing the task? I cross-checked also the config according https://dev.agile42.com/wiki/agilo/users/FindingErrors but it's OK as well. If it is of any help, this is some db extract agilo.db=# select * from ticket where id in (4948, 4949, 5826); id | type | time | changetime | component | severity | priority | owner | reporter | cc | version | milestone | status | resolution | summary | description | keywords ------+-------------+------------+------------+-----------+---------- +----------+----------+----------+----+---------+-----------+-------- +------------ +---------------------------------------------------------------------------------------- +------------------------------------------------------------------------------------------------------------------------------------ +---------- 4948 | requirement | 1271692831 | 1287143881 | | | minor | user1 | user2| | | 3.3.1 | new | | req name | Text removed. | 5826 | task | 1280496366 | 1287143942 | | | minor | | user1| | | | new | | task title | I Text removed. 4949 | story | 1271693005 | 1287143899 | | | minor | user1 | user2| | | | new | | us title | (3 rows) agilo.db=# select * from ticket_custom where ticket in (4948, 4949, 5826); ticket | name | value --------+----------------+-------- 5826 | remaining_time | 4 5826 | drp_resources | 4948 | story_priority | Linear 4949 | story_priority | Linear 4949 | rd_points | 3 4948 | businessvalue | 3005 4949 | sprint | 3.3.1 (7 rows) agilo.db=# select * from agilo_link where src in (4948, 4949, 5826) or dest in (4948, 4949, 5826) order by src; src | dest ------+------ 4948 | 4949 4949 | 5826 (2 rows) Any idea on the problem? -- Follow Agilo on Twitter: http://twitter.com/agiloforscrum Please support us by reviewing and voting on: http://userstories.com/products/8-agilo-for-scrum http://ohloh.net/p/agilo-scrum http://freshmeat.net/projects/agiloforscrum You have received this message because you are subscribed to the "Agilo for Scrum" Google Group. This group is focused on supporting Agilo for Scrum users and is moderated by Agilo Software GmbH <http://www.agiloforscrum.com>. To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [email protected] For more options, visit this group at http://groups.google.com/group/agilo
