PDOException with keyword too long

Created on 3 January 2019, over 5 years ago

Updated 5 June 2024, 24 days ago

When an User (maybe a malicious user) try to search on search api page with a key word too long (260 character) a PDO Exception happens and it is:

PDOException: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'keywords' at row 1: INSERT INTO {search_api_stats} (s_name, i_name, timestamp, uid, sid, keywords, filters, sort, language) 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, :db_insert_placeholder_8); Array ( [:db_insert_placeholder_0] => database_indici [:db_insert_placeholder_1] => indici_nodi [:db_insert_placeholder_2] => 1546493293 [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => DsVLqaenbGfpRmDeuxiZC7XRJOprZkVx4-ELGoDD-1c [:db_insert_placeholder_5] => printmail search node user user user user user user user user user user user user user user user user user user user user user user user user user user user user user user user user login [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => it ) in search_api_stats_search_api_query_alter() (linea 54 di /var/www/mysite/sites/all/modules/search_api_stats/search_api_stats.module).

I wait for response.

🐛 Bug report

Status

Fixed

Version

1.0

Component

Code

Created by

🇮🇹Italy cozzamara

Live updates comments and jobs are added and updated live.

Incomplete comments

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment about 1 month ago →
🇨🇳China zterry95
Here is the max length of varchar:
https://www.drupal.org/docs/7/api/schema-api/data-types/varchar →

What we have defined in the hook_schema:
https://git.drupalcode.org/project/search_api_stats/-/blob/8.x-1.x/searc...
Status changed to Fixed about 1 month ago7:41am 22 May 2024
Comment about 1 month ago →
🇨🇳China zterry95
I try the drupal 10 with search_api_stats 1.0, looks Drupal core can handle the exception automaticlly.
keywords cannot be longer than 128 characters but is currently 255 characters long.

If you still stick on Drupal 7, please reopen it. Let's close it temporarly.
Or you can implements hook_schema_alter in you custom module, alter the length of `keywords` field to fit your need.
Comment 24 days ago →
System Message
Automatically closed - issue fixed for 2 weeks with no activity.

contrib.social Blog FAQ Discussions

Production build 0.69.0 2024