Answers.Body: <p>Hi managed to get the same issue</p>
  <blockquote>
  <p>One of parameters  (value: total_amount) is not of the type
  MysqlColumnNameOrAlias</p>
  </blockquote>
  <p>I had Drupal 7 and CiviCRM 5.4</p>
  <p>I did recently changed my PHP version to 7.4 - which is the reason for the above error message - I guess I need to upgrade my CiviCRM to latest that should fix the issue(will try and update the result)</p>
  <p>For now I have just changed my PHP version back to 7.2 which worked alright</p>
  <p>Hope this helps!!!</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-08-03T08:18:25.280Z
Answers.LastActivityDate: 2020-08-03T08:18:25.280Z
Answers.UserDisplayName: Ramesh - ARTECH Consultancy
Body: <p>Okay, I'm new at this - honestly, probably not skilled enough to be doing this, but my organization has no money, so, well, I'm it.</p>
  
  <p>I installed on WordPress last year, and everything generally went well. We use the system, it does what we need. Realistically, it might be overkill (we have only about 300 contacts), but I like it.</p>
  
  <p>Then, this year, I noticed that I hadn't kept up with updates. </p>
  
  <p>So - back up, then update. Complete failure. Did not work at all.</p>
  
  <p>Fine. Restore from backup. </p>
  
  <p>So, now, I can get into the system, and using the standard searchbox from "CiviCRM Home", I can find various contacts. Myself, for example - I type in "Ashle...", and there I am. Click on my name/email, and bingo - into my profile.</p>
  
  <p>BUT.</p>
  
  <p>From within my profile screen, click on "Contributions" and get "Sorry but we are not able to provide this at the moment.". Click on "Memberships", and it momentarily seems fine, but then there's a floating box in the right-hand top corner saying "One of the parameters (value: total_amount) is not of the type MysqlColumnNameOrAlias". Moments later, I get a true popup (have to click "OK" to clear) saying "DataTables warning: table id=DataTables_Table_0 - Invalid JSON response. For more information about this error, please see <a href="http://datatables.net/tn/1" rel="nofollow noreferrer">http://datatables.net/tn/1</a>". Click "Groups", and I get a listing of my groups (four, in my case) - but click on one of them, and I get "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.
  One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias"</p>
  
  <p>That last message is the one I get whenever I try nearly anything from the top-bar drop-down menus.</p>
  
  <p>Can anyone suggest a way forward? As it is, I can access names, addresses and some basic data of any of my contacts where I <em>already</em> know their names so that I can go directly to their profile. But I can't really do anything else.</p>
  
  <p>Should I try a new install? ...or do I need to try to monkey with the databases? ...or am I asking the wrong questions? I'm sorry if I'm asking a question that I should have been able to find an answer for elsewhere here on StasckExchange - I did certainly look, but I couldn't find an answer.</p>
  
  <p>Thanks for any help,</p>
  
  <p>Ashley</p>
  
Tags: <wordpress><civimember><contacts><database><mysql>
Title: I get an error "One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias" when trying to access most of my data
ThreadText: # I get an error "One of parameters (value: sort_name) is not of the type MysqlColumnNameOrAlias" when trying to access most of my data
  
  (Asked by: username_0 on 2020-04-09)
  
  Okay, I'm new at this - honestly, probably not skilled enough to be doing this, but my organization has no money, so, well, I'm it.
  
  I installed on WordPress last year, and everything generally went well. We use the system, it does what we need. Realistically, it might be overkill (we have only about 300 contacts), but I like it.
  
  Then, this year, I noticed that I hadn't kept up with updates.
  
  So - back up, then update. Complete failure. Did not work at all.
  
  Fine. Restore from backup.
  
  So, now, I can get into the system, and using the standard searchbox from "CiviCRM Home", I can find various contacts. Myself, for example - I type in "Ashle...", and there I am. Click on my name/email, and bingo - into my profile.
  
  BUT.
  
  From within my profile screen, click on "Contributions" and get "Sorry but we are not able to provide this at the moment.". Click on "Memberships", and it momentarily seems fine, but then there's a floating box in the right-hand top corner saying "One of the parameters (value: total\_amount) is not of the type MysqlColumnNameOrAlias". Moments later, I get a true popup (have to click "OK" to clear) saying "DataTables warning: table id=DataTables\_Table\_0 - Invalid JSON response. For more information about this error, please see <http://datatables.net/tn/1>". Click "Groups", and I get a listing of my groups (four, in my case) - but click on one of them, and I get "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.
  One of parameters (value: sort\_name) is not of the type MysqlColumnNameOrAlias"
  
  That last message is the one I get whenever I try nearly anything from the top-bar drop-down menus.
  
  Can anyone suggest a way forward? As it is, I can access names, addresses and some basic data of any of my contacts where I *already* know their names so that I can go directly to their profile. But I can't really do anything else.
  
  Should I try a new install? ...or do I need to try to monkey with the databases? ...or am I asking the wrong questions? I'm sorry if I'm asking a question that I should have been able to find an answer for elsewhere here on StasckExchange - I did certainly look, but I couldn't find an answer.
  
  Thanks for any help,
  
  username_0
  
  **Tags:** wordpress, civimember, contacts, database, mysql
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2020-08-03. Score: 1 | Accepted answer
  
  Hi managed to get the same issue
  
  > One of parameters (value: total\_amount) is not of the type
  > MysqlColumnNameOrAlias
  
  I had Drupal 7 and CiviCRM 5.4
  
  I did recently changed my PHP version to 7.4 - which is the reason for the above error message - I guess I need to upgrade my CiviCRM to latest that should fix the issue(will try and update the result)
  
  For now I have just changed my PHP version back to 7.2 which worked alright
  
  Hope this helps!!!
  
  
  ---
  
  