Was hard to diagnose...
After upgrading a Tiki20 to Tiki21 I was able to rebuilt the index:
[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:
2020-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.
The URL for the show2.tiki.org instance that demonstrates this bug is at: http://bsfez-11581-7301.show2.tiki.org. Note that if you get a popup asking for a username/password, please just enter "show" and "show". This is different from the initial login and password for a new Tiki which is "admin" and "admin".
For the install log, see http://bsfez-11581-7301.show2.tiki.org/info.txt
Note that if you see PHP errors or a Tiki claiming to be missing third party software, the instance creation is probably not finished. Please wait a couple minutes and reload.
Snapshots are database dumps of the configuration that developers can download for debugging. Once you have reproduced your bug on the show2.tiki.org instance, create a snapshot that can then be downloaded by developers for further investigation.
Snapshots can be accessed at: http://bsfez-11581-7301.show2.tiki.org/snapshots/. Note that if you get a popup asking for a username/password, please just enter "show" and "show".
Create new snapshotTo 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 |