CoreBOSBB

No, no more update. review the custom fields, make sure they haven't been deleted but the filter hasn't been updated. If that isn't the issue, delete this part of the SQL:

INNER JOIN vt_tmp_u209 vt_tmp_u209 ON vt_tmp_u209.id = vtiger_crmentity.smownerid

and execute the rest in mysql to see if you get any error.

if not, make the same modification as above but after the mkCountQuery() function to get the result of that function and execute that on in mysql to see if you can see the error.

If I select a field in filter base for rhis widget related to another mofule, problem occurs

I try created a widget for module Taskm and uses a filter with fields in task modules and a subject in service contratcs

I can reproduce the error. get back to you asap

see if this helps: https://github.com/tsolucio/corebos/commit/abecce0807111d6a64835b97dff066471488d0d5