eprints_tech messages

http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
*** EPrints community wiki - http://wiki.eprints.org/
In EP 3.1 you should be able to do this:

./bin/epadmin update_database_structure [repoid]

That will look around your database for any missing columns.

All the best,
Tim.

On Wed, 2009-07-01 at 13:55 +0200, Michele Pinassi wrote:
> http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech
> *** EPrints community wiki - http://wiki.eprints.org/
> Hi all, i've followed those instructions
> -http://wiki.eprints.org/w/Adding_a_Field_to_a_Live_Repository- to add
> some new fields to my live archive (Eprints 3.1.3). In detals, i've
> added fields to "eprints" and "eprints_ordervalues_it" ↵
tables, creating
> definitions and so on. Furthermore, that new fields are corrcetly showed
> in workflows and in advaced search page. 
> 
> The problem is in Import module. While importing new documents in
> "Pubmed XML" ("Test only" was OK, i'm referring to ↵
"Test and Import") i
> got:
> 
> Unhandled warning in Import::PubMedXML: DBD::mysql::st execute failed:
> Unknown ↲ column 'isi_status' in 'field list'
> at /opt/eprints3/perl_lib/EPrints/Database.↲ pm line 1178.
>  at /opt/eprints3/perl_lib/EPrints/Database.pm line 1178
>         ↵
EPrints::Database::insert('EPrints::Database::mysql=HASH(0xb8b568c)',
> '↲ eprint__ordervalues_en', 'ARRAY(0x85bdfe4)', 'ARRAY(0x85be008)')
> called at /opt↲ /eprints3/perl_lib/EPrints/Index.pm line 327
>         ↵
EPrints::Index::_do_ordervalues('EPrints::Session=HASH(0xadd31e8)',
> 'EP↲ rints::DataSet=HASH(0xb0ce57c)', 'HASH(0xb94d690)', 1, 'undef')
> called at /opt/↲ eprints3/perl_lib/EPrints/Index.pm line 284
>         ↵
EPrints::Index::insert_ordervalues('EPrints::Session=HASH(0xadd31e8)',
> ↲ 'EPrints::DataSet=HASH(0xb0ce57c)', 'HASH(0xb94d690)') called
> at /opt/eprints3/↲ perl_lib/EPrints/Database.pm line 1515
>         ↵
EPrints::Database::update('EPrints::Database::mysql=HASH(0xb8b568c)',
> '↲ EPrints::DataSet=HASH(0xb0ce57c)', 'HASH(0xb94d690)', 1) called
> at /opt/eprints↲ 3/perl_lib/EPrints/Database.pm line 1281
>         EPrints::Database::ad ...
> 
> As you can see, "isi_status" is one of the new fields added by ↵
me. 
> 
> Any hints/suggestions how to fix that ?
> 
> Thanks, Michele
> 

eprints_tech messages

[EP-tech] Re: Adding new field to live archive