- 🇭🇺Hungary balazswmann
Unfortunately, these patches cannot be used anymore since Drupal 10.1. At least none of them which drops the primary key:
New transaction isolation level default for new sites for MySQL, MariaDB or equivalent databases →
We have a case where the indexed entity ID is a string that may go up to 255 characters. This fails with:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column [error]
'item_id' at row 1: INSERT INTO {search_api_item} (index_id, datasource, item_id, changed, status) VALUES
(:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3,
:db_insert_placeholder_4); Array
(
[:db_insert_placeholder_0] => articles
[:db_insert_placeholder_1] => entity:entity_abc
[:db_insert_placeholder_2] =>
entity:entity_abc/https://www.kwz-bzss.fgmd.eu/fr/bcss/page/content/websites/xanax1/services/docutheque/webservices_value_123456/Specific-documentation-SW.html#ReplaceIdentificati-22:und
[:db_insert_placeholder_3] => 1479823527
[:db_insert_placeholder_4] => 1
)
in Drupal\search_api\Plugin\search_api\tracker\Basic->trackItemsInserted() (line 177 of
web/modules/contrib/search_api/src/Plugin/search_api/tracker/Basic.php).
Increase the size of DB column to an acceptable maximum limit of 2048 characters. Drop the primary key index. This was used only to assure the unicity but that is already assured in \Drupal\search_api\Plugin\search_api\tracker\Basic::trackItemsInserted()
Closed: won't fix
1.0
Framework
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
Unfortunately, these patches cannot be used anymore since Drupal 10.1. At least none of them which drops the primary key:
New transaction isolation level default for new sites for MySQL, MariaDB or equivalent databases →