Active
Project:
Jump
Version:
7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
15 Dec 2011 at 22:32 UTC
Updated:
23 Oct 2012 at 16:41 UTC
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
Comment #1
jday commentedsame problem on a 7.12 site
Comment #2
frodopwns commentedSame issue here for Deupal 7.2
Comment #3
patrickfgoddard commentedGetting 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: