migrate data from statistics failed

Created on 29 January 2025, 3 months ago

I enabled visitors and tried to migrate data from statistics and disable statistics module through visitors. The following error appeared, nothing got imported and statistics is still active. The link on the status report to migrate data (again) is not appearing.

Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'today' at row 1: INSERT INTO "XXX_visitors_counter" ("entity_type", "entity_id", "total", "today", "timestamp") SELECT "s"."nid" AS "entity_id", "s"."totalcount" AS "total", "s"."daycount" AS "today", "s"."timestamp" AS "timestamp", 'node' AS "entity_type" FROM "XXX_node_counter" "s"; Array ( ) in Drupal\visitors\Form\StatisticsMigrateForm::insert() (Zeile 116 in /path/to/drupal/web/modules/contrib/visitors/src/Form/StatisticsMigrateForm.php).

(i replaced my database prefix and the path to drupal)

🐛 Bug report
Status

Active

Version

2.24

Component

Code

Created by

🇩🇪Germany drupalbubb

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