Jump to content

Error after update to v6.2.4


-=Mike=-

Recommended Posts

After updating to the latest version cubecart,  in the error log i get two problems now dont know how to solve them.

   
 
  File: [controller.index.inc.php] Line: [25] "SET @@time_zone = 'Europe/Amsterdam'" - Unknown or incorrect time zone: 'Europe/Amsterdam'.
 
 

File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'Europe/Amsterdam'" - Unknown or incorrect time zone: 'Europe/Amsterdam'.

 

 

     
Link to comment
Share on other sites

This is a new function in CubeCart. It is designed to make the time that orders were made coincide with a datestamp in the MySQL database. See:
https://github.com/cubecart/v6/issues/2240

In order to do this (send this command to the database server), the database must be configured with an operational table of timezones. This configuration can only be done by the database server's master administrator.

There are a number of similar postings on the forum.

You can either undo the code changes or insist that your hosting provider configure/load the database server with timezone data.

Link to comment
Share on other sites

On 3/17/2019 at 12:49 AM, -=Mike=- said:

Thx removed the lines of code.

Would be much better to simply ask your hosting company to add these tables - I am amazed that most hosting companies dont seem to have this added when it is so simple.  Deleting the lines leaves you potentially open to the problem that this fixes plus it means you have to remember to remove them after each upgrade.  One line may not seem much but making "just a small change" to core code is a very slippery slope that many started down and then ended up getting stuck at a version and not being able to upgrade because suddenly half their core files had been changed

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...