r3wp [groups: 83 posts: 189283]
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search
 

World: r3wp

[!CureCode] web-based bugtracking tool

Anton
6-Aug-2009
[510]
Hey Doc, is this picture of CureCode schema still current ?
http://softinnov.org/dl/DB-schema.png
Janko
6-Aug-2009
[511]
nice, what's this "drawn" in?
Anton
6-Aug-2009
[512]
Doc said 27-Aug-2008 in this group "Microsoft Visio"
Dockimbel
6-Aug-2009
[513x2]
Nope, the schema was changed a little for R3 specific needs.
I didn't had the time yet to update the picture.
Anton
6-Aug-2009
[515]
I'm interested in the "logs" table. It records changes to tickets 
once they are created, right?
Dockimbel
6-Aug-2009
[516]
Right, it records every event for each ticket (including creation).
Anton
6-Aug-2009
[517x3]
If a new project is created, does that go into the logs table?
(as an example).
In the "tickets" table, there are several foreign key fields of INT(8) 
which link to tables with ids of INT(16), eg. severities.
Is that just an oversight?
Dockimbel
6-Aug-2009
[520x2]
New project => not logged, only tickets info are logged.
That's a typo, it should be INT(16).
Anton
6-Aug-2009
[522x2]
Ok, that makes sense. So does the "field" field of the logs table 
tell which field of the tickets table was changed?
If so, then when several fields of a ticket are changed at once, 
does that generate several log entries in the logs table?
BrianH
6-Aug-2009
[524]
That is what the log at the bottom of the ticket shows, Anton.
Dockimbel
6-Aug-2009
[525]
Yes, each field changed generates a new log entry.
Anton
6-Aug-2009
[526]
Thanks, it is clear to me, now.
Henrik
9-Aug-2009
[527]
Are the changes to the API? I'm downloading the bug list from the 
API, but the column order does not correspond to what is in the docs. 
Also the column order is not mentioned in the docs.
Dockimbel
10-Aug-2009
[528x2]
API hasn't changed. Do you have an example URL? I don't see any difference 
in column order. Btw, I've just released a fix for a bug in the type=ticket 
mode throwing an error if the 'fixedin field was none.
Looks like you were talking about the "user" column that don't appear 
in the docs? I need to update CureCode's wiki.
Henrik
10-Aug-2009
[530]
updating the docs might solve the problem, so I'll wait with further 
action until that is updated.
Dockimbel
17-Aug-2009
[531]
For CureCode users: do you guys think that a project-wide timeline 
page like the following one would be useful? http://www.sqlite.org/cvstrac/timeline
Henrik
17-Aug-2009
[532]
yes, I think that could be useful
Sunanda
19-Aug-2009
[533]
Everyone responds to different stats and/or different presentations 
of them. So the more ways to view the data sets the better.
Gregg
21-Aug-2009
[534]
Yes, I think so Doc.
Pekr
21-Aug-2009
[535]
CureCode reports, we have 888 closed tickets for R3.0 - good number 
:-)
Will
21-Aug-2009
[536]
makes us all very happy 8-)8-)8-)
Henrik
30-Aug-2009
[537]
Curecode 099 is not available for download on curecode.org. Is that 
on purpose?
Graham
30-Aug-2009
[538]
Is doc releasing updates to CC?
Henrik
30-Aug-2009
[539]
098 is available, but 099 is not
Graham
30-Aug-2009
[540]
Perhaps doc should consider moving curecode's source to google.  
Certainly it has helped having Cheyenne there.
Henrik
30-Aug-2009
[541x3]
looks to me that curecode 098 is hardwired for the R3 bug list. there 
is a ton of references to R3 in it.
Ah, only the database name is r3bugs. I think it would be relatively 
easy to move into a config?
using install.r, I get the following error:

CureCode Installation...
...loading MySQL protocol
Script: "MySQL Protocol" (12-Jul-2008)
MySQL protocol loaded
...creating database
...database root Password: *******
connecting to: localhost
...access ok to database
...creating tables

** User Error: ERROR 1136 : Column count doesn't match value count 
at row 1
** Near: make error! info
Graham
30-Aug-2009
[544]
what's the sql?
Henrik
30-Aug-2009
[545]
trying to figure that out now
Graham
30-Aug-2009
[546x3]
INSERT INTO users VALUES (
	NULL,
	'admin',
	'EE10C315EBA2C75B403EA99136F5B48D',
	['default-:-curecode-:-org'],
	'00000000000000000000000000000000',
	NOW(),
	4,
	NOW()
);
is the one with the most inserts !
CREATE TABLE users (
	id		INT(16) 	 PRIMARY KEY AUTO_INCREMENT,
	login	VARCHAR(32)  NOT NULL,
	pasw	VARCHAR(32)  NOT NULL,
	email	VARCHAR(128) NOT NULL,
	vkey	VARCHAR(32)	 DEFAULT NULL,
	vdate	DATETIME 	 DEFAULT NULL,
	role	INT(8)  	 NOT NULL,
	deleted	BOOL		 NOT NULL,
	created	DATETIME 	 NOT NULL,
	modified DATETIME
);
Henrik
30-Aug-2009
[549]
yes, it's the one that fails. deleting it makes installation work
Graham
30-Aug-2009
[550]
inserting 8 values but needs 9 values
Henrik
30-Aug-2009
[551]
possibly better to use column names than a values block.
Graham
30-Aug-2009
[552x4]
null shouldn't be the first value
admin should be first as that corresponds to login
I presume you can't insert into a primary key auto_increment field
now (), 4, false, now(), now ()
Henrik
30-Aug-2009
[556]
I think you should be able to, otherwise you wouldn't be able to 
use VALUES on a table with a primary key
Graham
30-Aug-2009
[557]
or whatever mysql uses for boolean
Henrik
30-Aug-2009
[558]
but I would prefer if column names were in the query. it's easier 
to read.
Graham
30-Aug-2009
[559]
INSERT INTO users VALUES (
	'admin',
	'EE10C315EBA2C75B403EA99136F5B48D',
	['default-:-curecode-:-org'],
	'00000000000000000000000000000000',
	NOW(),
	4, false, 
	NOW(), NOW()
);