[Tiki-devel] index rebuilt verbose in log has changed (and it tells less)

Hi devs,

I just update a real life Tiki22 with the last month+ commits from git.

The output of the log with index:rebuilt because it has changed and doesn’t point clearly (some?) errors.


I have, since Tiki21, an error on my local (when I use a dump from the prod site) due to the sort option of the tracker field itemList.

error: The search index could not be rebuilt.
Expression #1 of ORDER BY clause is not in SELECT list, references column 'tsaharoniki_tiki22.ttif0.value' which is not in SELECT list; this is incompatible with DISTINCT

Each time I bring it on my local I have to unset the "sort" option else I have an error during index:rebuilt and it can't complete.

Before: using  "php console.php i:r -vvv —log" I could see and have a clear message on the error line and the process was interrupted.
Now: I have the error displayed in the shell but nothing in the log.

Because I’m very familiar the error I can see that the last item indexed (552) is the first of the problematic tracker but nothing that really says it failed here.

2021-04-05T10:11:57+03:00 INFO (6): addDocument trackeritem 552 {"memoryUsage":"29.9 MiB"}
2021-04-05T10:11:57+03:00 INFO (6): Indexed
2021-04-05T10:11:57+03:00 INFO (6):   total tiki fields indexed:
2021-04-05T10:11:57+03:00 INFO (6):   total fields used in the mysql search index: :


Bernard





_______________________________________________
TikiWiki-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tikiwiki-devel