SQLSTATE[23000]: Column visitors_title cannot be null

Created on 3 August 2023, over 1 year ago

Problem/Motivation

Hi,

First off, thanks for this awesome module. I've been reading the issue queue and I see lots of very cool plans for the future so I'm keeping by dev version updated :)

In the meantime (both the latest dev and the latest stable version) print a lot of errors in my log. I am running Drupal 10.08 and it's a multi-lingual setup. The error does appears when switching languages but it might also be triggered by other actions.

The full log entry is:
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'visitors_title' cannot be null: INSERT INTO "visitors" ("visitors_uid", "visitors_ip", "visitors_date_time", "visitors_url", "visitors_referer", "visitors_path", "visitors_title", "visitors_user_agent", "route", "config_resolution", "config_pdf", "config_flash", "config_java", "config_quicktime", "config_realplayer", "config_windowsmedia", "config_silverlight", "config_cookie") 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); Array ( [:db_insert_placeholder_0] => 1 [:db_insert_placeholder_1] => 27.55.72.29 [:db_insert_placeholder_2] => 1691046063 [:db_insert_placeholder_3] => https://***.com/dashboard/***_sysadmin [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => /dashboard/g_***_sysadmin [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko/20100101 Firefox/117.0 [:db_insert_placeholder_8] => entity.dashboard.canonical [:db_insert_placeholder_9] => 1920x1080 [:db_insert_placeholder_10] => 1 [:db_insert_placeholder_11] => 0 [:db_insert_placeholder_12] => 0 [:db_insert_placeholder_13] => 0 [:db_insert_placeholder_14] => 0 [:db_insert_placeholder_15] => 0 [:db_insert_placeholder_16] => 0 [:db_insert_placeholder_17] => 1 ) in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (line 43 of /var/www/****/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).

Steps to reproduce

Install visitors on a multi-language site and switch between languages.

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

*EDIT: obfuscated url and field/machine names in the error log extract.

πŸ› Bug report
Status

Fixed

Version

2.0

Component

Code

Created by

πŸ‡ΉπŸ‡­Thailand AlfTheCat

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

Comments & Activities

Production build 0.71.5 2024