Hi,
When importing via the articles and issues XML plugin, I get the following error (from debug output):
(postgres7): INSERT INTO article_supplementary_files
(remote_url, file_id, article_id, type, date_created, language, show_reviewers, date_submitted, seq)
VALUES
(?, ?, ?, ?, '1990-01-01', ?, ?, '2016-03-23 12:13:47', ?)
[ (0=>'') (1=>'22906') (2=>'8941') (3=>'') (4=>'en') (5=>'') (6=>'0') ]
-1: ERROR: invalid input syntax for integer: ""
It looks like the show_reviewers field is causing the error (5=>’’ should be an integer), but I can’t find this anywhere in the input XML file. Also, our sequences seem ok in the article_supplementary_files table:
Column | Type | Modifiers
----------------±----------------------------±------------------------------------------------------------------------------
supp_id | integer | not null default nextval(‘article_supplementary_files_supp_id_seq’::regclass)
Not sure where to go from here - any suggestions?
All supplemental_file nodes have a type attribute with value “other”.
The import file itself is 22MB(!), could this be the problem?
Thanks,
Gary