MYSQL timezone support

keat63

• September 16, 2019 13:51

I'm seeing some PHP errors on one of my web sites. The coding guys are telling me that my server doesn't support MYSQL time zones. The server time is correct, and I can see its configured for the correct time zone. Do I need to enable something in MySql ?

• 

  keat63

  • September 17, 2019 07:49

  I've been advised to run the following # mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql The errors appear to have stopped

  0
• 

  cPanelMichael

  • September 17, 2019 15:47

  Hello @keat63, Can you share the specific error messages you viewed on your websites prior to running that command, along with the output of the commands below? # whmapi1 installed_versions packages=0|grep mysql # whmapi1 installed_versions packages=0|grep mariadb # whmapi1 installed_versions packages=0|grep operating_system # whmapi1 installed_versions packages=0|grep php
  Thank you.

  0
• 

  keat63

  • September 19, 2019 13:15

  I'm not sure if this helps, as it was an error being displayed with the application. File: [controller.admin.pre_session.inc.php] Line: [26] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London'
mysql: 5.7.26 mysql_build: 5.7.26-1 operating_system_name: centos operating_system_version: '6.10' apache_php_default_version: 7.0.33-2.2.1 apache_php_versions: cpanel_php: 7.2.7-7
  

  0
• 

  Infopro

  • September 19, 2019 14:06

  I'm not sure if this helps, as it was an error being displayed with the application.

  
  I assume you're aware of this: github.com/cubecart/v6/issues/2256

  0
• 

  keat63

  • September 19, 2019 14:22

  It was actually the Cubecart techs who suggested the ssh command in my second post. I was just following up to show a conclusion.

  0

Please sign in to leave a comment.