Data too long for column 'location_country'

Created on 29 March 2025, 27 days ago

Every so often I see this error in my Watchdog log:

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22001]: String data, right truncated: 1406 Data too long for column 'location_country' at row 1: INSERT INTO "visitors" ("bot", "visitors_ip", "visitors_uid", "visitors_title", "visitors_user_agent", "config_browser_engine", "config_browser_name", "config_browser_version", "config_client_type", "config_device_brand", "config_device_model", "config_device_type", "config_os", "config_os_version", "visitor_id", "visitors_url", "visitors_referer", "visitors_path", "route", "server", "config_resolution", "config_pdf", "config_flash", "config_java", "config_quicktime", "config_realplayer", "config_windowsmedia", "config_silverlight", "config_cookie", "pf_network", "pf_server", "pf_transfer", "pf_dom_processing", "pf_dom_complete", "pf_on_load", "pf_total", "visitor_localtime", "visitors_date_time", "language", "location_country", "location_continent") 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, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20, :db_insert_placeholder_21, :db_insert_placeholder_22, :db_insert_placeholder_23, :db_insert_placeholder_24, :db_insert_placeholder_25, :db_insert_placeholder_26, :db_insert_placeholder_27, :db_insert_placeholder_28, :db_insert_placeholder_29, :db_insert_placeholder_30, :db_insert_placeholder_31, :db_insert_placeholder_32, :db_insert_placeholder_33, :db_insert_placeholder_34, :db_insert_placeholder_35, :db_insert_placeholder_36, :db_insert_placeholder_37, :db_insert_placeholder_38, :db_insert_placeholder_39, :db_insert_placeholder_40); Array ( [:db_insert_placeholder_0] => 0 [:db_insert_placeholder_1] => 164.77.38.50 [:db_insert_placeholder_2] => 0 [:db_insert_placeholder_3] => Air Cleaners (1968) | Mustang 428 Cobra Jet Registry [:db_insert_placeholder_4] => Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/15.3 Safari/605.1.15 [:db_insert_placeholder_5] => WebKit [:db_insert_placeholder_6] => SF [:db_insert_placeholder_7] => 15.3 [:db_insert_placeholder_8] => browser [:db_insert_placeholder_9] => Apple [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => desktop [:db_insert_placeholder_12] => MAC [:db_insert_placeholder_13] => 10.15 [:db_insert_placeholder_14] => 17a6c2b7b106ed36 [:db_insert_placeholder_15] => https://www.428cobrajet.org/id-air-cleaner-68 [:db_insert_placeholder_16] => https://www.google.com/ [:db_insert_placeholder_17] => /node/16 [:db_insert_placeholder_18] => entity.node.canonical [:db_insert_placeholder_19] => musclecarresearch.net [:db_insert_placeholder_20] => 1512x982 [:db_insert_placeholder_21] => 1 [:db_insert_placeholder_22] => 0 [:db_insert_placeholder_23] => 0 [:db_insert_placeholder_24] => 0 [:db_insert_placeholder_25] => 0 [:db_insert_placeholder_26] => 0 [:db_insert_placeholder_27] => 0 [:db_insert_placeholder_28] => 1 [:db_insert_placeholder_29] => 0 [:db_insert_placeholder_30] => 262 [:db_insert_placeholder_31] => 0 [:db_insert_placeholder_32] => 15 [:db_insert_placeholder_33] => 1224 [:db_insert_placeholder_34] => 1 [:db_insert_placeholder_35] => 1502 [:db_insert_placeholder_36] => 70960 [:db_insert_placeholder_37] => 1743201760 [:db_insert_placeholder_38] => es [:db_insert_placeholder_39] => 419 [:db_insert_placeholder_40] => ) in Drupal\visitors\Service\TrackerService->writeLog() (line 36 of /var/www/428/web/modules/contrib/visitors/src/Service/TrackerService.php).

That value being inserted is "419", which is of length 3. In my database, the type of the 'location_country' field is varchar(2). Should the length of the field be increased by 1, or is something not working properly when trying to insert '419'?

πŸ› Bug report
Status

Active

Version

2.27

Component

Code

Created by

πŸ‡ΊπŸ‡ΈUnited States sah62 US

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

Merge Requests

Comments & Activities

Production build 0.71.5 2024