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

World: r3wp

[!CureCode] web-based bugtracking tool

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
[559x4]
INSERT INTO users VALUES (
	'admin',
	'EE10C315EBA2C75B403EA99136F5B48D',
	['default-:-curecode-:-org'],
	'00000000000000000000000000000000',
	NOW(),
	4, false, 
	NOW(), NOW()
);
something like that ... I suspect
change the email of course
yes, standard RT syntax includes column names


{insert into users ( login, pasw, email, vkey, vdate, role, deleted, 
created, modified ) values (? ... etc ) }  admin EE... blah ...
Henrik
30-Aug-2009
[563]
INSERT INTO users SET
	login		= 'admin',
	pasw		= 'EE10C315EBA2C75B403EA99136F5B48D',
	email		= ['default-:-curecode-:-org'],
	vkey		= '00000000000000000000000000000000',
	vdate		= NOW(),
	role		= 4,
	created	= NOW();

This works.
Graham
30-Aug-2009
[564x3]
Just missing the deleted column
and modified
there must be other places where users are added ...
Henrik
30-Aug-2009
[567]
not sure they are needed. now onto how to make curecode log into 
mysql
Graham
30-Aug-2009
[568]
yeah ... redundant fields :)
Henrik
30-Aug-2009
[569]
one would think, there would be a login to the database somewhere 
in the code. can't find it though. there is one in some test files 
and in the installer.
Graham
30-Aug-2009
[570x3]
it's cheyenne
it will be in the Cheyenne cfg
httpd.cfg
Henrik
30-Aug-2009
[573]
I see.
Graham
30-Aug-2009
[574]
well, I'm guessing ...
Henrik
30-Aug-2009
[575x2]
I've added that now, but Cheyenne is just outputting things the browser 
won't understand.
http://97.107.135.89/bugs/index.rsp
Graham
30-Aug-2009
[577]
that means there is an error
Henrik
30-Aug-2009
[578]
this was also present before I changed the httpd config, so there 
must be a different error somewhere.
Graham
30-Aug-2009
[579x3]
because there is an error, the gzipped stuff sent to the browser 
can not be decodoed
so check the trace.log
just use r3bugs as your database handle