Problem building DB


#1

Hi.

Starting with 1-3-20 (and also fresh CVS-checkouts), I get the
following error Message when trying to ‘make install’…

DBD::mysql::st execute failed: Column ‘Name’ is used with UNIQUE or INDEX
but is not defined as NOT NULL at tools/initdb line 65, chunk 2.

Originally I tried ‘make upgrade’ and it worked, but I could not access
tickets, so I thought there might have been changes in the db-layout.

I think, this time I have all the modules up to date (at least testdeps.pl
does not complain).

I also messed around with schema.pl and deleted the NULLs the error
message complained about. I then got this error message:

DBD::mysql::st execute failed: Specified key was too long. Max key length
is 256 at tools/initdb line 65, chunk 2.

Any advice ?

Thanx,
Christian.

Sent through GMX FreeMail - http://www.gmx.net


#2

RT2 requires mysql 3.23. You’re using 3.22 or earlier which used a different
storage engine.

-jOn Tue, Nov 14, 2000 at 06:21:42PM +0100, ChrHenz@gmx.de wrote:

Hi.

Starting with 1-3-20 (and also fresh CVS-checkouts), I get the
following error Message when trying to ‘make install’…

DBD::mysql::st execute failed: Column ‘Name’ is used with UNIQUE or INDEX
but is not defined as NOT NULL at tools/initdb line 65, chunk 2.

Originally I tried ‘make upgrade’ and it worked, but I could not access
tickets, so I thought there might have been changes in the db-layout.

I think, this time I have all the modules up to date (at least testdeps.pl
does not complain).

I also messed around with schema.pl and deleted the NULLs the error
message complained about. I then got this error message:

DBD::mysql::st execute failed: Specified key was too long. Max key length
is 256 at tools/initdb line 65, chunk 2.

Any advice ?

Thanx,
Christian.


Sent through GMX FreeMail - http://www.gmx.net


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

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

<Dr_Memory> the point is that words were exchanged. neurolinguistic
programming will do the rest. they should be showing up at my house
any day now.