I've hit this limit while trying to import http://www.ncbi.nlm.nih.gov/pubmed/20938251 which has 2010 November/December as date value. Ron, would you be open to increasing the size of the column in the database, or rather filter this data so it fits in the current varchar(16)?

To reproduce, go to node/add/biblio and prepopulate using PubMed with the ID 20938251.

In the meantime I've run ALTER TABLE `biblio` CHANGE `biblio_date` `biblio_date` VARCHAR( 32 ) until there is a fix.

Comments

rjerome’s picture

rjerome commented

I've had a number of requests to change this to an actual "date/time" database field type... maybe now's the time to bite the bullet?

scor’s picture

scor commented

sure, though I'm not sure how the formatter would deal with the different formats like November 2010, 10 November, 2010, 2010 etc. but I bet that should be handled already maybe. In any case it makes sense not to store this as a string but as a date instead.

david lesieur’s picture

david lesieur commented

Marked #1837064: Length of biblio_date field as duplicate.