Sorting field results from an item list tracker field type is not working anymore
- Status
- Closed
- Subject
- Sorting field results from an item list tracker field type is not working anymore
- Version
- 18.x
18.x Regression
20.x
20.x Regression
21.x Regression
22.x - Category
- Regression
- Upgrade Blocker
- Feature
- Trackers
- Resolution status
- Duplicate
- Submitted by
- Bernard Sfez / Tiki Specialist
- Lastmod by
- Bernard Sfez / Tiki Specialist
- Rating
- Description
Was hard to diagnose...
After upgrading a Tiki20 to Tiki21 I was able to rebuilt the index:
Copy to clipboard[03-03-2020 12:05] Started rebuilding index... logging to file: /var/tmp/Search_Indexer_mysql_tsaharoniki_tiki21_console.log Unified search engine: MySQL, version 5.7.26 error: The search index could not be rebuilt. Expression #1 of ORDER BY clause is not in SELECT list, references column 'tsaharoniki_tiki21.ttif0.value' which is not in SELECT list; this is incompatible with DISTINCT
The log:Copy to clipboard2020-03-03T10:47:35+02:00 ERR (3): WARNING: PDOStatement::execute(): SQLSTATE[HY000]: General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list, references column 'tsaharoniki_tiki21.tti$
Checking the item (I had to find it!) I found out that having a sort parameter in an itemList field was responsible.Once removed it worked.
This is very problematic when you have financial data as any report must be ordered (by date).Update:
Same same in Tiki 20
It may be related to the removal of the "split" function in PHP 7+;
https://whmcs.community/topic/290945-how-to-sort-smarty-variables-in-whmcs-76/Update:
It is now also on Tiki18.8 as it was signaled to me by another Tiki user (tested with him)
I tried to reproduce on the show instance but there is a bug with field list on the trackers and it is not possible to recreate the caches.
- Workaround
- Unselect field to sort on the itemList field options.
- Importance
- 9
- Easy to solve?
- 7
- Priority
- 63
- 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
- 7301
- Created
- Tuesday 03 March, 2020 10:13:18 UTC
by Bernard Sfez / Tiki Specialist - LastModif
- Tuesday 06 December, 2022 13:13:51 UTC