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 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 |