Answers.Body: <p>This is a regression that has been identified in 4.7.7 - thanks for spotting it.</p>
  
  <p>Progress on the issue, and a patch to resolve it, will be posted on the issue tracker here: <a href="https://issues.civicrm.org/jira/browse/CRM-18510" rel="nofollow">https://issues.civicrm.org/jira/browse/CRM-18510</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-05-06T10:25:57.190Z
Answers.LastActivityDate: 2016-05-06T10:25:57.190Z
Answers.UserDisplayName: John
Body: <p>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:</p>
  
  <p>  @import url(<a href="http://www.mysite.org/administrator/components/com_civicrm/civicrm/css/civicrm.css" rel="nofollow">http://www.mysite.org/administrator/components/com_civicrm/civicrm/css/civicrm.css</a>); @import url(<a href="http://www.mysite.org/administrator/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css" rel="nofollow">http://www.mysite.org/administrator/components/com_civicrm/civicrm/bower_components/font-awesome/css/font-awesome.min.css</a>);    Sorry but we are not able to provide this at the moment. </p>
  
  <p>One of parameters (value: <code>1-street_address</code>) is not of the type MysqlColumnName</p>
  
  <p> <p><a href="http://www.mysite.org/administrator/" rel="nofollow" title="Main Menu">Return to home page.</a></p>    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'; } } </p>
  
  <p>Anybody else having this problem?</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-06T02:13:31.817Z
Comments.Text: One step to take would be to compare to what is happening at https://civicrm.org/sandboxes
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-06T02:17:10.170Z
Comments.Text: hmm trying demo/demo and not getting in. sorry not being much help - tried at http://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
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-06T02:18:07.157Z
Comments.Text: also confirm the CMS ;-)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-06T02:18:58.097Z
Comments.Text: Running CiviCRM 4.7.7 on Joomla 3.5.1, PHP 5.5.32, MySQL 5.5.49
Comments.UserDisplayName: Hudson Essex Terraplane Club
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-06T02:20:56.180Z
Comments.Text: 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??
Comments.UserDisplayName: Hudson Essex Terraplane Club
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-06T02:25:32.947Z
Comments.Text: Now that I go back to my test site, I get the same results.  I guess I didn't test it as thoroughly as I thought.  : (
Comments.UserDisplayName: Hudson Essex Terraplane Club
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-06T02:31:15.910Z
Comments.Text: From looking in the database the "1" is just the id for Home.  Basically same error then.
Comments.UserDisplayName: Hudson Essex Terraplane Club
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-05-06T10:12:15.260Z
Comments.Text: We're getting this problem too, after upgrading, except for us it's: One of parameters (value: `1-email`) is not of the type MysqlColumnName   --  you're not alone!
Comments.UserDisplayName: John
Tags: <search><custom-search><quicksearch>
Title: Update to 4.7.7 broke CiviCRM contact search
ThreadText: # Update to 4.7.7 broke CiviCRM contact search
  
  (Asked by: username_0 on 2016-05-06)
  
  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.](http://www.mysite.org/administrator/ "Main Menu")
  
  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?
  
  **Tags:** search, custom-search, quicksearch
  
  > **Comments:**
  > **username_1**: One step to take would be to compare to what is happening at https://civicrm.org/sandboxes  
  > **username_1**: hmm trying demo/demo and not getting in. sorry not being much help - tried at http://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  
  > **username_1**: also confirm the CMS ;-)  
  > **username_0**: Running CiviCRM 4.7.7 on Joomla 3.5.1, PHP 5.5.32, MySQL 5.5.49  
  > **username_0**: 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??  
  > **username_0**: Now that I go back to my test site, I get the same results.  I guess I didn't test it as thoroughly as I thought.  : (  
  > **username_0**: From looking in the database the "1" is just the id for Home.  Basically same error then.  
  > **username_2**: We're getting this problem too, after upgrading, except for us it's: One of parameters (value: `1-email`) is not of the type MysqlColumnName   --  you're not alone!  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2016-05-06. Score: 2
  
  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>
  
  
  ---
  
  