Problems upgrading 1.0.7 to 2.0.0

hi guys,

i’m getting the following error during a make install of rt-2.0.0:

Creating mysql database rt2.
cp etc/acl.mysql ‘/usr/local/rt/etc/acl.mysql’
/usr/local/bin/perl -p -i -e " s’!!DB_TYPE!!‘mysql’g;
s’!!DB_HOST!!‘localhost’g;
s’!!DB_RT_PASS!!‘My!word%z0t’g;
s’!!DB_RT_HOST!!‘localhost’g;
s’!!DB_RT_USER!!‘rt_user’g;
s’!!DB_DATABASE!!‘rt2’g;" /usr/local/rt/etc/acl.mysql
bin/initacls.mysql ‘/usr/local/mysql’ ‘localhost’ ‘root’ ‘O4Peace’ ‘rt2’
’/usr/local/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for RT
Enter the mysql administrator’s database password to nondestructively
reload the database
/usr/local/bin/perl tools/initdb ‘mysql’ ‘/usr/local/mysql’ ‘localhost’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBD::mysql::st execute failed: Column ‘Keyword’ is used with UNIQUE or
INDEX but is not defined as NOT NULL at tools/initdb line 160,
line 258.
Problem with statement:
CREATE TABLE KeywordSelects (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(255) NULL ,
Keyword integer NULL ,
Single integer NULL ,
Depth integer NOT NULL DEFAULT 0 ,
ObjectType varchar(32) NOT NULL ,
ObjectField varchar(32) NULL ,
ObjectValue varchar(255) NULL ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id),
INDEX (Keyword),
INDEX (ObjectType, ObjectField, ObjectValue)
)

Column ‘Keyword’ is used with UNIQUE or INDEX but is not defined as NOT
NULL at tools/initdb line 162, line 258.
make: *** [initdb.rtuser] Error 255

i’ve just installed mod_perl (as a DSO, built apache ages ago and couldn’t be
bothered doing it again), and make testdeps says nothing out of the ordinary.

rt-1.0.7 continues to work fine… any ideas?

cheers,

Chris

RT 2.0 requires mysql 3.23. You’re running mysql 3.22On Thu, Jul 05, 2001 at 02:45:42PM +0800, Chris Waltham wrote:

hi guys,

i’m getting the following error during a make install of rt-2.0.0:

Creating mysql database rt2.
cp etc/acl.mysql ‘/usr/local/rt/etc/acl.mysql’
/usr/local/bin/perl -p -i -e " s’!!DB_TYPE!!‘mysql’g;
s’!!DB_HOST!!‘localhost’g;
s’!!DB_RT_PASS!!‘My!word%z0t’g;
s’!!DB_RT_HOST!!‘localhost’g;
s’!!DB_RT_USER!!‘rt_user’g;
s’!!DB_DATABASE!!‘rt2’g;" /usr/local/rt/etc/acl.mysql
bin/initacls.mysql ‘/usr/local/mysql’ ‘localhost’ ‘root’ ‘O4Peace’ ‘rt2’
’/usr/local/rt/etc/acl.mysql’
Enter the mysql administrator’s database password to create a new user for RT
Enter the mysql administrator’s database password to nondestructively
reload the database
/usr/local/bin/perl tools/initdb ‘mysql’ ‘/usr/local/mysql’ ‘localhost’
‘rt_user’ ‘rt2’ insert
Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBD::mysql::st execute failed: Column ‘Keyword’ is used with UNIQUE or
INDEX but is not defined as NOT NULL at tools/initdb line 160,
line 258.
Problem with statement:
CREATE TABLE KeywordSelects (
id INTEGER NOT NULL AUTO_INCREMENT,
Name varchar(255) NULL ,
Keyword integer NULL ,
Single integer NULL ,
Depth integer NOT NULL DEFAULT 0 ,
ObjectType varchar(32) NOT NULL ,
ObjectField varchar(32) NULL ,
ObjectValue varchar(255) NULL ,
Disabled int2 NOT NULL DEFAULT 0 ,
PRIMARY KEY (id),
INDEX (Keyword),
INDEX (ObjectType, ObjectField, ObjectValue)
)

Column ‘Keyword’ is used with UNIQUE or INDEX but is not defined as NOT
NULL at tools/initdb line 162, line 258.
make: *** [initdb.rtuser] Error 255

i’ve just installed mod_perl (as a DSO, built apache ages ago and couldn’t be
bothered doing it again), and make testdeps says nothing out of the ordinary.

rt-1.0.7 continues to work fine… any ideas?

cheers,

Chris


rt-users mailing list
rt-users@lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

jesse reed vincent – root@eruditorum.orgjesse@fsck.com
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

pretty soon we’re going to HAVE to have hypertext mail!
–Tim Berners Lee. (8 Jan 1993 on www-talk)

RT 2.0 requires mysql 3.23. You’re running mysql 3.22

Oh, whoops. Didn’t realise. Thanks!

Chris, who promises to RTFM in the future