Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Getting this error when Profile2 Registration Path Blocks module is enabled
Error message
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] => profile2_regpath [:db_insert_placeholder_1] => p2rp_register_personal_information [:db_insert_placeholder_2] => sos_prelaunch [: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 /includes/common.inc).
Comments
Comment #1
grasmash CreditAttribution: grasmash commentedThis happened because the name of your profile type was very long. I've change the module to use the profile id rather than the profile type name, so this should not occur any more.
If you're upgrading from a previous version, please first disable the profile2 registration path blocks, upgrade the module, and then re-enable. Otherwise, you're going to get some errors that will be annoying to get rid of!