Failed to update from 7.32 to 7.33
Error message:

block module

Update #7009
Failed: PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column 'title' at row 439: ALTER TABLE {block} CHANGE `title` `title` VARCHAR(255) NOT NULL DEFAULT '' COMMENT 'Custom title for the block. (Empty string will use block default title, will remove the title, text will cause block to use specified title.)'; Array ( ) i db_change_field() (rad 3020 av /home/musienor/public_html/drupaldev/includes/database/database.inc).

php 5.3.29, PHP memory limit 256M, Webbserver: Oderland Apache
Thanks

Comments

he0x410’s picture

he0x410 commented

Hi hstrindb,

Could you please paste "block" table full details info (fields list, type and size) before doing the drupal update?

granholm’s picture

granholm commented

Same problem here. We had NULL in some of the title fields, even though the NOT NULL flag should be set in the database. We solved it by setting NOT NULL to the title field before running the update.

hs@henrikstrindberg.se’s picture

hs@henrikstrindberg.se commented

Thank you, #2 worked!

dcam’s picture

dcam commented
Category: Task » Support request
Status: Active » Fixed

It sounds like this issue was fixed. Thank you @granholm for sharing your solution.

David_Rothstein’s picture

David_Rothstein commented
Status: Fixed » Closed (duplicate)

Actually, let's call it a duplicate of #2378561: block_update_7009 fails with Warning: 1265 Data truncated for column 'title' at row 75 - although it doesn't seem to be a core bug directly, there's a lot of discussion going on in that issue also (more than here even though this issue was older) and if enough people are experiencing it, it might make sense to deal with in core.