0

I have created a search view (profile) including the "phone and extension". When try to show results with this view, an error occurs.

$Fatal Error Details = Array ( [callback] => Array ( [0] => CRM_Core_Error [1] => exceptionHandler ) 
[code] => -19 [message] => DB Error: no such field [mode] => 16 

[debug_info] => INSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data) 
SELECT DISTINCT 'civicrm search CRMContactControllerSearch4cxz1gqhoo4kkkkwko4ok8sk40c088gk8ccsg0wws0w44ggos8_1011', contact_a.id, contact_a.sort_name 
FROM civicrm_contact contact_a WHERE 1 AND ( 1 ) AND (contact_a.is_deleted = 0) 
ORDER BY `1-phone_ext` asc, `contact_a`.`id` LIMIT 0, 500 [nativecode=1054 ** Unknown column '1-phone_ext' in 'order clause'] [type] => DB_Error 

[user_info] => INSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data) SELECT DISTINCT 'civicrm search CRMContactControllerSearch4cxz1gqhoo4kkkkwko4ok8sk40c088gk8ccsg0wws0w44ggos8_1011', contact_a.id, contact_a.sort_name FROM civicrm_contact contact_a 
WHERE 1 AND ( 1 ) AND (contact_a.is_deleted = 0) ORDER BY `1-phone_ext` asc, `contact_a`.`id` LIMIT 0, 500 

[nativecode=1054 ** Unknown column '1-phone_ext' in 'order clause'] [to_string] => [db_error: message="DB Error: no such field" code=-19 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info=" 
INSERT INTO civicrm_prevnext_cache (cachekey, entity_id1, data) SELECT DISTINCT 'civicrm search CRMContactControllerSearch4cxz1gqhoo4kkkkwko4ok8sk40c088gk8ccsg0wws0w44ggos8_1011', contact_a.id, contact_a.sort_name FROM civicrm_contact contact_a 
WHERE 1 AND ( 1 ) AND (contact_a.is_deleted = 0) ORDER BY `1-phone_ext` asc, `contact_a`.`id` LIMIT 0, 500 [nativecode=1054 ** Unknown column '1-phone_ext' in 'order clause']"] ) 

It is a D9/CiviCRM 5.49.4 with bootstrap extension. PrevNext Cache is on default, this means SQL in my case.

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.