RT2 Installation problem: database creation error

RT Users
1

I followed the procedures, when I reached “make install” it gave error
saying Keyword should be NOT NULL in tools/initdb line 160:
Create TABLE KeywordSelects (
…
Keyword integer NULL,
…
INDEX (Keyword),
…
)
I’ve searched your archive and it appears that other people actually
have Keyword integer NOT NULL in their script. Why? What’s the best
way to correct?

Please help!

2

|+ I’ve searched your archive and it appears that other people actually
|+ have Keyword integer NOT NULL in their script. Why? What’s the best
|+ way to correct?

I thought, atleast with MySQL keywords can not be defined as ‘NULL’, but
rather ‘NOT NULL’. During my initial installation, I changed the
schema.mysql to reflect this.

darrin walton, darrinw@nixc.net

3

| I followed the procedures, when I reached “make install” it gave error
| saying Keyword should be NOT NULL in tools/initdb line 160:
±–>8

Your MySQL is out of date (and buggy enough that RT is unlikely to work
properly anyway). Upgrade.

brandon s. allbery [os/2][linux][solaris][freebsd] allbery@kf8nh.apk.net
system administrator [JAPH][WAY too many hats] allbery@ece.cmu.edu
electrical and computer engineering KF8NH
carnegie mellon university [linux: proof of the million monkeys theory]