Listpages plugin does not sort on columns on 14.x
- Status
- Closed
- Subject
- Listpages plugin does not sort on columns on 14.x
- Version
- 14.x Regression
- Category
- Regression
- Feature
- Tablesorter
- Resolution status
- Invalid
- Submitted by
- hjohanns
- Lastmod by
- hjohanns
- Rating
- Description
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` ascAnd 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 Hits 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- Solution
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.- Importance
- 5
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 5779
- Created
- Wednesday 23 December, 2015 01:22:09 UTC
by hjohanns - LastModif
- Saturday 25 June, 2016 16:18:30 UTC