CiviCRM 5.35.0 on Joomla 3.9.25
Search (basic, advanced or search builder) when I select a Group returns:
"Sorry, due to an error, we are unable to fulfill your request at the moment. You may want to contact your administrator or service provider with more details about what action you were performing when this occurred.
DB Error: no such field"
I'm not sure when this started happening. We update regularly and haven't had any issues installing updates or running the db update function.
Error log has this:
Mar 11 05:12:10 [error] $Fatal Error Details = Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => exceptionHandler
)
[code] => -19
[message] => DB Error: no such field
[mode] => 16
[debug_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
FROM civicrm_saved_search a
WHERE (`a`.`id` = "71")
[nativecode=1054 ** Unknown column 'a.name' in 'field list']
[type] => DB_Error
[user_info] => SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
FROM civicrm_saved_search a
WHERE (`a`.`id` = "71")
[nativecode=1054 ** Unknown column 'a.name' in 'field list']
[to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="SELECT `a`.`id` AS `id`, `a`.`name` AS `name`, `a`.`label` AS `label`, `a`.`form_values` AS `form_values`, `a`.`mapping_id` AS `mapping_id`, `a`.`search_custom_id` AS `search_custom_id`, `a`.`api_entity` AS `api_entity`, `a`.`api_params` AS `api_params`
FROM civicrm_saved_search a
WHERE (`a`.`id` = "71")
[nativecode=1054 ** Unknown column 'a.name' in 'field list']"]
)
show create table civicrm_saved_search? It seems like a field is missing on that table, which is rather odd. The 'name' column was added in CiviCRM 2.1 and not changed since. Also, do you have detailed logging enabled?show create table log_civicrm_saved_search.select version from civicrm_domain?