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)

Issue fork visitors-3503014

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

drupalbubb created an issue. See original summary.

rajdip_755 made their first commit to this issue’s fork.

rajdip_755 opened merge request !209

rajdip_755’s picture

rajdip_755
Primary language Bengali
Location kolkata
commented
Status: Active » Needs review

This issue is occurring due to the mismatch in field ordering, fixed that in the MR !209 .
Please review the MR. Thanks!

bluegeek9 made their first commit to this issue’s fork.

bluegeek9 opened merge request !212

  • bluegeek9 committed 3c80b7ad on 3.0.x 
    Issue #3503014: migrate data from statistics failed

bluegeek9’s picture

bluegeek9 commented
Status: Needs review » Fixed
//www.flaticon.com/free-icons/thank-you Thank you for your contribution! Your continued support to this project makes other volunteer contributions more sustainable.
There are multiple ways to show appreciation for the work contributed to this project including:
  • Triaging issues and adding more context to existing issues.
  • Writing documentation or patches for this project.
drupalbubb’s picture

drupalbubb commented

Works for me. Thanks!

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.

bluegeek9’s picture

bluegeek9 commented

Updating credits.