Hey Andrea, I fixed it myself, you don't need to work up a solution to this
situation. I ended up reading the db1.py thru db4.py update scripts,
figured out what it was doing, added the missing tables and other mods to
the trac.db file using sqlite3. I think that the installation code assumed
the first installation was 0.6 and all updates had been properly applied
since then. I started somewhere in the middle apparently, so there were a
lot of tables missing. I believe the installation code should be made a bit
more bulletproof, I'm not the only noob out here :-)
For the record, here's the proper Agilo Pro 1.0.1 database schema:
CREATE TABLE agilo_backlog (
name text PRIMARY KEY,
b_type integer,
description text,
ticket_types text,
sorting_keys text,
b_strict integer
);
CREATE TABLE agilo_backlog_ticket (
name text,
pos integer,
scope text,
level integer,
ticket_id integer,
UNIQUE (name,pos,scope)
);
CREATE TABLE agilo_burndown (
task_id integer,
date integer,
remaining_time real,
UNIQUE (task_id,date)
);
CREATE TABLE agilo_calendar_entry (
date integer,
teammember text,
hours real,
UNIQUE (date,teammember)
);
CREATE TABLE agilo_contingent (
name text,
sprint text,
amount real,
actual real,
UNIQUE (name,sprint)
);
CREATE TABLE agilo_link (
src integer,
dest integer,
UNIQUE (src,dest)
);
CREATE TABLE agilo_sprint (
name text,
description text,
start integer,
sprint_end integer,
milestone text,
team text,
UNIQUE (name)
);
CREATE TABLE agilo_team (
name text,
description text,
UNIQUE (name)
);
CREATE TABLE agilo_team_member (
name text,
team text,
description text,
ts_mon real,
ts_tue real,
ts_wed real,
ts_thu real,
ts_fri real,
ts_sat real,
ts_sun real,
UNIQUE (name)
);
CREATE TABLE agilo_team_metrics_entry (
team text,
sprint text,
metrics_key text,
UNIQUE (team,sprint,metrics_key)
);
-----Original Message-----
From: Jeff Albertine [mailto:j...@jeffalbertine.com]
Sent: Tuesday, August 11, 2009 2:46 PM
To: 'agilo@googlegroups.com'
Subject: RE: [Agilo for Scrum] Re: Agilo for Scrum 0.8.0 and Agilo Pro
Released!
OK, I ran sqlite3 and got the schema of the trac.db file:
CREATE TABLE agilo_backlog (
name text PRIMARY KEY,
b_type integer,
description text,
ticket_types text,
sorting_keys text,
b_strict integer
);
CREATE TABLE agilo_backlog_ticket (
name text,
pos integer,
scope text,
level integer,
ticket_id integer,
UNIQUE (name,pos,scope)
);
CREATE TABLE agilo_burndown (
task_id integer,
date integer,
remaining_time real,
UNIQUE (task_id,date)
);
CREATE TABLE agilo_link (
src integer,
dest integer,
UNIQUE (src,dest)
);
CREATE TABLE attachment (
type text,
id text,
filename text,
size integer,
time integer,
description text,
author text,
ipnr text,
UNIQUE (type,id,filename)
);
CREATE TABLE auth_cookie (
cookie text,
name text,
ipnr text,
time integer,
UNIQUE (cookie,ipnr,name)
);
CREATE TABLE component (
name text PRIMARY KEY,
owner text,
description text
);
CREATE TABLE enum (
type text,
name text,
value text,
UNIQUE (type,name)
);
CREATE TABLE milestone (
name text PRIMARY KEY,
due integer,
completed integer,
description text
);
CREATE TABLE node_change (
rev text,
path text,
node_type text,
change_type text,
base_path text,
base_rev text,
UNIQUE (rev,path,change_type)
);
CREATE TABLE permission (
username text,
action text,
UNIQUE (username,action)
);
CREATE TABLE report (
id integer PRIMARY KEY,
author text,
title text,
query text,
description text
);
CREATE TABLE revision (
rev text PRIMARY KEY,
time integer,
author text,
message text
);
CREATE TABLE session (
sid text,
authenticated integer,
last_visit integer,
UNIQUE (sid,authenticated)
);
CREATE TABLE session_attribute (
sid text,
authenticated integer,
name text,
value text,
UNIQUE (sid,authenticated,name)
);
CREATE TABLE system (
name text PRIMARY KEY,
value text
);
CREATE TABLE ticket (
id integer PRIMARY KEY,
type text,
time integer,
changetime integer,
component text,
severity text,
priority text,
owner text,
reporter text,
cc text,
version text,
milestone text,
status text,
resolution text,
summary text,
description text,
keywords text
);
CREATE TABLE ticket_change (
ticket integer,
time integer,
author text,
field text,
oldvalue text,
newvalue text,
UNIQUE (ticket,time,field)
);
CREATE TABLE ticket_custom (
ticket integer,
name text,
value text,
UNIQUE (ticket,name)
);
CREATE TABLE version (
name text PRIMARY KEY,
time integer,
description text
);
CREATE TABLE wiki (
name text,
version integer,
time integer,
author text,
ipnr text,
text text,
comment text,
readonly integer,
UNIQUE (name,version)
);
CREATE INDEX node_change_rev_idx ON node_change (rev);
CREATE INDEX revision_time_idx ON revision (time);
CREATE INDEX session_authenticated_idx ON session (authenticated);
CREATE INDEX session_last_visit_idx ON session (last_visit);
CREATE INDEX ticket_change_ticket_idx ON ticket_change (ticket);
CREATE INDEX ticket_change_time_idx ON ticket_change (time);
CREATE INDEX ticket_status_idx ON ticket (status);
CREATE INDEX ticket_time_idx ON ticket (time);
CREATE INDEX wiki_time_idx ON wiki (time);
How do we get it to really create the table(s)?
Jeff
-----Original Message-----
From: agilo@googlegroups.com [mailto:ag...@googlegroups.com] On Behalf Of
Andrea Tomasini
Sent: Tuesday, August 11, 2009 12:38 PM
To: agilo@googlegroups.com
Subject: [Agilo for Scrum] Re: Agilo for Scrum 0.8.0 and Agilo Pro Released!
On 11 Aug, 2009, at 1:02 , Jeff Albertine wrote:
> Andrea -
I Jeff :-)
> (sorry for the delay, been out of town for a while)
No problem I am always out of town ;-)
> 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:
All the plugins seem to be loaded with no error... which is good ;-)
> 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
This is pretty much a clear error, the table is not there... the
question is how is it possible that the table was not created during
the update process... anyway can you verify opening the SQLite DB
which tables are there? You can run the command .schema from SQLite
prompt.
The should be a lot of tables starting with agilo_ we need to find out
if no table was created, or only that table wasn't created, and in
case why...
> What do you suggest I try next? I greatly appreciate your help.
HTH
> Jeff
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 agilo@googlegroups.com
To unsubscribe from this group, send email to
agilo+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/agilo?hl=en
-~----------~----~----~----~------~----~------~--~---
