** Using WeBWorK **

Hello,
Hopefully this isn't me doing something stupid again. When I log in to the admin course I get the following warning and error:

Warning messages

• creating table location_addresses with object WeBWorK::DB::Schema::NewSQL::Std=HASH(0x556d3a0) at /opt/webwork/webwork2/lib/WeBWorK/Utils/CourseManagement.pm line 984.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />Use of uninitialized value in join or string at /opt/webwork/webwork2/lib/WeBWorK/DB/Schema/NewSQL/Std.pm line 814.<br />

Error messages

DBD::mysql::db do failed: Specified key was too long; max key length is 1000 bytes
WeBWorK::Utils::CourseManagement
/opt/webwork/webwork2/lib/WeBWorK/Utils/CourseManagement.pm
985
WeBWorK::DB::Schema::NewSQL::Std::create_table
1





It looks like the error is coming from trying to create the table "location_addresses". I searched the forum and it looked like the previous solution was to upgrade mysql. I'm running the most recent stable version on gentoo though
Do I need something newer? Does anyone know how long this key is or how I can find out? (I'm using version WW2.5).

Thanks for any help!

Update: Turn on database_debug and got some extra info; I've attached the relevant part of the apache log.


I'm not sure what to count, but the longest string in the initial INSERT_INTO looks like 32 characters. Is the problem with the