… data. This brings up a possible issue with bin/authors.pl as it only adds/updates author data for existing releases. When a brand-new author uploads a dist, they will not be in that table after the indexing. Will have to investigate further.
DBI Exception: DBD::mysql::st execute failed: Cannot add or update a child row: a foreign key constraint fails (`cpanchanges`.`distribution_release`, CONSTRAINT `distribution_release_fk_author` FOREIGN KEY (`author`) REFERENCES `author` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) [for Statement "INSERT INTO distribution_release ( author, ctime, dist_timestamp, distribution, mtime, version) VALUES ( ?, ?, ?, ?, ?, ? )" with ParamValues: 0='AADLER', 1='2012-11-24 00:18:28', 2='2006-01-30 20:52:20', 3='Games-LogicPuzzle', 4='2012-11-24 00:18:28', 5='0.20'] Also, this rename the table release to distribution_release where needed.
MySQL have a hard limit on the size of the index for InnoDB (767 bytes). Since the table use the utf8 charset, that let us only 255 characters for our keys. By reducing the size of the column `distribution`, `author` and `version`, we can fit in this constraint. In the current database, the longest version number is 18 characters long, the longest distribution name is 122 characters, and the length for the authors's ID is 50.