mySQL DB create error

Hi,

I’m having a problem with installing RT-2.0.11 … I’ve all the Perl
Modules installed, apache compiled with mod_perl, etc … I can get as
far as the RT login page

The problem is with the creation of the DB on mySQL. I’ve running mySQL
on a Solaris 8 and RT (apache) is running on a Linux box … bellow is
the error I get after running “make install”


Now populating database schema.
Enter the mysql password for rt_user:
Creating database schema.
DBD::mysql::st execute failed: Colum ‘Keyword’ is used with UNIQUE or
INDEX but is not defined as NOT NULL at tool/initdb line 166,
line 268.
Problem with statement:
CREATE INDEX KeywordSelects1 ON KeywordSelects (Keyword)

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

So, the DB gets created, and the table (at least 1) gets created, when
you look at the mySQL server.

Any ideas?

cheers
E

Eoin Verling _/ _ 5300 Cork Airport Business Park,
SysAdmin / _/ \ Kinsale Rd., Cork, Ireland.
Comnitel Technologies _/ _/ Ph: +353 21 7306008
everling@comnitel.com _/ Fax: +353 21 7306024

DBD::mysql::st execute failed: Colum ‘Keyword’ is used with UNIQUE or
INDEX but is not defined as NOT NULL at tool/initdb line 166,
line 268.
Problem with statement:
CREATE INDEX KeywordSelects1 ON KeywordSelects (Keyword)

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

The above is a MySQL error message. Which version of MySQL are you using?

Regards,

                         Bruce Campbell                            RIPE
               Systems/Network Engineer                             NCC
             www.ripe.net - PGP562C8B1B                      Operations

DBD::mysql::st execute failed: Colum ‘Keyword’ is used with UNIQUE or
INDEX but is not defined as NOT NULL at tool/initdb line 166,
line 268.
Problem with statement:
CREATE INDEX KeywordSelects1 ON KeywordSelects (Keyword)

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

The above is a MySQL error message. Which version of MySQL are you using?

It’s mySQL version 7.11, distribution 3.22.26a, for sparc/solaris.

E

Eoin Verling _/ _ 5300 Cork Airport Business Park,
SysAdmin / _/ \ Kinsale Rd., Cork, Ireland.
Comnitel Technologies _/ _/ Ph: +353 21 7306008
everling@comnitel.com _/ Fax: +353 21 7306024

DBD::mysql::st execute failed: Colum ‘Keyword’ is used with UNIQUE or
INDEX but is not defined as NOT NULL at tool/initdb line 166,
line 268.
Problem with statement:
CREATE INDEX KeywordSelects1 ON KeywordSelects (Keyword)

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

The above is a MySQL error message. Which version of MySQL are you using?

Hi,

Yes, it was the mySQL version. I upgraded to the latest version and that
error dissappears. I have it up a running now.

thanks for the help

E

Eoin Verling _/ _ 5300 Cork Airport Business Park,
SysAdmin / _/ \ Kinsale Rd., Cork, Ireland.
Comnitel Technologies _/ _/ Ph: +353 21 7306008
everling@comnitel.com _/ Fax: +353 21 7306024