I've created a mini panel, and it's name is front_page_panel_search_and_browse. Everything seems to be alright, until i go to blocks to enable the mini panel and have it assigned to a region.

Instead of being shown a page with available regions and blocks (at admin/structure/block), i get the following 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, cache) 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, :db_insert_placeholder_7); Array ( [:db_insert_placeholder_0] => panels_mini [:db_insert_placeholder_1] => front_page_panel_search_and_browse [:db_insert_placeholder_2] => uncoated [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => -1 [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => -1 ) in drupal_write_record() (line 7136 of /home/search/www/public_html/includes/common.inc).

How to replicate:

1. Create a new mini panel, and assign the name Front Page Panel, Search And Browse. This gives the machine name front_page_panel_search_and_browse.
2. Go to blocks (at admin/structure/block). This throws and exception.


skribbz14’s picture

Component: Mini panels » Plugins - layouts

Also getting this error, but with a custom layout and a panelized content type.


Fixed the problem by editing the character length in the database for panels.

See here: