Bad server response while searching

[Leo]

Hello,

I have a 'bad server response' when I try to do a global research...

It only happens on an online server, it works perfectly on local

Here is error log :

[2016-07-22 10:28:34] Espo.ERROR: API [GET]:/GlobalSearch, Params:Array ( ) , InputData:  - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contact.account_role' in 'where clause' [] []
[2016-07-22 10:28:34] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'contact.account_role' in 'where clause', Code: 42S22 URL: /EspoCRM-4.1.6/api/v1/GlobalSearch?q=memoris&maxSize=5&offset=0&sortBy=id&asc= [] []

where can it come from ?

(I precise that I did some customization on entity's relationships and fields...)

Thanks,

Léo

EDIT: I just found that it happens when I put 'contact' or 'user' in the global search entities parameters, it seems like a SQL query on something that don't exist, why ?

[yuri]

Hi,

Maybe you added some fields to Text Filter Fields for Contacts or in Entity Manager. Try to remove some of them.

[Leo]

Got it !

Now I understand that I can't put something in Text Filter Fields that is not mandatory during the creation of an entity...

Thanks !

[yuri]

No, You just can't put some non-ordinary fields.

[Leo]

What is called 'non-ordinary' ?