PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'delta' at row 1 [#1459884]

I created a Facebook social like box that had a very long name by accident and I also enabled the block display. If I go now on the blocks page I get this error, and also I am unable to edit the title of this social plugin.
Full error

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'delta' at row 1: INSERT INTO {block} (module, delta, theme, status, weight, region, pages) 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); Array ( [:db_insert_placeholder_0] => fb_social [:db_insert_placeholder_1] => Royal Crème on FacebookRoyal Crème Royal Crème [:db_insert_placeholder_2] => corolla [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => -1 [:db_insert_placeholder_6] => ) in drupal_write_record() (line 6975 of /nfs/c03/h03/mnt/53452/domains/royalcreme.com/html/includes/common.inc).

Comments

Comment #1

amfriedman CreditAttribution: amfriedman commented 22 March 2012 at 14:30

+1, I have the same problem:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'delta' at row 1: INSERT INTO {block} (module, delta, theme, status, weight, region, pages) 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); Array ( [:db_insert_placeholder_0] => fb_social [:db_insert_placeholder_1] => Activity Feed in Homepage Tabbed Box [:db_insert_placeholder_2] => ike_omega [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => -1 [:db_insert_placeholder_6] => ) in drupal_write_record() (line 6888 of /var/www/includes/common.inc).