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:
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,
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.
|No attachments for this item|