Fatal Error: Captcha session_id too long

Created on 12 June 2020, over 4 years ago
Updated 7 August 2023, over 1 year ago

Getting a fatal error when using invisible captcha randomly on forms.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'sid' at row 1: INSERT INTO {captcha_sessions} (uid, sid, ip_address, timestamp, form_id, solution, status, attempts) 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] => 0 [:db_insert_placeholder_1] => w1vL3Bi7v-la9DK45ijDX4cgGyFzrqUiwnw56mHkRT8OmLtZ5Jbl89ug8HDe7p5n0L2eaWbN3mmpROD1b0Bn8A.. [:db_insert_placeholder_2] => 109.166.136.58 [:db_insert_placeholder_3] => 1591950512 [:db_insert_placeholder_4] => webform_submission_landing_page_node_40908_add_form [:db_insert_placeholder_5] => a50187724f062a9e1613dc99db1b6e86b0684517aecd4eb29c43f30905ed3eb1 [:db_insert_placeholder_6] => 0 [:db_insert_placeholder_7] => 0 ) ÃŪn _captcha_generate_captcha_session() (linia 98 din /public/website/stage.reginamaria.ro/web/modules/contrib/captcha/captcha.inc).

Seems like the sid column is limited to 255 characters and the generated session_id is longer.
Managed to reproduce this on Mozzila Firefox with invisible captcha. Not sure if it can be reproduce with other catcha type.

🐛 Bug report
Status

Closed: cannot reproduce

Version

3.0

Component

Invisible reCAPTCHA

Created by

🇷ðŸ‡īRomania alexandru.dumitru Cluj

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