PubMed import fails for long lastnames [#1509872]

PMID: 15557490

String data, right truncated: 1406 Data too long for column 'lastname' at row 1

The 'name' is truncated to 255 in biblio_save_node_validate() but that does not prevent the lastname from being > 128 which is the current size of the varchar of the lastname column.

Proposed solution:
increase the lastname column (and firstname too) to varchar 255.

Comment	File	Size	Author
#1	1509872_1_biblio_long_lastname.patch	732 bytes	scor
#1

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

scor CreditAttribution: scor commented 30 March 2012 at 17:28

File	Size
1509872_1_biblio_long_lastname.patch	732 bytes

In the interim, I'm uploading a patch that limits the name to 128 for those running into the same issue.

Comment #2

rjerome CreditAttribution: rjerome commented 30 March 2012 at 20:01

The underlying issue here is that for "corporate authors", the "name" field is copied to the "lastname" field in biblio_parse_author() in biblio_contributors.inc. This is probably not really necessary, but I'll have to check to see what the ramifications of removing that are.

Comment #3

rjerome CreditAttribution: rjerome commented 30 March 2012 at 20:47

Status:

Active

» Fixed

There were too many issues in trying to deal with corporate authors as a special case (with no lastname value) so I just widened the lastname field to 255 (update 7018).

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

Ron.