-=Mike=- Posted March 16, 2019 Share Posted March 16, 2019 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 More sharing options...
bsmither Posted March 16, 2019 Share Posted March 16, 2019 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 More sharing options...
-=Mike=- Posted March 16, 2019 Author Share Posted March 16, 2019 Thx removed the lines of code. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted March 18, 2019 Share Posted March 18, 2019 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 More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.