The plugin Listpages does not sort by fields. It displays the data, but any attempt to click on a field header yields an error like
Unknown column 'versions' in 'order clause'
The query was:
SELECT *, ROUND(MATCH(`categories`) AGAINST ('wiki page'),2) AS `score` FROM `index_567872dfcd0a9` WHERE 1=1 AND (`searchable` = 'y' AND `object_type` = 'wiki page' AND MATCH (`categories`) AGAINST ('tokenctxxx' IN BOOLEAN MODE) AND `modification_date` BETWEEN '2013-12-31 23:00:00' AND '2015-08-21 21:10:52') ORDER BY `versions` asc
And in fact the field versions does not exist, but I don't know how to rebuild the Listpages, so that it does not look for it.
This is the element in the page that causes the error:
Page | Last modification | Last author | Last version | Backl. | Categories |
---|---|---|---|---|---|
No pages found. |
This problem is not present on 12, but appears immediately when migrating the data to 14.x.
Great work guys, and thank you so much,
Hubert
This is linked to the rebuild of the index. If rebuilding the index, things will work BUT you need to remove every field of type "ItemLink" from the trackers if the data is migrated from Tiki12.
"ItemLink" fields are not compatible with the new implementation of trackers in Tiki14 and 15.
To help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.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 show2.tiki.org.
To 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 |