Loading...
 
Skip to main content

WordPress importer error: Out of range value for column 'activity' at row 1

  • Tracker item actions
Trackers
Items
Status
Open
Subject
WordPress importer error: Out of range value for column 'activity' at row 1
Version
21.x
Category
  • Error
Feature
Import-Export
Resolution status
New
Submitted by
Jean Bernatchez
Lastmod by
Jean Bernatchez
Rating
(0)
Description

While importing for WordPress 5.7, process reported all extracted data from XML file as expected. After reporting 49 posts as successfully imported, stops with message:

Out of range value for column 'activity' at row 1
The query was:
update `tiki_blogs` set `activity`=? where `blogId`=?
Values:
1. 100
2. 1
The built query was likely:
update `tiki_blogs` set `activity`='100' where `blogId`='1'

To verify that this was not caused by a specific post, I deleted the first 50 posts from de XML file and reran the import. Exact same scenario repeated (with blogId value incremented by 1).

Looking at the table tiki_blogs I thought that the field 'activity' may not allow for a value of 100 so modified to increase length by 1 digit and reran. It now works. Successfully imported all 393 posts.

I do not know if the error is caused by the data definition (field to short?) or the importer (value should not reach 100?) as I am not clear on what the "activity" column represents.

Importance
2
Easy to solve?
5
Priority
10
Demonstrate Bug on Tiki 19+
Demonstrate Bug (older Tiki versions)
Ticket ID
7725
Created
Tuesday 13 April, 2021 04:47:32 UTC
by Jean Bernatchez
LastModif
Tuesday 13 April, 2021 04:47:32 UTC


Show PHP error messages