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

World: r3wp

[!CureCode] web-based bugtracking tool

Henrik
26-Jul-2009
[501]
For a long while, "Most Recent Reports" and "Recent Changes" produced 
identical results here, but works properly now. Is that part of the 
fixes above?
Dockimbel
26-Jul-2009
[502x2]
It's not in my Changelog, so maybe I did the fix but forgot to note 
it.
As this release marks the end of the "quirk mode" era for CureCode, 
you may found some minor rendering issues here and there. If you 
think that it has to be fixed, please report it here.
Henrik
26-Jul-2009
[504]
is there a status on the API?
Dockimbel
26-Jul-2009
[505]
The API hasn't changed since the first release. I guess that no one 
is using it.
Henrik
26-Jul-2009
[506]
I might give it a shot at some point. We also need an R3 native client 
to connect to it eventually, so I might want some practice.
BrianH
26-Jul-2009
[507]
Category order setting works great. The new layout has more padding 
on Chrome than it did before (I may be wrong about that), but looks 
good to me. Great stuff! :)
BrianH
27-Jul-2009
[508]
Today, CureCode on Chrome looks like it does on Firefox: No extra 
padding, white grid separators, nice. Must have been a cache issue 
yesterday. Good work, Doc :)
Dockimbel
27-Jul-2009
[509]
Thanks to the new CSS, the look is now consistent across Chrome / 
FF / IE7, but I gave up on trying to hack the CSS to make IE8 render 
pages as the others. The time spent in making all browser render 
the same way is quite insane.
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