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.

CommentFileSizeAuthor
#1 1509872_1_biblio_long_lastname.patch732 bytesscor

Comments

scor’s picture

scor commented
StatusFileSize
new 1509872_1_biblio_long_lastname.patch732 bytes

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

rjerome’s picture

rjerome commented

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.

rjerome’s picture

rjerome commented
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.

Status: Fixed » Closed (fixed)

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