I update to CiviCRM 4.7.7 from 4.7.6 and immediately got errors for my contact search. The contact search in the upper left corner, Find contacts, and Advanced Search. The error I get is:

@import url(http://www.mysite.org/administrator/components/com_civicrm/civicrm/css/civicrm.css); @import url(http://www.mysite.org/administrator/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css); Sorry but we are not able to provide this at the moment.

One of parameters (value: 1-street_address) is not of the type MysqlColumnName

Return to home page.

function toggle( element ) { var parent = element.parentNode; var className = parent.className; if ( className == 'crm-accordion-wrapper collapsed crm-fatal-error-details-block') { parent.className = 'crm-accordion-wrapper crm-fatal-error-details-block'; } else { parent.className = 'crm-accordion-wrapper collapsed crm-fatal-error-details-block'; } }

Anybody else having this problem?

  • One step to take would be to compare to what is happening at civicrm.org/sandboxes
    – petednz - fuzion
    Commented May 6, 2016 at 2:13
  • hmm trying demo/demo and not getting in. sorry not being much help - tried at d46.demo.civicrm.org and hit no issues. Do you really have a column called 1-street_address - that sounds plain wrong. can you check your db
    – petednz - fuzion
    Commented May 6, 2016 at 2:17
  • also confirm the CMS ;-)
    – petednz - fuzion
    Commented May 6, 2016 at 2:18
  • Running CiviCRM 4.7.7 on Joomla 3.5.1, PHP 5.5.32, MySQL 5.5.49 Commented May 6, 2016 at 2:18
  • The front end error shows: One of parameters (value: Home-street_address) is not of the type MysqlColumnName. That is why this weird. I dont have any custom code. is there a way to check the db version info. Maybe it didnt update?? Commented May 6, 2016 at 2:20

1 Answer 1


This is a regression that has been identified in 4.7.7 - thanks for spotting it.

Progress on the issue, and a patch to resolve it, will be posted on the issue tracker here: https://issues.civicrm.org/jira/browse/CRM-18510

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.