[rt-users] Problems upgrading 1.0.7 to 2.0.0

[Jesse]

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


On 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, <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
> 
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at 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)