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 snapshotTo help developers solve the bug, we kindly request that you demonstrate your bug on a show.tikiwiki.org instance. To start, simply select a version and click on "Create show.tikiwiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show.tikiwiki.org.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |