Search function spinning and stuck!
When I try to search it shows no result but show the spinning wheel as in the image.
I cleared the Cache with no luck.
Any help please?
-
Hello @Tajrebatee !
The usual reason for this trouble as you know now is the DB error. In your case, this is the wrong field "friends_count" wrongly included in the search process.
-
Thanks!. Where is specifically that "search process" and how can it be edited (in Studio) to avoid this from happening in future? tnx
-
UPDATE: It seems there was a non-usual trick with the following actions:
1) Enable the "Friends count" field in the Studio->Forms->Persons->Add Person area. This is wrong because this field is calculated for the View page only.
2) Enable this field also in the Studio->Persons page, in the "Searchable fields for keyword search" field.
After the second action, UNA considered that this field works in the global search too. And it started to generate the MySQL error about not found field.
-
@LeonidS for tackling this. Is this going to be somehow prevented in UNA-13-B4 or 14?
-
No, due to so "particular" nature of this trouble and easy discovered way to fix it, we will not add change anything there. How to fix it:
1) Turn off "Friends count" in the Studio-->Persons area, "Searchable fields for keyword search" parameter. Save changes.
2) Turn off the "Friends count" field in the Fields->Persons-> Add form part.
