screenshot: http://prntscr.com/4n8e1

throwing errors on enable. what does it mean? I'm on D7.9+. Once enabled it breaks entire site and I would need to disable and uninstall.
------------

WD php: PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'delta' at row 1: INSERT INTO {block} (module, delta, theme, status,[error]
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

Comments

jday’s picture

same problem on a 7.12 site

frodopwns’s picture

Same issue here for Deupal 7.2

patrickfgoddard’s picture

Getting the same error on install. Though the enabling via Drush, there was no error, only when doing a clearing of cache, via Drush, did I see the PDOException error.

One of the functions in jump.module is adding on "menu-" onto the "delta, adding extra text to existing menu block names.

In the block table, the delta column is only 32 chars, so if an existing block name is already long name, appending extra text risks exceeding allowable length and sets off the "data too long" error.

The delta field notes say that the delta is "Unique ID for block within a module.", so maybe adding "menu-" or "taxo-" is unnecessary. Either that, or the function should truncate the delta variable string to 32 char max before inserting into db.

Below is an example of data that was trying to be inserted when I enable module:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'delta' at row 1: INSERT INTO {block} (module, delta, theme, status,   [error]
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] => jump
    [:db_insert_placeholder_1] => menu-menu-already-long-block-name
    [:db_insert_placeholder_2] => theme-name
    [:db_insert_placeholder_3] => 0
    [:db_insert_placeholder_4] => 0
    [:db_insert_placeholder_5] => -1
    [:db_insert_placeholder_6] => 
)