Selecting a field in the parameter "Sort Fields" of an Items List tracker fields block index from being rebuilt.
It throw the following error:
warning: Divide by zero on "0" error: The search index could not be rebuilt. Expression #1 of ORDER BY clause is not in SELECT list, references column 'kindergarten_tiki20x.ttif0.value' which is not in SELECT list; this is incompatible with DISTINCT
Un-selecting it solve the issue and the index is rebuilt correctly.
PS: I created an instance but wasn’t able to access it to demonstrate (error 500).
The URL for the show2.tiki.org instance that demonstrates this bug is at: http://bsfez-11581-7211.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-7211.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-7211.show2.tiki.org/snapshots/. Note that if you get a popup asking for a username/password, please just enter "show" and "show".
Create new snapshotUnable to connect to show.tikiwiki.org. Please let us know of the problem so that we can do something about it. Thanks.
filename | created | hits | comment | version | filetype | ||
---|---|---|---|---|---|---|---|
No attachments for this item |