We recently updated to SuiteCRM 7.7.7 and encountering now issues when performing a search and using dropdown fields as filters. As I can say all modules are affected. For instance, when searching in leads-module for all “new” leads, no search results are returned: “No results found” (and there are new leads for sure). We can observe this behaviour for any search using any filter-field defined as a dropdown.
The expected behaviour would be a filtered list of records returned.
The Suite Error Log spits out an “MySQL error 1054: Unknown column ‘New’ in ‘where clause’”.
The full error code is:
Mon Nov 14 22:09:33 2016 [12805][1][FATAL] Query Failed: SELECT leads.id ,leads_cstm.fecha_tentativa_c,leads_cstm.pax_c, leads.assigned_user_id , LTRIM(RTRIM(CONCAT(IFNULL(leads.first_name,’’),’ ‘,IFNULL(leads.last_name,’’)))) as name, leads.first_name , leads.last_name , leads.salutation , leads.account_name , leads.account_id , leads.status , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, leads.lead_source , leads.lead_source_description , leads.date_entered , leads.created_by FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON leads.assigned_user_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 where ((leads.status in (New))) AND leads.deleted=0 ORDER BY leads.date_entered DESC LIMIT 0,21: MySQL error 1054: Unknown column ‘New’ in ‘where clause’
There are no errors in the php log. We are using php 5.6.16. A temporary php update to 7.0.6 didn´t work out either.
Any hints how to fix this would be highly appreciated!
I have tha same problem - same version 7.7.7 - and my drop down fields (Industry & Type) in an account search dos not work either. Search result are every time empty, where I would expect e.g. all my Industry customers to show op.
If I e.g. search on an name - I will get an answer.
I have checked that both fields (Industry & Type) are present in both EditView and in DetailView (Think Will asked someone about that - in another thread)
Precise the same type of search works perfect in the “old” Version 7.6.4
Relatively complicated, but I followed this rute (just to inform others).
You have to find the file: include/SearchForm/SearchForm2.php in the include/SearchForm directory
Rename that file to SearchForm2OLD.php
Copy that file and give it the correct name again (SearchForm2.php)
In my ref. link - you will se som red and green areas. Red ones has to be deleted and green ones has to be added / corrected.
In the top right corner - you will have the possibility to Unified / Split the code - I found it easier to work with in Split view.
I dont know what I did, BUT i worked - thanks to Mattlorimer …
Further to this - I found, that you have a new update named: SuiteCRM 7.7.8