"Error 500" in global search - EspoCRM Open Source Community Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

X

dabasystem

Member

Join Date: Jul 2018

Posts: 51
Share

Tweet
#1

"Error 500" in global search

07-26-2018, 07:57 AM

When searching, an error 500 appears. I have looked at the error log and this message appears --> "[2018-07-26 07:41:40] Espo.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'opportunity.assigned_user_id' in 'where clause', Code: 42S22 URL: /api/v1/GlobalSearch?q=CONDAL%20TRADE%20BARCELONA%20SA&max Size=5&offset=0&sortBy=id&asc= [] []"

What can happen? How can I solve it?

A greeting

1 Photo
Tags: None
dabasystem

Member

Join Date: Jul 2018

Posts: 51
Share

Tweet
#2

07-26-2018, 07:58 AM

With the administrator it works correctly. :S
Comment
yuri

Member

Join Date: Mar 2014

Posts: 8527
Share

Tweet
#3

07-26-2018, 09:01 AM

Can't reproduce.

If you find EspoCRM good, we would greatly appreciate if you could give the project a star on GitHub. We believe our work truly deserves more recognition. Thanks.
Comment
dabasystem

Member

Join Date: Jul 2018

Posts: 51
Share

Tweet
#4

07-27-2018, 08:16 AM

SOLVED! The problem was that the global search engine had many entities. I have left 8 only (since adjustments) and great, it works!

I mention it in case someone is in the same situation.
Comment

Previous template Next

Working...