Answers.Body: <p>Lots of folks are responding in the comments, but I'll try to give a non-technical answer.</p>
  <p><strong>Short Answer</strong>: You need to upgrade CiviCRM.</p>
  <p><strong>Longer Answer</strong>: CiviCRM is written in a programming language called PHP.  Over time, new versions of PHP come out.  CiviCRM must be updated in response.</p>
  <p>It sounds like your webhost upgraded your PHP version to one that didn't exist when your version of CiviCRM was released.  So any issues introduced by the newer PHP are affecting your experience.  Newer versions of CiviCRM support newer versions of PHP, so you must upgrade CiviCRM.  If you can control your PHP version yourself (some webhosts allow this, others don't) you can try downgrading PHP as a temporary measure, but that's not particularly secure or sustainable.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-05-03T20:17:17.243Z
Answers.LastActivityDate: 2021-05-03T20:17:17.243Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>Here is what is going on.</p>
  <p>I'm trying to do a search within my CiviCRM, however, I'm getting the error message:</p>
  <p>One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias.</p>
  <p>So I'm looking at the following log and one of the messages in the log:</p>
  <p>Warning: &quot;continue&quot; targeting switch is equivalent to &quot;break&quot;. Did you mean to use &quot;continue 2&quot;? in require_once() (line 218 of /home3/isrcus/public_html/sites/all/modules/civicrm/CRM/Core/ClassLoader.php).</p>
  <p>I'm using Drupal 7. Not sure what version of CiviCRM I'm using..</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-05-03T00:31:20.187Z
Comments.Text: version of civi should be at the bottom of any civi admin page, or under Admin > System Status. Also if you can add any history about was this working fine, then broke, and if so what other changes may have coincided with that break
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-05-03T01:08:50.783Z
Comments.Text: I think that would be a fairly old version of civi as that error is a php 7.4 notice which was fixed a long time back
Comments.UserDisplayName: eileen
Tags: <drupal><drupal-7>
Title: CiviCRM Search not working
ThreadText: # CiviCRM Search not working
  
  (Asked by: username_0 on 2021-05-02)
  
  Here is what is going on.
  
  I'm trying to do a search within my CiviCRM, however, I'm getting the error message:
  
  One of parameters (value: sort\_name) is not of the type MysqlColumnNameOrAlias.
  
  So I'm looking at the following log and one of the messages in the log:
  
  Warning: "continue" targeting switch is equivalent to "break". Did you mean to use "continue 2"? in require\_once() (line 218 of /home3/isrcus/public\_html/sites/all/modules/civicrm/CRM/Core/ClassLoader.php).
  
  I'm using Drupal 7. Not sure what version of CiviCRM I'm using..
  
  **Tags:** drupal, drupal-7
  
  > **Comments:**
  > **username_1**: version of civi should be at the bottom of any civi admin page, or under Admin > System Status. Also if you can add any history about was this working fine, then broke, and if so what other changes may have coincided with that break  
  > **username_2**: I think that would be a fairly old version of civi as that error is a php 7.4 notice which was fixed a long time back  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2021-05-03. Score: 2 | Accepted answer
  
  Lots of folks are responding in the comments, but I'll try to give a non-technical answer.
  
  **Short Answer**: You need to upgrade CiviCRM.
  
  **Longer Answer**: CiviCRM is written in a programming language called PHP. Over time, new versions of PHP come out. CiviCRM must be updated in response.
  
  It sounds like your webhost upgraded your PHP version to one that didn't exist when your version of CiviCRM was released. So any issues introduced by the newer PHP are affecting your experience. Newer versions of CiviCRM support newer versions of PHP, so you must upgrade CiviCRM. If you can control your PHP version yourself (some webhosts allow this, others don't) you can try downgrading PHP as a temporary measure, but that's not particularly secure or sustainable.
  
  
  ---
  
  