A problem after upgrading databases in a vps server

syriasea

• January 30, 2020 16:35

Hello.. I upgraded databases from version 5.6 to version 5.7 via the whm control panel ... But I got a problem which is .. when I send any message through whmcs or enter technical support or purchase plans .. it gives me the following error HTTP ERROR 500 Note that I rebuilt the Apache after updating the databases, but the error remains of no use ... When I make sql_mode empty by command SET @@ global.sql_mode = ''; The site works well ... But when i start mysql restart ... the error is due to the site ... Likewise, when I create a database to install any software ... it gives an error that cannot connect to the databases Is there any benefit? ?

• 

  ffeingol

  • January 31, 2020 01:41

  Between MySQL V5.5 and 5.7 MySQL started enforcing "strict mode". That may cause some SQL to fail. You can set the sql_mode = "" in /etc/my.cnf by adding: sql_mode="" Or updating it if the sql_mode already exists in your my.cnf. Once you have made the change to /etc/my.conf (I'd suggest backing up the file before modifying it), you'll need to restart MySQL.

  0
• 

  syriasea

  • January 31, 2020 13:08

  Between MySQL V5.5 and 5.7 MySQL started enforcing "strict mode". That may cause some SQL to fail. You can set the sql_mode = "" in /etc/my.cnf by adding: sql_mode="" Or updating it if the sql_mode already exists in your my.cnf. Once you have made the change to /etc/my.conf (I'd suggest backing up the file before modifying it), you'll need to restart MySQL.

  
  Thank you .. I added sql_mode = "" " And it has been updated .. And now it works fine

  0
• 

  cPanelLauren

  • January 31, 2020 17:00

  Glad to see you were able to get this resolved - thanks @ffeingol

  0
• 

  ffeingol

  • January 31, 2020 17:38

  Personally I'd say this is a band-aid, not a fix. The software that you're using should really be corrected/re-coded to work properly with MySQL.

  0

Please sign in to leave a comment.