ChrisColeman Posted March 7, 2019 Share Posted March 7, 2019 Hi, just installed 6.2.4 and will upgrade 4 stores to the same and create a new one .. One problem - In system error log (many times) .. File: [controller.admin.pre_session.inc.php] Line: [24] "SET @@time_zone = 'Europe/London'" - Unknown or incorrect time zone: 'Europe/London' Is there a fix for this - don't want my clocks to be wrong ? Best Regards. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted March 7, 2019 Share Posted March 7, 2019 Hi Chris This has been covered in several posts on here already but this is caused by your hosting not being compatible wth this release, specifically the mysql server doesn’t have the required timezone information Ian Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 7, 2019 Share Posted March 7, 2019 Hey Chris, Show them this https://dev.mysql.com/doc/refman/8.0/en/time-zone-support.html Link to comment Share on other sites More sharing options...
robertbell Posted March 10, 2019 Share Posted March 10, 2019 What Al said (as always). The hosting company I use made the change on all its servers two hours after I opened a ticket on a Sunday afternoon, so don't be shy about asking. Link to comment Share on other sites More sharing options...
ChrisColeman Posted March 10, 2019 Author Share Posted March 10, 2019 Well I run the server and I need to update mySql (to MariaDB) but cannot do that until several pretty old Cubecart Stores are upgraded ... Regarding the actual error message its probably not doing much harm except filling the logfiles, so i'll turn down the log rotation, complete CubeCart upgrades then update mySQL, and then fix the Time Zone. Many Thanks, ChrisColeman. Link to comment Share on other sites More sharing options...
havenswift-hosting Posted March 11, 2019 Share Posted March 11, 2019 Chris If you have ssh access (which you should do if it is your own server) then one simple shell command as shown under the "Populating the Time Zone tables" section in the link above will solve this issue Ian Link to comment Share on other sites More sharing options...
ChrisColeman Posted March 11, 2019 Author Share Posted March 11, 2019 Many Thanks - Error log empty - Clocks are correct .. I changed mysql password .. Chris. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.