Architecture / Installation

Architecture / Installation

Plugin Listpages fails to sort after upgrade 12.0 to 14.1

posts: 28 Italy

Hello team,
first of all I'd like to thank all of you for the hard work. Tiki 14.1 works fantastic, it's there, it's better. Warm congratulations!
I document a couple of glitches I had to study.
No way to rebuild the index, it was crashing in php, until I removed all ItemLink fields in all trackers, then index rebuilt instantly.
Error was
PHP Fatal error: Call to a member function getGlobalFields() on a non-object in /var/www/html/tiki/lib/core/Tracker/Field/ItemLink.php on line 437, referer: /tiki/tiki-index.php?page=HomePage

Another strange glitch is that 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.

Kudos guys, and looking to use it more in our company.
Hubert J.

PS: also opened as https://dev.tiki.org/item5779. I'm attempting to reproduce on show.tiki.org.

posts: 1817 Catalan Countries

Hi Hubert J.:

Can you please report these issues in the bug/wish tracker at dev.t.o? See:

and tag your reports against "Regression in 14.x", if that's what it is (since you say that this was working in 12.x)

This way, there are higher chances that other devs can have a look at that sooner or later, preventing bug reports getting lost in the forums.


Upcoming Events

No records to display