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.
The URL for the show2.tiki.org instance that demonstrates this bug is at: http://jeanbz-12024-7725.show2.tiki.org. Note that if you get a popup asking for a username/password, please just enter "show" and "show". This is different from the initial login and password for a new Tiki which is "admin" and "admin".
For the install log, see http://jeanbz-12024-7725.show2.tiki.org/info.txt
Note that if you see PHP errors or a Tiki claiming to be missing third party software, the instance creation is probably not finished. Please wait a couple minutes and reload.
Snapshots are database dumps of the configuration that developers can download for debugging. Once you have reproduced your bug on the show2.tiki.org instance, create a snapshot that can then be downloaded by developers for further investigation.
Snapshots can be accessed at: http://jeanbz-12024-7725.show2.tiki.org/snapshots/. Note that if you get a popup asking for a username/password, please just enter "show" and "show".
Create new snapshotUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |