Hello, I receive the following error when trying to import some articles using the doi look up.

Data too long for column 'biblio_doi' ........

For some reason in only happens on some articles and not others. The same article can be added correctly using pubmed.

Thanks for your help.

Comments

rjerome’s picture

rjerome commented

Could you post the DOI and PubMed ID that you are using.

apdp300’s picture

apdp300 commented

Hi, thanks, several different articles from different journals do this, the following is an example pasted below. I also pasted the full error message below. When looking up with doi the correct data seems to be found but the error appears when trying to save the node. The doi is obtained correctly when looking up using pubmed and saves without errors. As a possibly separate issue (I don't know if it is related) often when using pubmed look up the doi is not found and often when using doi look up the pmid is not found. In the case of the article below pubmed look up does correctly find the doi however.

Thanks for your work on this.

PMID: 17134316

doi: 10.1162/neco.2007.19.1.1


PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data
too long for column 'biblio_doi' at row 1: INSERT INTO {biblio} (nid,
vid, biblio_type, biblio_other_number, biblio_sort_title,
biblio_secondary_title, biblio_year, biblio_volume, biblio_pages,
biblio_date, biblio_isbn, biblio_abst_e, biblio_url, biblio_issue,
biblio_type_of_work, biblio_accession_number, biblio_call_number,
biblio_short_title, biblio_alternate_title,
biblio_original_publication, biblio_reprint_edition, biblio_section,
biblio_citekey, biblio_coins, biblio_doi, biblio_issn,
biblio_refereed, biblio_md5, biblio_formats) VALUES
(:db_insert_placeholder_0, :db_insert_placeholder_1,
:db_insert_placeholder_2, :db_insert_placeholder_3,
:db_insert_placeholder_4, :db_insert_placeholder_5,
:db_insert_placeholder_6, :db_insert_placeholder_7,
:db_insert_placeholder_8, :db_insert_placeholder_9,
:db_insert_placeholder_10, :db_insert_placeholder_11,
:db_insert_placeholder_12, :db_insert_placeholder_13,
:db_insert_placeholder_14, :db_insert_placeholder_15,
:db_insert_placeholder_16, :db_insert_placeholder_17,
:db_insert_placeholder_18, :db_insert_placeholder_19,
:db_insert_placeholder_20, :db_insert_placeholder_21,
:db_insert_placeholder_22, :db_insert_placeholder_23,
:db_insert_placeholder_24, :db_insert_placeholder_25,
:db_insert_placeholder_26, :db_insert_placeholder_27,
:db_insert_placeholder_28); Array ( [:db_insert_placeholder_0] => 255
[:db_insert_placeholder_1] => 293 [:db_insert_placeholder_2] => 102
[:db_insert_placeholder_3] => [:db_insert_placeholder_4] => MeanDriven
and FluctuationDriven Persistent Activity in Recurren
[:db_insert_placeholder_5] => Neural Computation
[:db_insert_placeholder_6] => 2007 [:db_insert_placeholder_7] =>
19842179617020168120181319 [:db_insert_placeholder_8] => 1 - 46
[:db_insert_placeholder_9] => Jan-01-2007 [:db_insert_placeholder_10]
=> [:db_insert_placeholder_11] => [:db_insert_placeholder_12] =>
[:db_insert_placeholder_13] => 1 [:db_insert_placeholder_14] =>
[:db_insert_placeholder_15] => [:db_insert_placeholder_16] =>
[:db_insert_placeholder_17] => Neural Computation
[:db_insert_placeholder_18] => [:db_insert_placeholder_19] =>
[:db_insert_placeholder_20] => [:db_insert_placeholder_21] =>
[:db_insert_placeholder_22] => 255 [:db_insert_placeholder_23] =>
<span class="Z3988"
title="ctx_ver=Z39.88-2004&amp;rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&amp;rft.atitle=Mean-Driven+and+Fluctuation-Driven+Persistent+Activity+in+Recurrent+Networks&amp;rft.title=Neural+Computation&amp;rft.stitle=Neural+Computation&amp;rft.issn=0899-7667&amp;rft.date=2007&amp;rft.volume=19842179617020168120181319&amp;rft.issue=1&amp;rft.spage=1&amp;rft.epage=46&amp;rft.aulast=Renart&amp;rft.aufirst=Alfonso&amp;rft.au=Moreno-Bote%2C+%C3%A9n&amp;rft.au=Wang%2C+Xiao-Jing&amp;rft.au=Parga%2C+%C3%A9stor&amp;rft_id=info%3Adoi%2F10.1162%2Fneco.2007.19.1.110.1126%2Fscience.275.5297.22110.1088%2F0954-898X%2F8%2F4%2F00310.1093%2Fcercor%2F7.3.23710.1088%2F0954-898X%2F2%2F3%2F00410.1073%2Fpnas.92.9.384410.1073%2Fpnas.88.24.1156910.1023%2FA%3A100892530902710.1088%2F0954-898X%2F11%2F4%2F30210.1162%2F08997669930001617910.1023%2FA%3A101120481432010.1152%2Fjn.01095.200210.1073%2Fpnas.040190610110.1371%2Fjournal.pbio.002026410.1093%2Fcercor%2F10.9.91010.1152%2Fjn.00949.200210.1038%2F916510.1038%2Fnrn119810.1146%2Fannurev.neuro.27.070203.14415210.1126%2Fscience.173.3997.65210.1016%2FS0006-3495%2864%2986768-010.1103%2FPhysRevLett.86.417510.1073%2Fpnas.79.8.255410.1093%2Fcercor%2Fbhh06510.1038%2Fnn139110.1088%2F0954-898X%2F10%2F4%2F30510.1162%2F08997660030001495310.1038%2F331068a010.1103%2FPhysRevLett.89.28810110.1103%2FPhysRevLett.94.08810310.1103%2FPhysRevLett.96.02810110.1016%2FS0896-6273%2803%2900255-110.1038%2F2093910.1038%2F3508601210.1016%2F0959-4388%2894%2990059-010.1162%2F08997669930001651110.1038%2Fnature0161610.1016%2F0306-4522%2894%2990154-610.1073%2Fpnas.94.2.71910.1088%2F0954-898X%2F6%2F2%2F00110.1038%2F3610310.1126%2Fscience.274.5293.172410.1162%2F08997669830001721410.1038%2F65910.1038%2F370140a0"></span>
[:db_insert_placeholder_24] =>
10.1162/neco.2007.19.1.110.1126/science.275.5297.22110.1088/0954-898X/8/4/00310.1093/cercor/7.3.23710.1088/0954-898X/2/3/00410.1073/pnas.92.9.384410.1073/pnas.88.24.1156910.1023/A:100892530902710.1088/0954-898X/11/4/30210.1162/08997669930001617910.1023/A:101120481432010.1152/jn.01095.200210.1073/pnas.040190610110.1371/journal.pbio.002026410.1093/cercor/10.9.91010.1152/jn.00949.200210.1038/916510.1038/nrn119810.1146/annurev.neuro.27.070203.14415210.1126/science.173.3997.65210.1016/S0006-3495(64)86768-010.1103/PhysRevLett.86.417510.1073/pnas.79.8.255410.1093/cercor/bhh06510.1038/nn139110.1088/0954-898X/10/4/30510.1162/08997660030001495310.1038/331068a010.1103/PhysRevLett.89.28810110.1103/PhysRevLett.94.08810310.1103/PhysRevLett.96.02810110.1016/S0896-6273(03)00255-110.1038/2093910.1038/3508601210.1016/0959-4388(94)90059-010.1162/08997669930001651110.1038/nature0161610.1016/0306-4522(94)90154-610.1073/pnas.94.2.71910.1088/0954-898X/6/2/00110.1038/3610310.1126/science.274.5293.172410.1162/08997669830001721410.1038/65910.1038/370140a0
[:db_insert_placeholder_25] => 0899-7667 [:db_insert_placeholder_26]
=> [:db_insert_placeholder_27] => 944860f180e886e05720cca92b9e12a4
[:db_insert_placeholder_28] =>
a:13:{s:13:"biblio_abst_e";s:13:"filtered_html";s:13:"biblio_abst_f";s:13:"filtered_html";s:12:"biblio_notes";s:13:"filtered_html";s:21:"biblio_research_notes";s:13:"filtered_html";s:14:"biblio_custom1";s:13:"filtered_html";s:14:"biblio_custom2";s:13:"filtered_html";s:14:"biblio_custom3";s:13:"filtered_html";s:14:"biblio_custom4";s:13:"filtered_html";s:14:"biblio_custom5";s:13:"filtered_html";s:14:"biblio_custom6";s:13:"filtered_html";s:14:"biblio_custom7";s:13:"filtered_html";s:12:"biblio_coins";s:13:"filtered_html";s:19:"biblio_auth_address";s:13:"filtered_html";}
) in drupal_write_record() (line 7106 of
......includes/common.inc).
rjerome’s picture

rjerome commented
Status: Active » Fixed

OK, I fixed the problem. It turns out that that DOI also has a list of citations each with it's own DOI and they were all concatenated together. The parser will now pick the correct DOI.

http://drupalcode.org/project/biblio.git/commit/9568667

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.