Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.The code in facetapi_views_block_info() is breaking on my site. My searcher name is search_api@default_taxonomy_index.
The 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, 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] => facetapi_views
[:db_insert_placeholder_1] => s:search_api@default_taxonomy_index
[:db_insert_placeholder_2] => bartik
[:db_insert_placeholder_3] => 0
[:db_insert_placeholder_4] => 0
[:db_insert_placeholder_5] => -1
[:db_insert_placeholder_6] =>
[:db_insert_placeholder_7] => -1
)
Comments
Comment #2
geek-merlinHuh, that's a pity.
Let's change the deltas to MD5.
As an experimental feature and <10 installs (2 from me) we can do that without upgrade path.
Patches appreciated.
Comment #3
geek-merlinSteal from views:
views_ctools_block_info | views_content.module | Drupal 7 | DrupalContrib
views_block_info | views.module | Drupal 7 | DrupalContrib
Comment #5
geek-merlinOK the fix is in current dev. You will have to delete and recreate the block after update.
Works here.
Comment #6
geek-merlin