Dear all,

i'm trying to extract some records from our production server to feed a test server. 

We don't do a complete copy of the production server because it's huge.

The export command

production_server# export [repository] eprint XMLFiles [id1] [id2] [id3] [id4] > [nomefile]

works well and creates the xml file.

The import command

test_server# import [repository] eprint XML [nomefile]

randomly present these errors : 

DBD::mysql::st execute failed: Incorrect integer value: '' for column 'pages' at row 1 at /dati/eprints/bin/../perl_lib/EPrints/Database.pm line 1196.

UPDATE `eprint` SET `userid`=?, `thesis_type`=?, `ispublished`=?, `pages`=?, `status_changed_year`=?, `status_changed_month`=?, `status_changed_day`=?, `status_changed_hour`=?, `status_changed_minute`=?, `status_changed_second`=?, `ils_number`=?, `datestamp_year`=?, `datestamp_month`=?, `datestamp_day`=?, `datestamp_hour`=?, `datestamp_minute`=?, `datestamp_second`=?, `keywords`=?, `gscholar_cluster`=?, `publication_type`=?, `title`=?, `importid`=?, `abstract`=?, `tmid`=?, `type`=?, `metadata_visibility`=?, `lastmod_year`=?, `lastmod_month`=?, `lastmod_day`=?, `lastmod_hour`=?, `lastmod_minute`=?, `lastmod_second`=?, `date_type`=?, `tesi_meritoria`=?, `rev_number`=?, `date_year`=?, `date_month`=?, `date_day`=?, `institution`=?, `succeeds`=?, `capitoli`=?, `commentary`=?, `eprint_status`=?, `sword_depositor`=?, `gscholar_impact`=?, `num_pieces`=?, `bibliografia`=?, `department`=?, `gscholar_datestamp_year`=?, `gscholar_datestamp_month`=?, `gscholar_datestamp_day`=?, `gscholar_datestamp_hour`=?, `gscholar_datestamp_minute`=?, `gscholar_datestamp_second`=?, `full_text_status`=?, `dir`=? WHERE `eprintid`='117': 1366 at /dati/eprints/bin/../perl_lib/EPrints/Database.pm line 1086.

or

DBD::mysql::st execute failed: Incorrect integer value: '' for column 'sword_depositor' at row 1 at /dati/eprints/bin/../perl_lib/EPrints/Database.pm line 1196.

UPDATE `eprint` SET `department`=?, `bibliografia`=?, `dir`=?, `rev_number`=?, `sword_depositor`=?, `tmid`=?, `tesi_meritoria`=?, `lastmod_year`=?, `lastmod_month`=?, `lastmod_day`=?, `lastmod_hour`=?, `lastmod_minute`=?, `lastmod_second`=?, `ils_number`=?, `status_changed_year`=?, `status_changed_month`=?, `status_changed_day`=?, `status_changed_hour`=?, `status_changed_minute`=?, `status_changed_second`=?, `pages`=?, `thesis_type`=?, `ispublished`=?, `publication_type`=?, `title`=?, `gscholar_cluster`=?, `keywords`=?, `num_pieces`=?, `full_text_status`=?, `gscholar_datestamp_year`=?, `gscholar_datestamp_month`=?, `gscholar_datestamp_day`=?, `gscholar_datestamp_hour`=?, `gscholar_datestamp_minute`=?, `gscholar_datestamp_second`=?, `succeeds`=?, `date_year`=?, `date_month`=?, `date_day`=?, `institution`=?, `eprint_status`=?, `commentary`=?, `gscholar_impact`=?, `capitoli`=?, `type`=?, `abstract`=?, `date_type`=?, `metadata_visibility`=?, `userid`=?, `importid`=?, `datestamp_year`=?, `datestamp_month`=?, `datestamp_day`=?, `datestamp_hour`=?, `datestamp_minute`=?, `datestamp_second`=? WHERE `eprintid`='136': 1366 at /dati/eprints/bin/../perl_lib/EPrints/Database.pm line 1086.

It seems that these errors happen when in the xml file  int fields like pages, sword_depositor  or item_issues_count are empty .

Is it normal ?

Best regards,

Paolo Tealdi

Ing. Paolo Tealdi                                                                                                                             ISIAD - Politecnico Torino            

Telefono/Phone : +39-011-0906714 , FAX : +39-011-0906625

Indirizzo/Address : C.so Duca degli Abruzzi,  24 - 10129 Torino - ITALY                     

Please consider your environmental responsibility before printing this e-mail