<div dir="ltr"><span style="color:rgb(31,73,125)">Hi,<br></span><div><span style="color:rgb(31,73,125)"><br></span>I answered my own question. I used this tip <<a href="https://github.com/eprints/eprints/issues/188">https://github.com/eprints/eprints/issues/188</a>> and I patched the file /perl_lib/IRStats/DatabaseInterface/<a href="http://mysql.pm">mysql.pm</a> (a "homemade" patch). I add ENGINE=MyISAM<br>
<br>///////////////////////////////////////<br> my $index_id = "irs_".$set_id."_eprintid";<br> $self->do("CREATE TABLE IF NOT EXISTS `$table` (`set_member_id` INT, `eprint_id` INT, PRIMARY KEY (`set_member_id`,`eprint_id`), INDEX `$index_id` (eprint_id)) ENGINE=MyISAM");<br>
$self->do("CREATE TABLE IF NOT EXISTS `$citation_table` (`set_member_id` INT, `short_citation` TINYTEXT, `full_citation` TEXT, `url` TEXT, PRIMARY KEY (`set_member_id`)) ENGINE=MyISAM");<br> $self->do("CREATE TABLE IF NOT EXISTS `$code_table` (`set_member_code` VARCHAR(128), `set_member_id` INT, PRIMARY KEY (`set_member_code`(128))) ENGINE=MyISAM");<br>
///////////////////////////////////////<br><br><br><br></div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, Feb 18, 2014 at 1:40 PM, Centro de Documentación <span dir="ltr"><<a href="mailto:cendocu@gmail.com" target="_blank">cendocu@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div><div>Hi,<br><br>When I tried to run update-metadata I got the following error message. update_table works fine.<br>
<br></div>Any clue?<br><br></div>Regards, Cristian<br><div><div><br>eprints@eprints:~$ ./cgi/irstats.cgi nulan update_metadata --verbose<br>
UNIVERSAL->import is deprecated and will be removed in a future perl at /usr/share/eprints3/perl_lib/IRStats/Params.pm line 4<br>Reading eprint ids<br>Reading eprint citations and groups<br>Adding field 'Divisions' as set<br>
Adding field 'Subjects' as set<br>Adding field 'Autores' as set<br>IMPORTING GROUPS: subjects, creators_name, divisions, eprint<br>--subjects--<br>DBD::mysql::db do failed: Table './nulan/irs_set_subjects' already exists at /usr/share/eprints3/perl_lib/IRStats/DatabaseInterface.pm line 609.<br>
Execution of -- RENAME TABLE `irs_set_subjects` TO `irs_set_subjects_old`,`irs_set_subjects_new` TO `irs_set_subjects` () -- failed: Table './nulan/irs_set_subjects' already exists<br> at /usr/share/eprints3/perl_lib/IRStats/DatabaseInterface.pm line 609<br>
IRStats::DatabaseInterface::do('IRStats::DatabaseInterface::mysql=HASH(0x142ff58)', 'RENAME TABLE `irs_set_subjects` TO `irs_set_subjects_old`,`ir...') called at /usr/share/eprints3/perl_lib/IRStats/DatabaseInterface/<a href="http://mysql.pm" target="_blank">mysql.pm</a> line 212<br>
IRStats::DatabaseInterface::mysql::rename_tables('IRStats::DatabaseInterface::mysql=HASH(0x142ff58)', 'irs_set_subjects', 'irs_set_subjects_old', 'irs_set_subjects_new', 'irs_set_subjects') called at /usr/share/eprints3/perl_lib/IRStats/CLI/<a href="http://update_metadata.pm" target="_blank">update_metadata.pm</a> line 313<br>
IRStats::CLI::update_metadata::write_to_database('IRStats::CLI::update_metadata=HASH(0x147cfa8)', 'HASH(0x62d7d48)') called at /usr/share/eprints3/perl_lib/IRStats/CLI/<a href="http://update_metadata.pm" target="_blank">update_metadata.pm</a> line 38<br>
IRStats::CLI::update_metadata::execute('IRStats::CLI::update_metadata=HASH(0x147cfa8)') called at /usr/share/eprints3/perl_lib/IRStats/CLI.pm line 62<br> IRStats::CLI::handler() called at /usr/share/eprints3/perl_lib/IRStats.pm line 73<br>
IRStats::handler() called at ./cgi/irstats.cgi line 22<br><br></div></div></div>
</blockquote></div><br></div>