World: r3wp

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
);

yes, it's the one that fails. deleting it makes installation work

inserting 8 values but needs 9 values

possibly better to use column names than a values block.

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 ()

I think you should be able to, otherwise you wouldn't be able to 
use VALUES on a table with a primary key

or whatever mysql uses for boolean

but I would prefer if column names were in the query. it's easier 
to read.

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 ...

INSERT INTO users SET
	login		= 'admin',
	pasw		= 'EE10C315EBA2C75B403EA99136F5B48D',
	email		= ['default-:-curecode-:-org'],
	vkey		= '00000000000000000000000000000000',
	vdate		= NOW(),
	role		= 4,
	created	= NOW();

This works.

Just missing the deleted column

and modified

there must be other places where users are added ...

not sure they are needed. now onto how to make curecode log into 
mysql

yeah ... redundant fields :)

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.

it's cheyenne

it will be in the Cheyenne cfg

httpd.cfg

I see.

well, I'm guessing ...

I've added that now, but Cheyenne is just outputting things the browser 
won't understand.

http://97.107.135.89/bugs/index.rsp

that means there is an error

this was also present before I changed the httpd config, so there 
must be a different error somewhere.

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

it's not relevant what the database name is

found an error message. decoding it...

it should be in plain text ..

either 'sess, 'validate or 'request is none where they shouldn't 
be

well... did you login ?

so that you have a validated session?

no, but no pages are working at all, so I can't log in.

what's your database string?

just [root-:-localhost], but I don't think this is a database problem. 
it's more fundamental.

I'll try it out ... now where to download mysql ..

http://dev.mysql.com/downloads/mysql/5.1.html#win32

Database string should be root:<password>@localhost/r3bugs

Looks like the install.r script hasn't been updated to match latest 
database schema.

we guessed that :)

as suspected, it didn't help to alter the db string.

I'm curious why this error doesn't appear in the browser.