[rt-users] Problems upgrading 1.0.7 to 2.0.0

[Chris Waltham]

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, <SCHEMA> 
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, <SCHEMA> 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